A2db

Created By
Denis Tomilin (iorlas @ agentic-eng)2 months ago
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"
      ]
    }
  }
}
Project Info
Created At
2 months ago
Updated At
2 months ago
Author Name
Denis Tomilin (iorlas @ agentic-eng)
Star
-
Language
-
License
-
Category

Recommend Servers

View All
Tavily Mcp
@tavily-ai

JavaScript
a year ago