A2db
by agentic-engcommunityv0.2.1
2
a2db provides AI agents with safe, read-only access to multiple databases through batch queries and structured results.
From the registry: Safe, read-only database access for AI agents. 5 databases, batch queries, SQLGlot.
Install & configure
Prerequisites
- requiredInstall Python 3.10+ and uv/uvxuvx is used to launch a2db-mcp without polluting the global environment.
https://docs.astral.sh/uv/$ curl -LsSf https://astral.sh/uv/install.sh | sh - requiredHave a reachable database DSNSupports PostgreSQL, SQLite, MySQL/MariaDB, Oracle, and SQL Server. Use a read-only DB user when possible.
Install in your client
Paste into the AI you're chatting with — it will figure out the rest
Please install the `a2db` MCP server into my current AI client (that's you).
Required prerequisites (do these first if not already done):
- **Install Python 3.10+ and uv/uvx** — uvx is used to launch a2db-mcp without polluting the global environment. Run: `curl -LsSf https://astral.sh/uv/install.sh | sh` (https://docs.astral.sh/uv/)
- **Have a reachable database DSN** — Supports PostgreSQL, SQLite, MySQL/MariaDB, Oracle, and SQL Server. Use a read-only DB user when possible.
Canonical MCP server config (stdio transport):
- command: `uvx`
- args: ["a2db-mcp"]
- optional environment variables:
- `DB_PASSWORD`: Referenced as ${DB_PASSWORD} inside a --register DSN; expanded at connection time. (example: `<your-db-password>`)
Note: Read-only queries enforced via SQLGlot AST. Pre-register connections with --register <project>/<env>/<db> '<dsn>' for zero-friction agent queries.
Add this MCP server to my current client's config in the correct format for you. If you need secrets or credentials I haven't provided, ASK me — do not invent values or leave raw placeholders. After adding it, tell me how to verify the server is connected.Note: Read-only queries enforced via SQLGlot AST. Pre-register connections with --register <project>/<env>/<db> '<dsn>' for zero-friction agent queries.
Tools (5)
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
Environment variables
DB_PASSWORDrequiredDatabase password for connectionsCI_DB_PASSWORDrequiredDatabase password for CI connectionsPackages
a2db
pypiv0.2.1transport: stdio
Details
- Language
- Python
- License
- Apache-2.0
- Released
- Mar 29, 2026
- Last commit
- Apr 13, 2026
- Registry name
- io.github.agentic-eng/a2db