A2db

Name: A2db
Author: agentic-eng

@agentic-eng

リポジトリ

A2db について

概要はまだありません

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

基本情報

カテゴリ

その他

トランスポート

stdio

公開者

agentic-eng

投稿者

Denis Tee

設定

以下の設定を使って、このサーバーを MCP 対応クライアントに追加してください。

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

ツール

ツールは検出されませんでした

ツールは README から自動的に抽出されます。メンテナーは ## Tools という見出しの下に記載することで、このタブに反映できます。

概要

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

FAQ from A2db

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.