Skip to content

Advisors

Tested with: Not yet available on Databasezy · describes the launch design

The advisors check a Postgres instance for common security and performance problems and explain how to fix each one.

AreaExamples
SecurityTables exposed through the Data API without row-level security, views that bypass policies (security definer), auth data reachable by anon, functions with a mutable search_path
PerformanceForeign keys without an index, unused and duplicate indexes, slow queries from pg_stat_statements

Each finding links to the object, explains the risk and shows the SQL that fixes it.