Database Linter Rules

Below is the list of database linting rules supported by the Postgres Language Server, divided by group. These rules analyze your live database schema to detect issues.

All rules are powered by Splinter.

Here's a legend of the emojis:

• The icon ✅ indicates that the rule is part of the recommended rules.
• The icon ⚡ indicates that the rule requires a Supabase database.

Performance

Rules that detect potential performance issues in your database schema.

Rule name	Description	Properties
authRlsInitplan	Detects if calls to `current_setting()` and `auth.()` in RLS policies are being unnecessarily re-evaluated for each row	✅ ⚡
duplicateIndex	Detects cases where two ore more identical indexes exist.	✅
multiplePermissivePolicies	Detects if multiple permissive row level security policies are present on a table for the same `role` and `action` (e.g. insert). Multiple permissive policies are suboptimal for performance as each policy must be executed for every relevant query.	✅
noPrimaryKey	Detects if a table does not have a primary key. Tables without a primary key can be inefficient to interact with at scale.	✅
tableBloat	Detects if a table has excess bloat and may benefit from maintenance operations like vacuum full or cluster.	✅
unindexedForeignKeys	Identifies foreign key constraints without a covering index, which can impact database performance.	✅
unusedIndex	Detects if an index has never been used and may be a candidate for removal.	✅

Security

Rules that detect potential security vulnerabilities in your database schema.

Rule name	Description	Properties
authUsersExposed	Detects if auth.users is exposed to anon or authenticated roles via a view or materialized view in schemas exposed to PostgREST, potentially compromising user data security.	✅ ⚡
extensionInPublic	Detects extensions installed in the `public` schema.	✅
extensionVersionsOutdated	Detects extensions that are not using the default (recommended) version.	✅
fkeyToAuthUnique	Detects user defined foreign keys to unique constraints in the auth schema.	✅ ⚡
foreignTableInApi	Detects foreign tables that are accessible over APIs. Foreign tables do not respect row level security policies.	✅ ⚡
functionSearchPathMutable	Detects functions where the search_path parameter is not set.	✅
insecureQueueExposedInApi	Detects cases where an insecure Queue is exposed over Data APIs	✅ ⚡
materializedViewInApi	Detects materialized views that are accessible over the Data APIs.	✅ ⚡
policyExistsRlsDisabled	Detects cases where row level security (RLS) policies have been created, but RLS has not been enabled for the underlying table.	✅
rlsDisabledInPublic	Detects cases where row level security (RLS) has not been enabled on tables in schemas exposed to PostgREST	✅ ⚡
rlsEnabledNoPolicy	Detects cases where row level security (RLS) has been enabled on a table but no RLS policies have been created.	✅
rlsReferencesUserMetadata	Detects when Supabase Auth user_metadata is referenced insecurely in a row level security (RLS) policy.	✅ ⚡
securityDefinerView	Detects views defined with the SECURITY DEFINER property. These views enforce Postgres permissions and row level security policies (RLS) of the view creator, rather than that of the querying user	✅ ⚡
unsupportedRegTypes	Identifies columns using unsupported reg* types outside pg_catalog schema, which prevents database upgrades using pg_upgrade.	✅