A2db

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.