Postgres Scout Mcp
by bluworkcommunityv1.0.3
Postgres Scout is a Model Context Protocol server designed to monitor and analyze PostgreSQL databases, providing health scores and recommendations for optimization and data quality.
From the registry: Scout your PostgreSQL databases with AI - safety features, monitoring, and data quality
Install & configure
Prerequisites
- requiredPostgreSQL databasePostgreSQL connection string
Install in your client
Paste into the AI you're chatting with — it will figure out the rest
Please install the `postgres-scout-mcp` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **PostgreSQL database** — PostgreSQL connection string
Canonical MCP server config (stdio transport):
- command: `npx`
- args: ["-y","postgres-scout-mcp","postgresql://localhost:5432/mydb"]
Note: 38 tools covering exploration, diagnostics, optimization, monitoring, data quality, and safe writes. Read-only by default. Add --read-write flag to enable write operations. Passes connection string as positional argument.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.Note: 38 tools covering exploration, diagnostics, optimization, monitoring, data quality, and safe writes. Read-only by default. Add --read-write flag to enable write operations. Passes connection string as positional argument.
Tools (17)
getHealthScore
returns overall health score with component breakdown
listDatabases
lists databases the user has access to
getDatabaseStats
provides size, cache hit ratio, and connection info
listSchemas
lists all schemas in the current database
listTables
provides tables with size and row statistics
describeTable
details columns, constraints, indexes, and more
executeQuery
runs SELECT queries or writes in read-write mode
explainQuery
provides EXPLAIN plans for performance analysis
optimizeQuery
gives optimization recommendations for a specific query
detectAnomalies
identifies anomalies in performance, connections, and data
analyzeTableBloat
analyzes bloat for VACUUM planning
getSlowQueries
analyzes slow queries
suggestIndexes
recommends missing indexes from query patterns
getCurrentActivity
Environment variables
QUERY_TIMEOUTrequiredQuery timeout in millisecondsMAX_RESULT_ROWSrequiredMaximum rows returned per queryENABLE_RATE_LIMITrequiredEnable rate limitingRATE_LIMIT_MAX_REQUESTSrequiredRequests per rate limit windowRATE_LIMIT_WINDOW_MSrequiredRate limit window in millisecondsPackages
postgres-scout-mcp
npmv1.0.3transport: stdio
Details
- Language
- TypeScript
- License
- Apache-2.0
- Released
- Mar 7, 2026
- Last commit
- Mar 7, 2026
- Registry name
- io.github.bluwork/postgres-scout-mcp