---
title: "Gets project security advisors."
method: GET
path: "/v1/projects/{ref}/advisors/security"
tags: ["Advisors"]
deprecated: true
---

# Gets project security advisors.

`GET /v1/projects/{ref}/advisors/security`

> **Deprecated.**

This is an **experimental** endpoint. It is subject to change or removal in future versions. Use it with caution, as it may not remain supported or stable.

## Path parameters

- `ref` string, required

## Query parameters

- `lint_type` 'sql'

## Response `200`

- V1ProjectAdvisorsResponse
  - `lints` object[], required
    - `name` 'unindexed_foreign_keys' | 'auth_users_exposed' | 'auth_rls_initplan' | 'no_primary_key' | 'unused_index' | 'multiple_permissive_policies' | 'policy_exists_rls_disabled' | 'rls_enabled_no_policy' | 'duplicate_index' | 'security_definer_view' | 'function_search_path_mutable' | 'rls_disabled_in_public' | 'extension_in_public' | 'rls_references_user_metadata' | 'materialized_view_in_api' | 'foreign_table_in_api' | 'unsupported_reg_types' | 'auth_otp_long_expiry' | 'auth_otp_short_length' | 'ssl_not_enforced' | 'network_restrictions_not_set' | 'password_requirements_min_length' | 'pitr_not_enabled' | 'auth_leaked_password_protection' | 'auth_insufficient_mfa_options' | 'auth_password_policy_missing' | 'leaked_service_key' | 'no_backup_admin' | 'vulnerable_postgres_version', required
    - `title` string, required
    - `level` 'ERROR' | 'WARN' | 'INFO', required
    - `facing` 'EXTERNAL', required
    - `categories` string[], required
    - `description` string, required
    - `detail` string, required
    - `remediation` string, required
    - `metadata` object
      - `schema` string
      - `name` string
      - `entity` string
      - `type` 'table' | 'view' | 'auth' | 'function' | 'extension' | 'compliance'
      - `fkey_name` string
      - `fkey_columns` number[]
    - `cache_key` string, required

## Other responses

- `401` — Unauthorized
- `403` — Forbidden action
- `429` — Rate limit exceeded

---

[API](https://skmtc.dev/supabase/apis/management-api.md) · [All operations](https://skmtc.dev/supabase/apis/management-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/supabase/management-api/revisions/a7cb39418064/schema)