PostgreSQL MCP Server

Universal fetch tool that retrieves any row, table schema, or metadata using smart ID routing with colon-separated format. Supports direct row retriev...

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

Full index analysis tool. Without table parameter: finds unused/rarely-used indexes across database for optimization. With table parameter: detailed u...

Run ANALYZE on a table to update query planner statistics. Returns updated statistics after analysis. Essential for maintaining query performance.

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.

Identify potential missing indexes by analyzing foreign keys and columns frequently used in WHERE clauses. Suggests CREATE INDEX statements for optimi...

Find orphaned foreign key references - rows that reference non-existent parent rows. Critical for data integrity validation.

Compare two tables to find rows that differ. Shows rows present in one table but not the other, and rows with different values in specified columns.

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

Generate detailed data quality report including duplicates, NULLs, constraint violations, and referential integrity. One-stop analysis for data qualit...

Detect statistical outliers in numeric columns using IQR (Interquartile Range) or z-score methods. Useful for data quality analysis and anomaly detect...

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

Analyze query performance with EXPLAIN ANALYZE. Returns execution plan with actual timing, rows processed, and performance bottlenecks. Essential for ...

Export table data to CSV or JSON format. Useful for data migration, backups, or analysis in external tools. Returns chunked data for large tables.

Find duplicate rows based on specified columns. Returns groups of duplicates with counts. Essential for data quality audits and cleanup.

Analyze NULL value distribution across columns. Shows which columns have high NULL percentages and identifies data quality issues.

Find slow queries from pg_stat_statements extension. Requires pg_stat_statements extension to be enabled. Returns queries sorted by total execution ti...

Find tables that are not referenced by foreign keys, views, materialized views, or functions. Useful for identifying orphaned tables that may be safe ...

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

Find columns with enum-like behavior (limited distinct values) and show value frequencies. Useful for understanding categorical data and identifying c...

Build a graph representation of foreign key relationships showing which tables reference which other tables. Returns nodes (tables) and edges (FK rela...

Show current database locks and identify blocking queries. Helps diagnose performance issues and deadlocks. Shows which queries are waiting for locks ...

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

Get detailed table statistics: size on disk, index sizes, row count, last vacuum/analyze time, and dead tuple ratio. Essential for capacity planning a...

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

List PostgreSQL stored procedures and functions with their parameters, return types, and definitions. Useful for understanding database logic and stor...

Browse rows from a PostgreSQL table with filtering, column selection, sorting, and pagination. The workhorse tool for exploring data with granular con...

List PostgreSQL tables with rich filtering and metadata options. Supports pattern matching, schema filtering, and optional inclusion of columns, relat...

List PostgreSQL triggers with their event types (INSERT, UPDATE, DELETE), timing (BEFORE, AFTER), and action statements. Essential for understanding d...

Profile a column's data distribution: min, max, avg, median, distinct count, null percentage, and most frequent values. Replaces writing multiple anal...

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

Get statistically representative random sample from table using TABLESAMPLE. Much faster than LIMIT on large tables. Perfect for quick data exploratio...

Full-text search across text columns in one or more tables. Finds rows containing the search text in any text column. Useful for finding records by pa...

Analyze tables and suggest VACUUM and ANALYZE operations based on dead tuple ratio and last analyze time. Helps maintain database performance and recl...

Validate that all constraints (CHECK, NOT NULL, UNIQUE, FOREIGN KEY) are satisfied. Finds rows that violate constraints.

Search PostgreSQL database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Supports SELECT statements and table br...