Postgres Scout Mcp
Connects Claude to PostgreSQL with 38 tools spanning diagnostics, optimization, and data quality checks. You get health scores with component breakdowns, bloat analysis, slow query detection, and missing index suggestions. It runs read-only by default with a separate read-write mode for safe updates and deletes that preview changes before committing. Built-in safety features include parameterized queries, rate limiting, query timeouts, and automatic credential redaction in logs. Useful when you need to diagnose production database issues, find orphaned records or duplicates, analyze lock contention, or get optimization recommendations without writing custom SQL scripts.
- tools
- 38
- transport
- STDIO
- last updated
- Mar 7, 2026
Tools
38 toolsPublic tool metadata for what this MCP can expose to an agent.
listDatabasesdatabases the user has access to
databases the user has access to
No parameter schema in public metadata yet.
getDatabaseStatssize, cache hit ratio, connection info
size, cache hit ratio, connection info
No parameter schema in public metadata yet.
listSchemasall schemas in the current database
all schemas in the current database
No parameter schema in public metadata yet.
listTablestables with size and row statistics
tables with size and row statistics
No parameter schema in public metadata yet.
describeTablecolumns, constraints, indexes, and more
columns, constraints, indexes, and more
No parameter schema in public metadata yet.
executeQueryrun SELECT queries (or writes in read-write mode)
run SELECT queries (or writes in read-write mode)
No parameter schema in public metadata yet.
explainQueryEXPLAIN plans for performance analysis
EXPLAIN plans for performance analysis
No parameter schema in public metadata yet.
optimizeQueryoptimization recommendations for a specific query
optimization recommendations for a specific query
No parameter schema in public metadata yet.
getHealthScoreoverall health score with component breakdown
overall health score with component breakdown
No parameter schema in public metadata yet.
detectAnomaliesanomalies in performance, connections, and data
anomalies in performance, connections, and data
No parameter schema in public metadata yet.
analyzeTableBloatbloat analysis for VACUUM planning
bloat analysis for VACUUM planning
No parameter schema in public metadata yet.
getSlowQueriesslow query analysis (requires pg_stat_statements)
slow query analysis (requires pg_stat_statements)
No parameter schema in public metadata yet.
suggestVacuumVACUUM recommendations based on dead tuples and bloat
VACUUM recommendations based on dead tuples and bloat
No parameter schema in public metadata yet.
suggestIndexesmissing index recommendations from query patterns
missing index recommendations from query patterns
No parameter schema in public metadata yet.
suggestPartitioningpartitioning strategies for large tables
partitioning strategies for large tables
No parameter schema in public metadata yet.
getIndexUsageidentify unused or underused indexes
identify unused or underused indexes
No parameter schema in public metadata yet.
getCurrentActivityactive queries and connections
active queries and connections
No parameter schema in public metadata yet.
analyzeLockslock contention and blocking queries
lock contention and blocking queries
No parameter schema in public metadata yet.
getLiveMetricsreal-time metrics over a time window
real-time metrics over a time window
No parameter schema in public metadata yet.
getHottestTablestables with highest activity
tables with highest activity
No parameter schema in public metadata yet.
getTableMetricscomprehensive per-table I/O and scan stats
comprehensive per-table I/O and scan stats
No parameter schema in public metadata yet.
findDuplicatesduplicate rows by column combination
duplicate rows by column combination
No parameter schema in public metadata yet.
findMissingValuesNULL analysis across columns
NULL analysis across columns
No parameter schema in public metadata yet.
findOrphansorphaned records with invalid foreign keys
orphaned records with invalid foreign keys
No parameter schema in public metadata yet.
checkConstraintViolationstest constraints before adding them
test constraints before adding them
No parameter schema in public metadata yet.
analyzeTypeConsistencytype inconsistencies in text columns
type inconsistencies in text columns
No parameter schema in public metadata yet.
exploreRelationshipsmulti-hop foreign key traversal
multi-hop foreign key traversal
No parameter schema in public metadata yet.
analyzeForeignKeysforeign key health and performance
foreign key health and performance
No parameter schema in public metadata yet.
findRecentrows within a time window
rows within a time window
No parameter schema in public metadata yet.
analyzeTimeSerieswindow functions and anomaly detection
window functions and anomaly detection
No parameter schema in public metadata yet.
detectSeasonalityseasonal pattern detection
seasonal pattern detection
No parameter schema in public metadata yet.
exportTableCSV, JSON, JSONL, or SQL
CSV, JSON, JSONL, or SQL
No parameter schema in public metadata yet.
generateInsertStatementsINSERT statements for migration
INSERT statements for migration
No parameter schema in public metadata yet.
previewUpdatesee what would change before committing
see what would change before committing
No parameter schema in public metadata yet.
previewDeletesee what would change before committing
see what would change before committing
No parameter schema in public metadata yet.
safeUpdateUPDATE with dry-run, row limits, empty WHERE protection
UPDATE with dry-run, row limits, empty WHERE protection
No parameter schema in public metadata yet.
safeDeleteDELETE with dry-run, row limits, empty WHERE protection
DELETE with dry-run, row limits, empty WHERE protection
No parameter schema in public metadata yet.
safeInsertINSERT with validation, batching, ON CONFLICT support
INSERT with validation, batching, ON CONFLICT support
No parameter schema in public metadata yet.
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageReadme
Postgres Scout MCP
Scout your PostgreSQL databases with AI - A production-ready Model Context Protocol server with built-in safety features, monitoring, and data quality tools.
What You Get
You ask:
"How healthy is my production database? Any urgent issues?"
Postgres Scout returns:
Overall Health Score: 78/100
Component Breakdown
| Component | Score | Status |
|---|---|---|
| Cache Performance | 94/100 | Healthy |
| Index Efficiency | 82/100 | Good |
| Table Bloat | 61/100 | Needs Attention |
| Connection Usage | 75/100 | Fair |
Issues Found
- HIGH — Table
ordershas 34% bloat (2.1 GB wasted). VACUUM FULL recommended. - MEDIUM — 3 unused indexes on
sessionsconsuming 890 MB. - LOW — Cache hit ratio for
analytics_eventsis 71% (target: >90%).
Details
- Repository
- github.com/bluwork/postgres-scout-mcp
- Categories
- Databases, Data & Analytics
- Package
postgres-scout-mcp- Transport
- STDIO
- Registry
- MCP registry, active
More from bluwork
Related Databases MCP servers
View all
Mcp Mysql Connectordaedalus/mcp-mysql-connectorMCP server exposing MySQL database functionalities as tools0stars
PostgreSQL MCP Serveritunified-io/mcp-postgresPostgreSQL MCP Server — 27 tools for queries, schema, CRUD, DBA, HA & server management0stars
PostgreSQL MCP Servermusaddiq-dev/postgresql-mcp-serverPython MCP server for PostgreSQL database inspection and querying0stars
Mcp Neo4j Aura Managerneo4j-contrib/mcp-neo4jMCP server for Neo4j Aura Database Instance Manager.958stars