Report the active profile, access policy, and hard execution limits

List all schemas in the database

List tables, views, sequences, or extensions

Show columns, constraints, indexes, and comments for a database object

Report PostgreSQL version, database, role, recovery, locale, and installed extensions

List installed or available PostgreSQL extension capability profiles

Report conservative PostgreSQL deployment-provider capabilities without secrets

Inventory PostgreSQL objects owned by one installed extension through core catalogs

Report bounded PostGIS columns and indexes through PostgreSQL core catalogs

Report bounded pgvector columns and indexes through PostgreSQL core catalogs

Search relations, routines, types, collations, and extensions

List tables, partitions, views, sequences, foreign tables, indexes, and other relations

Inspect a relation's columns, constraints, indexes, triggers, policies, partitions, and privileges

List built-in, user-defined, and extension-owned PostgreSQL types by OID

Inspect any PostgreSQL type, including enum, domain, composite, range, multirange, array, and extension types

Select bounded rows using catalog-validated identifiers, typed filters, and keyset pagination

Insert bounded typed rows with exact affected-row commit guards

Upsert typed rows through a verified primary or unique conflict key

Update typed values with mandatory filters, optimistic predicates, and commit guards

Delete rows with mandatory filters, optimistic predicates, and commit guards

Create a deterministic reviewed PostgreSQL migration plan without touching the database

Apply a reviewed fully transactional migration and its ledger row atomically

List redacted reviewed migration ledger metadata

Atomically roll back the latest reviewed migration using its stored verified plan

Create a reviewed nontransactional PostgreSQL maintenance plan

Apply an exact reviewed nontransactional maintenance plan

List redacted reviewed maintenance status records

Reconcile a reviewed maintenance operation after external outcome verification

Explain a SQL query and optionally simulate hypothetical indexes

Analyze frequently executed queries and recommend indexes

Analyze up to ten SQL queries and recommend indexes

Analyze database health. Valid values: index, connection, vacuum, sequence, replication, buffer, constraint, all; comma-separated values are accepted.

Report slow or resource-intensive queries using pg_stat_statements

Return privacy-preserving aggregate runtime metrics for the current process

Execute exactly one read-only, parameterized SQL statement with bounded results