The admin-only audit trail of executed queries
A searchable history of statements, outcomes and error detail, readable by admins only, and on this engine it also records what the agent was permitted to run.
9 posts
Writing on PostgreSQL
The reference engine — pooled connections, full catalog introspection, visual EXPLAIN, ER diagrams, live health and agent mode. Where it stops: Nothing held back — every capability in the product ships here, including agent mode.
What a pasted managed PostgreSQL URL configures
Host-heuristic SSL turns encryption on without verifying the certificate, and two sslmode values are declined by name rather than guessed at.
Which PostgreSQL health numbers need an extension or a grant
A tour of the health surface organised by what is missing and why, because a panel that reads Not measured is the only version an operator can act on.
The Explain button runs your query, the agent plan read does not
Two EXPLAIN forms with different consequences: the editor emits the executing one, and the agent path emits the planning one only.
Foreign-key diagrams on a schema with a hundred tables
The schema tree renders before relationships arrive, and every introspection CTE is materialized on purpose: a 122-table read measured about 295 seconds before the change and about 2.6 seconds after.
How the editor bounds a PostgreSQL result set
Automatic LIMIT injection applies to unbounded SELECT and CTE-SELECT statements only, and there is one statement shape it deliberately leaves alone.
Connecting Studio to PostgreSQL running in Docker
The container-to-container case is the one that breaks: when Studio is itself a container, localhost is its own loopback and the service name is the fix.
Where the read-only boundary lives on a PostgreSQL agent run
Containment is the database itself - a read-only transaction, exactly one statement on the extended protocol, then ROLLBACK and DISCARD ALL.
Creating the PostgreSQL role agent mode will accept
Agent AUTO mode refuses a superuser connection outright, so the deployment task is a login holding CONNECT, USAGE and SELECT and nothing else.