PGAutoPilot
Enables AI assistants to interact with PostgreSQL databases through natural language, with schema-aware query generation and enterprise safety controls.
Databases
npm 0 platforms
0 features
Install
npx -y pgautopilot
Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
{
"mcpServers": {
"pgautopilot": {
"command": "npx",
"args": [
"-y",
"pgautopilot"
],
"env": {
"NODE_ENV": "<NODE_ENV>",
"PGSSLMODE": "<PGSSLMODE>",
"PGPOOL_MAX": "<PGPOOL_MAX>",
"BACKUPS_DIR": "<BACKUPS_DIR>",
"DATABASE_URL": "<DATABASE_URL>",
"BLOCKED_TABLES": "<BLOCKED_TABLES>",
"DOCKER_CONTAINER": "<DOCKER_CONTAINER>",
"SENSITIVE_COLUMNS": "<SENSITIVE_COLUMNS>"
}
}
}
}Paste the configuration above into your MCP client config (claude_desktop_config.json for Claude Desktop) and restart the client.
Sources: public MCP Server directories. This is an independent third-party directory with no affiliation to or endorsement from the maintainers of the listed servers.
