MCP server
Postgres MCP Pro
Postgres access for agents, with index tuning and health checks alongside plain SQL.
Add it to your client
CommunityInstall
uvx postgres-mcp --access-mode=restricted
mcpServers
{
"mcpServers": {
"postgres-mcp": {
"command": "uvx",
"args": [
"postgres-mcp",
"--access-mode=restricted"
]
}
}
}- Transport
- both
- Runtime
- Python
- Auth
- Required
- Tools
- 9
- License
- MIT
Tools
list_schemaslist_objectsget_object_detailsexecute_sqlexplain_queryget_top_queriesanalyze_workload_indexesanalyze_query_indexesanalyze_db_health
Connects to a PostgreSQL instance through a connection string and exposes schema listing, SQL execution and EXPLAIN plans as tools. Beyond running queries it scans the workload to propose index candidates and reports health signals such as cache hit rates, vacuum status and connection utilisation. The access mode is configurable, so a restricted setup keeps the model read-only.
Similar MCP servers
Braintrust MCP
MCP serverQueries Braintrust eval data and production logs from a coding agent.
Data & AnalyticsAI Models & Inference
AWS MCP Servers
MCP serverA large collection of AWS-specific MCP servers, installed one at a time.
Developer ToolsCloud Platforms & Infrastructure
Filesystem MCP Server
MCP serverReference server for scoped read and write access to local folders
Developer ToolsStorage & Files
Comments(0)
Sign in to comment