Report the server's current access mode and safety configuration so you know which write operations (if any) are permitted before attempting them.

List user schemas (excludes pg_catalog / information_schema / temp).

List tables, partitioned tables, views and materialized views in a schema, with comment, estimated row count and on-disk size.

Full description of a table/view: columns (type, nullable, default, identity/generated, comment) plus its primary key.

All constraints on a table (primary key, unique, foreign key, check, exclusion) with their full definitions.

Foreign-key relationships for a table: outgoing (FKs this table declares) and incoming (other tables referencing this one). Use this to understand the data-flow impact before any write.

Indexes on a table, with full CREATE INDEX definitions and flags.

List triggers in a schema (optionally filtered to one table), with their full CREATE TRIGGER definitions. Excludes internal/constraint triggers. Important to review before writes: triggers may cascade side effects.

List functions and procedures in a schema (signature, return type, language, kind). Use get_function_definition for the full source.

Full source (CREATE OR REPLACE ...) of a function or procedure. If the name is overloaded, pass arguments (e.g. "integer, text") to disambiguate.

List views and materialized views in a schema, with their SQL definitions.

List enum types in a schema with their ordered labels.

Size and activity statistics for a table (live/dead rows, sizes, last vacuum/analyze, sequential vs index scans).

Run a single read-only SELECT/WITH/EXPLAIN/SHOW statement and return rows.

This tool rejects non-read and multi-statement SQL and caps returned rows. (In readonly access mode the DB session is also read-only at the engine.)