PostgreSQL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

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