All Providers/Developer Tools/Postgres

Postgres

PostgreSQL is a powerful open-source relational database system

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

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

Postgres Analyze Table

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

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

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

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

Postgres Validate Constraints

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

Postgres Find Null Patterns

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

Postgres Check Referential Integrity

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

Postgres Data Quality Report

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

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

Postgres Create Table

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

Postgres Alter Table

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

Postgres Backup Table

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

Postgres Restore Table

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

Postgres Batch Execute

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

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

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

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

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

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

Postgres List Functions

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

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

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

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

Postgres Find Duplicates

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

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

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

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

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

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

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

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

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

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

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

Postgres Inspect Schema

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

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

Related Bundles (6)

Data Exploration

10 tools
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

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

Development & Operations

10 tools
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

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

PostgreSQL

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

Schema Discovery

10 tools
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
UpdatedNovember 3, 2025
Used By Tools
38

Quick Links

Official Website

Need Help?

Having trouble configuring Postgres? Check the available resources below.

Browse Other Providers