A2db MCP Server

@agentic-eng

代码仓库

基本信息

分类

其他

传输方式

stdio

作者

agentic-eng

提交者

Denis Tee

关于 A2db MCP Server

暂无概览

#database #sql #postgresql #sqlite #mysql #mcp-server #ai-agents #read-only

A2db MCP Server 配置

使用下面的配置,将此服务器添加到你的 MCP 客户端。

{
  "mcpServers": {
    "a2db": {
      "command": "uvx",
      "args": [
        "a2db-mcp"
      ]
    }
  }
}

A2db MCP Server 工具

工具列表暂未提供

当前收录暂时没有可展示的工具列表，不代表服务没有工具。请查阅项目文档了解支持的能力。

点击上方按钮,在临时沙箱中运行此服务器并实时获取工具列表。

概览

What is A2db?

A2db is an MCP server that enables batch SQL queries across multiple databases with read-only enforcement. It supports PostgreSQL, SQLite, MySQL, Oracle, and SQL Server, and allows pre-configured connections via .mcp.json. It is designed for developers and AI agents who need safe, multi-database querying from a single tool call.

How to use A2db?

Install with pip install a2db, then add to your MCP config using the command uvx with arguments to register one or more database connections. Alternatively, let the agent call login on demand — no pre-configuration is required.

Key features of A2db

Batch queries with multiple named queries in one tool call
Pre-configured database connections via .mcp.json
Default connection for all queries in a batch
Read-only enforced via SQLGlot AST parsing
Clean JSON output with TSV data and per-query timing
Supports 5 databases with all drivers bundled
Error context with column suggestions and types

Use cases of A2db

Running multiple analytical queries against different databases simultaneously
Safely querying production databases from an AI assistant without write risk
Simplifying data retrieval for reports across heterogeneous SQL databases
Batch data extraction for ETL or validation pipelines

常见问题

What databases does A2db support?

PostgreSQL, SQLite, MySQL, Oracle, and SQL Server — all drivers are bundled with the package.

How does A2db ensure read-only queries?

It uses SQLGlot AST parsing to block write statements (INSERT, UPDATE, DELETE, etc.) at the syntax level before execution.

How do I configure connections?

Add entries to your `mcpServers` configuration with the `register` command and connection string, or let the agent call the `login` tool on demand without prior setup.

What output format does A2db return?

A JSON envelope containing TSV-formatted data rows and per-query timing information for each batch query.

Is there a default connection option?

Yes, you can set a default connection that applies to all queries in a batch, reducing the need to specify a connection per query.

其他分类下的更多 MCP 服务器

🚀 Model Context Protocol (MCP) Curriculum for Beginners

microsoft

This open-source curriculum introduces the fundamentals of Model Context Protocol (MCP) through real-world, cross-language examples in .NET, Java, TypeScript, JavaScript, Rust and Python. Designed for developers, it focuses on practical techniques for building modular, scalable,

16.7K

FastMCP v2 🚀

jlowin

🚀 The fast, Pythonic way to build MCP servers and clients.

26.0K

Figs, Relationship Expert

Figs O'Sullivan, LMFT

Couples therapist Figs O'Sullivan (LMFT, 17 years, endorsed by Sue Johnson, creator of EFT) inside your AI. Ask relationship questions answered from his clinical writing, name the pattern in a fight, get a three-step rep