Development & Operations

Find all database objects that depend on a table: views, materialized views, triggers, and functions. Critical before dropping or altering tables.

Execute SQL statements on PostgreSQL database. Supports all SQL operations including SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER. Use with cau...

Get compact, token-efficient database schema description optimized for AI text-to-SQL. Returns tables with columns, types, relationships, and sample v...

Restore table from backup created by postgres_backup_table. Can optionally drop existing table first.

Preview which rows would be affected by a DELETE or UPDATE statement without actually executing it. Shows sample rows that would be changed or deleted...

Perform safe ALTER TABLE operations including adding/dropping columns, changing types, renaming columns, and adding constraints.

Inspect PostgreSQL schema or table in detail. Get comprehensive information about tables, columns, relationships, indexes, and constraints.

Create a new table with specified columns and constraints. Generates CREATE TABLE statement from schema definition.

Execute multiple SQL statements in a single transaction. All statements succeed or all fail (atomicity). Useful for bulk operations.

Create a backup copy of a table including structure and optionally data. Useful before making destructive changes.