Most database MCP servers make you run one query at a time, repeat connection details on every call, and return results double-encoded inside JSON strings. a2db fixes all of that:
a2db is an MCP project maintained in the agentic-eng/a2db repository. The maintainer describes its purpose as “Most database MCP servers make you run one query at a time, repeat connection details on every call, and return results double-encoded inside JSON strings…”. Read the project documentation for the complete scope.
The documented pypi package is a2db-mcp. The configuration below comes from the maintainer’s example; adapt its paths and account values to your environment.
The example declares DB_PASSWORD. Secret-looking values have been replaced with placeholders. Required and optional labels are shown only when the documentation states them.
Project documentation · Repository · Discovery listing. This profile records the public documentation checked on 2026-10-08.
Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.
| Tool | What it does |
|---|---|
| login | Save a connection — validates by connecting first |
| logout | Remove a saved connection |
| list_connections | List connections (no secrets exposed) |
| execute | Run named batch queries with pagination |
| search_objects | Explore schema — tables, columns, with detail levels |
{
"mcpServers": {
"a2db": {
"command": "uvx",
"args": [
"a2db-mcp",
"--register",
"myapp/prod/main",
"postgresql://user:${DB_PASSWORD}@host/mydb"
],
"env": {
"DB_PASSWORD": "YOUR_DB_PASSWORD"
}
}
}
}From the project documentation. Replace placeholders and example paths before connecting.
| Variable | Description | Required |
|---|---|---|
| DB_PASSWORD | Declared in the maintainer’s client configuration. | Check documentation |
Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
AI access to Quadratic spreadsheets: open files, run Python/SQL, query connected databases.
RSS/Atom feed reader MCP server with SQLite backend
PyChroma MCP connects a local ChromaDB collection to an assistant for document ingestion, embedding configuration and semantic retrieval.
Local-first project board MCP: an AI agent plans, works, verifies, and ships tickets from markdown.