Development & Operations

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

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

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

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

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...

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

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

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...