All Providers/Developer Tools/Postgres

Postgres

PostgreSQL MCP server for powerful open-source relational database operations. Execute complex queries, manage structured data, support JSON and advanced data types, implement transactions with ACID guarantees, and build scalable database-driven applications. Connect to local databases with: pip install mcpbundles-proxy

This Postgres MCP server is compatible with any MCP client including Claude Desktop, Cursor, and other Model Context Protocol implementations.

Developer Tools

FIELDS

Official Website

Tools From This Provider (38)

Postgres Rollback Preview

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.

Postgres Find Slow Queries

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

Postgres Analyze Table

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

Postgres Vacuum Analyze

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

Postgres Check Missing Indexes

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

Postgres Get Lock Info

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

Postgres Validate Constraints

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

Postgres Find Null Patterns

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

Postgres Check Referential Integrity

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

Postgres Data Quality Report

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

Postgres Detect Outliers

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

Postgres Create Table

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

Postgres Alter Table

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

Postgres Backup Table

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

Postgres Restore Table

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

Postgres Batch Execute

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

Postgres Search Text

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 partial text matches.

Postgres Compare Tables

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.

Postgres Export Table

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

Postgres Get Foreign Key Graph

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

Postgres Find Unused Tables

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

Postgres List Functions

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

Postgres List Triggers

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

Postgres Sample Data

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

Postgres Analyze Indexes

Comprehensive index analysis tool. Without table parameter: finds unused/rarely-used indexes across database for optimization. With table parameter: detailed usage analysis showing which indexes are...

Postgres Find Duplicates

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

Postgres Get Table Dependencies

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

Postgres Get Enum Values

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

Postgres Get Ai Description

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

Postgres Explain Query

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

Postgres Profile Column

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

Postgres Get Table Stats

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

Search

Search PostgreSQL database using SQL queries or structured syntax. Returns ranked results with IDs and titles. Supports SELECT statements and table browsing. Maximum 100 results per search.

Postgres List Tables

List PostgreSQL tables with rich filtering and metadata options. Supports pattern matching, schema filtering, and optional inclusion of columns, relationships, indexes, and row counts.

Postgres List Rows

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

Postgres Execute

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

Postgres Inspect Schema

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

Fetch

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

Related Bundles (6)

Data Exploration

Developer Tools

Browse, search, and sample data in tables. Find records, compare tables, export data, and understand what's in your database.

Data Quality & Profiling

Developer Tools

Profile data, find duplicates, and validate quality. Analyze column statistics, detect outliers, validate constraints, and ensure data integrity.

Development & Operations

Developer Tools

Execute SQL, manage schema, and perform DDL/DML operations safely. Create tables, alter schemas, backup/restore data, and execute transactions with preview capabilities.

Performance Analysis

Developer Tools

Optimize queries, analyze indexes, and find bottlenecks. Understand query performance, identify slow queries, analyze index usage, and maintain database performance.

PostgreSQL

Developer Tools

Complete PostgreSQL database toolkit. All 38 tools for querying, schema management, performance analysis, data quality, and development operations.

Schema Discovery

Developer Tools

Understand database structure, relationships, and dependencies. Explore tables, foreign keys, functions, triggers, and understand how your database is organized.

Provider Information

CategoryDeveloper Tools

Auth TypeFIELDS

AddedOctober 12, 2025

UpdatedDecember 20, 2025

Used By Tools

38

Quick Links

Official Website

Need Help?

Having trouble configuring Postgres? Check the available resources below.

Browse Other Providers