Loading...
{
"mcpServers": {
"postgres": {
"command": "docker",
"args": [
"run",
"-i",
"--rm",
"-e",
"DATABASE_URI",
"crystaldba/postgres-mcp",
"--access-mode=unrestricted"
],
"env": {
"DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
}
}
}
}database_health_checkAnalyzes database health, including index health, connection utilization, and replication lag.
Read-only access to database statistics.
index_tuningExplores index options to optimize database performance.
Can modify database schema by creating new indexes.
query_plan_analysisReviews EXPLAIN plans to validate and optimize query performance.
Read-only access to query execution plans.
safe_sql_executionExecutes SQL queries with configurable access control.
Can modify data or schema depending on access mode.
schema_intelligenceProvides context-aware SQL generation based on the database schema.
Read-only access to database schema information.
Postgres MCP Pro offers configurable access controls, but unrestricted mode carries significant risks. It's safe for development with proper access controls. Production use requires restricted mode and careful monitoring to prevent unintended data modifications or performance impacts.