Gets project performance advisors.

experimental

1
{
2
  "lints": [
3
    {
4
      "name": "unindexed_foreign_keys",
5
      "title": "lorem",
6
      "level": "ERROR",
7
      "facing": "EXTERNAL",
8
      "categories": [
9
        "PERFORMANCE"
10
      ],
11
      "description": "lorem",
12
      "detail": "lorem",
13
      "remediation": "lorem",
14
      "metadata": {
15
        "schema": "lorem",
16
        "name": "lorem",
17
        "entity": "lorem",
18
        "type": "table",
19
        "fkey_name": "lorem",
20
        "fkey_columns": [
21
          42
22
        ]
23
      },
24
      "cache_key": "lorem",
25
      "observed_at": "4404-02-29T04:24Z"
26
    }
27
  ]
28
}

1
{
2
  "type": "object",
3
  "properties": {
4
    "lints": {
5
      "type": "array",
6
      "items": {
7
        "type": "object",
8
        "properties": {
9
          "name": {
10
            "type": "string",
11
            "enum": [
12
              "unindexed_foreign_keys",
13
              "auth_users_exposed",
14
              "auth_rls_initplan",
15
              "no_primary_key",
16
              "unused_index",
17
              "multiple_permissive_policies",
18
              "policy_exists_rls_disabled",
19
              "rls_enabled_no_policy",
20
              "duplicate_index",
21
              "security_definer_view",
22
              "function_search_path_mutable",
23
              "rls_disabled_in_public",
24
              "extension_in_public",
25
              "rls_references_user_metadata",
26
              "materialized_view_in_api",
27
              "foreign_table_in_api",
28
              "unsupported_reg_types",
29
              "auth_otp_long_expiry",
30
              "auth_otp_short_length",
31
              "ssl_not_enforced",
32
              "log_connections_not_enabled",
33
              "network_restrictions_not_set",
34
              "password_requirements_min_length",
35
              "pitr_not_enabled",
36
              "auth_leaked_password_protection",
37
              "auth_insufficient_mfa_options",
38
              "auth_password_policy_missing",
39
              "leaked_service_key",
40
              "no_backup_admin",
41
              "vulnerable_postgres_version",
42
              "db_not_reachable",
43
              "db_connection_failing",
44
              "db_connection_limit_reached",
45
              "instance_telemetry_lost",
46
              "instance_db_down",
47
              "instance_alert_firing",
48
              "log_data_api_error_rate_high",
49
              "log_auth_error_rate_high",
50
              "log_storage_error_rate_high",
51
              "log_edge_function_error_rate_high",
52
              "realtime_authorization_timeouts",
53
              "realtime_postgres_changes_spike",
54
              "realtime_concurrent_users_near_limit",
55
              "project_not_active",
56
              "advisor_check_unavailable"
57
            ]
58
          },
59
          "title": {
60
            "type": "string"
61
          },
62
          "level": {
63
            "type": "string",
64
            "enum": [
65
              "ERROR",
66
              "WARN",
67
              "INFO"
68
            ]
69
          },
70
          "facing": {
71
            "type": "string",
72
            "enum": [
73
              "EXTERNAL"
74
            ]
75
          },
76
          "categories": {
77
            "type": "array",
78
            "items": {
79
              "type": "string",
80
              "enum": [
81
                "PERFORMANCE",
82
                "SECURITY",
83
                "HEALTH"
84
              ]
85
            },
86
            "x-ignore-array-items-must-be-objects": true
87
          },
88
          "description": {
89
            "type": "string"
90
          },
91
          "detail": {
92
            "type": "string"
93
          },
94
          "remediation": {
95
            "type": "string"
96
          },
97
          "metadata": {
98
            "type": "object",
99
            "properties": {
100
              "schema": {
101
                "type": "string"
102
              },
103
              "name": {
104
                "type": "string"
105
              },
106
              "entity": {
107
                "type": "string"
108
              },
109
              "type": {
110
                "type": "string",
111
                "enum": [
112
                  "table",
113
                  "view",
114
                  "materialized view",
115
                  "foreign table",
116
                  "auth",
117
                  "function",
118
                  "extension",
119
                  "compliance",
120
                  "health"
121
                ]
122
              },
123
              "fkey_name": {
124
                "type": "string"
125
              },
126
              "fkey_columns": {
127
                "x-ignore-array-items-must-be-objects": true,
128
                "type": "array",
129
                "items": {
130
                  "type": "number"
131
                }
132
              }
133
            }
134
          },
135
          "cache_key": {
136
            "type": "string"
137
          },
138
          "observed_at": {
139
            "type": "string",
140
            "format": "date-time",
141
            "pattern": "^(?:(?:\\d\\d[2468][048]|\\d\\d[13579][26]|\\d\\d0[48]|[02468][048]00|[13579][26]00)-02-29|\\d{4}-(?:(?:0[13578]|1[02])-(?:0[1-9]|[12]\\d|3[01])|(?:0[469]|11)-(?:0[1-9]|[12]\\d|30)|(?:02)-(?:0[1-9]|1\\d|2[0-8])))T(?:(?:[01]\\d|2[0-3]):[0-5]\\d(?::[0-5]\\d(?:\\.\\d+)?)?(?:Z))$"
142
          }
143
        },
144
        "required": [
145
          "name",
146
          "title",
147
          "level",
148
          "facing",
149
          "categories",
150
          "description",
151
          "detail",
152
          "remediation",
153
          "cache_key"
154
        ]
155
      }
156
    }
157
  },
158
  "required": [
159
    "lints"
160
  ]
161
}