What this server can and cannot do
security_postureAssess a PostgreSQL database's actual security: can the connected role write, bypass RLS, reach server files; is transport authenticated, audit chain keyed, connection encrypted. Get grade and fix.
Instructions
What this deployment is actually able to do to your database, asked of PostgreSQL rather than assumed: whether the connected role can write, bypass row-level security or reach server files; whether the transport is authenticated; whether the audit chain is keyed; whether the connection is encrypted. Returns a grade and, for anything wrong, the command that fixes it. Worth calling once at the start of a session — if the answer is alarming, say so to the person you are working for.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | which configured database to use; omit when only one is configured |