Overview
Why a2db?
- Batch queries — multiple named queries in a single tool call
- Pre-configured connections — define databases in .mcp.json, agent queries immediately
- Default connection — set once, use across all queries in a batch
- Read-only enforced — SQLGlot AST parsing blocks writes at the syntax level
- Clean output — JSON envelope with TSV data and per-query timing
- 5 databases — PostgreSQL, SQLite, MySQL, Oracle, SQL Server — all drivers bundled
- Error context — column suggestions and types when queries fail
Quick Start
pip install a2db
Add to your MCP config:
{"mcpServers": {"a2db": {"command": "uvx", "args": ["a2db-mcp", "--register", "myapp/prod/main",
"postgresql://user:${DB_PASSWORD}@host/mydb"], "env": {"DB_PASSWORD": "your-password"}}}}
Or let the agent call login on demand — no pre-configuration needed.
Server Config
{
"mcpServers": {
"a2db": {
"command": "uvx",
"args": [
"a2db-mcp"
]
}
}
}