Connect to a PostgreSQL server target. If multiple targets are configured, specify which one. Otherwise connects to the default target.

Disconnect from a PostgreSQL server target. Omit profile to disconnect all.

Check connection pool health for the active profile or a specific named profile.

List all configured connection profiles and their status. Each profile represents a PostgreSQL server instance.

Switch the active connection profile. All subsequent queries will use this profile unless overridden.

Execute a parameterized SQL query. Returns rows as JSON. Use $1, $2, ... for parameters.

Run EXPLAIN on a query. mode=plan (default, safe) shows the plan without executing. mode=analyze executes the statement and shows actual timing — requires confirm=true.

[DEPRECATED] Manage named prepared statements: PREPARE, EXECUTE, DEALLOCATE. Prepared statements are session-local and unreliable with connection pools. Use parameterized pg_query instead.

List all schemas in the database.

List tables in the database. Optionally filter by schema name.

Describe a table: columns, data types, defaults, nullability, and constraints.

List indexes for a table with type, columns, uniqueness, and size.

List constraints (primary key, foreign key, unique, check) for a table.

List views with their definitions. Optionally filter by schema.

List functions and procedures with their signatures.

List all enum types and their values.

List installed PostgreSQL extensions with versions.

Insert one or more rows into a table. Returns inserted rows.

Update rows matching a WHERE clause. Requires confirm=true.

Delete rows matching a WHERE clause. Requires confirm=true.

Insert or update on conflict. Requires confirm=true.

Get PostgreSQL version string and numeric version.

Show or search server configuration parameters.

Reload server configuration files (postgresql.conf). Requires confirm=true.

Show server uptime and start time.

Show size of all databases.

Show table sizes with index and toast breakdown, sorted by total size descending.