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.
Checks (at launch)
Section titled “Checks (at launch)”| Area | Examples |
|---|---|
| Security | Tables 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 |
| Performance | Foreign 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.