A2db

Give AI agents safe, read-only access to your databases. One call, multiple queries, clean results.

5 databases · batch queries · pre-configured connections · SQLGlot read-only

Quick Start·MCP Tools·Security·Comparison·Setup

Agent: "Show me active users and their recent orders" ↓ a2db execute → 2 queries, 1 call, structured results ↓ Agent: "Got it — 847 active users, avg order $42.50"

- Pre-configured connections— define databases in.mcp.jsonwith--register, agent queries immediately
- Batch queries— run multiple named queries in a single tool call
- Default connection— set connection once, use it across all queries in a batch
- Clean output— structured JSON envelope with compact TSV data and per-query timing (seewhy TSV?)
- Read-only enforced— SQLGlot AST parsing blocks all write operations
- All drivers bundled—pip install a2dband you're done
- Secrets stay in env—${DB_PASSWORD}in DSNs, expanded only at connection time

claude mcp add -s user a2db -- a2db-mcp \ --register myapp/prod/main 'postgresql://user:${DB_PASSWORD}@host/mydb'

{ "mcpServers": { "a2db": { "command": "uvx", "args": [ "a2db-mcp", "--register", "myapp/prod/main", "postgresql://user:${DB_PASSWORD}@host/mydb" ], "env": { "DB_PASSWORD": "your-password-here" } } } }

{ "args": [ "a2db-mcp", "--register", "myapp/prod/main", "postgresql://user:${DB_PASSWORD}@host/maindb", "--register", "myapp/prod/analytics", "postgresql://user:${DB_PASSWORD}@host/analytics" ] }

--registerpre-registers connections at server startup — the agent can query immediately. Passwords use${ENV_VAR}syntax and are expanded at connection time, never stored in plaintext.

# Save a connection (validates immediately) a2db login -p myapp -e prod -d main 'postgresql://user:${DB_PASSWORD}@localhost/mydb' # Query a2db query -p myapp -e prod -d main "SELECT  FROM users LIMIT 10" # JSON output a2db query -p myapp -e prod -d main -f json "SELECT  FROM users LIMIT 10" # Explore schema a2db schema -p myapp -e prod -d main tables a2db schema -p myapp -e prod -d main columns -t users # List / remove connections a2db connections a2db logout -p myapp -e prod -d main

Named dict with default connection (preferred):

{ "connection": {"project": "myapp", "env": "prod", "db": "main"}, "queries": { "active_users": {"sql": "SELECT id, name FROM users WHERE active = true"}, "recent_orders": {"sql": "SELECT id, total FROM orders ORDER BY created_at DESC LIMIT 5"} } }

{ "connection": {"project": "myapp", "env": "prod", "db": "main"}, "queries": [ {"sql": "SELECT COUNT() AS cnt FROM users"}, {"sql": "SELECT AVG(total) AS avg_order FROM orders"} ] }

{ "active_users": { "data": "id\tname\n1\tAlice\n2\tBob\n3\tCharlie", "rows": 3, "truncated": false, "time_ms": 12 }, "recent_orders": { "data": "id\ttotal\n501\t129.00\n500\t49.99", "rows": 2, "truncated": false, "time_ms": 8 } }

column "nme" does not exist Did you mean: name? Available columns: id (integer), name (text), email (text), active (integer)

pip install a2db # CLI a2db login -p myapp -e dev -d main 'postgresql://user:pass@localhost/mydb' # Or add as MCP server (see Quick Start)

FROM python:3.12-slim RUN pip install a2db CMD ["a2db-mcp", "--register", "myapp/prod/main", "postgresql://user:${DB_PASSWORD}@host/mydb"]

docker run -e DB_PASSWORD=secret -i my-a2db-image

pip install a2db # Pre-configured — no login needed a2db-mcp --register myapp/ci/main "postgresql://ci_user:${CI_DB_PASSWORD}@db-host/mydb" # Or use CLI directly a2db login -p myapp -e ci -d main "postgresql://ci_user:${CI_DB_PASSWORD}@db-host/mydb" a2db query -p myapp -e ci -d main "SELECT COUNT() FROM migrations"

make bootstrap # Install deps + hooks make check # Lint + test + security (full gate) make test # Tests with coverage (90% minimum) make lint # Lint only (never modifies files) make fix # Auto-fix + lint

🗄️ Agent-first database access since 2025.

Database MCP server for MySQL, MariaDB, PostgreSQL & SQLite

A single-binary MCP server for MySQL, MariaDB, PostgreSQL, and SQLite

A Model Context Protocol (MCP) server that provides multi-database query execution capabilities with support for SQLite, PostgreSQL, and MySQL databases. Includes a built-in Web UI for managing database connections.

Update various databases (PostgreSQL, MySQL, MongoDB, SQLite) using data from CSV and Excel files.

Enables AI assistants to interact with various databases through JDBC connections.

Production-grade Model Context Protocol (MCP) server for unified SQL database access. Connect multiple databases through a single MCP server with schema discovery, relationship mapping, caching, and safety controls.

Provides database access for SQLite, SQL Server, PostgreSQL, and MySQL.

Multi-database analysis MCP server (PostgreSQL, MySQL, SQLite). Inspects schemas, detects index problems, analyzes table bloat, and explains query plans for actionable database optimization.

A lightweight MCP server for any database with a JDBC driver. Built with Quarkus and requires Java 21+.

An MCP server that provides AI assistants with structured access to multiple databases simultaneously.