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

API KEY

Official Website

Tools From This Provider (15)

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

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

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.

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.

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.

Related Bundles (1)

Postgres Tools

15 tools

Primary

Developer Tools

PostgreSQL is a powerful open-source relational database system

Provider Information

Verification

Unverified

CategoryDeveloper Tools

Auth TypeAPI KEY

AddedOctober 12, 2025

UpdatedOctober 19, 2025

Approval

Required

Used By Tools

Quick Links

Official Website

Need Help?

Having trouble configuring Postgres? Check the available resources below.

Browse Other Providers