広告掲載
MCP.so
ログイン

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

よくある質問

1

What databases does A2db support?

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

2

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.

3

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.

4

What output format does A2db return?

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

5

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.

コメント

「その他」の他のコンテンツ

Senso MCP for Joomla

sensomedia

Senso MCP turns a Joomla 5 or 6 site into a remote MCP server. It runs inside Joomla itself (no extra server, no Node.js bridge) and is secured with OAuth 2.1 and Joomla's own ACL. The free pack lets an AI assistant crea

🚀 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

Handl

Handl speaks the Model Context Protocol. Your whole billing operation — projects, invoices, clients, reports, approvals — as tools any AI assistant can call, inside your autonomy rules.

Klarix Intelligence Engine

Klarix

B2B competitive intelligence, live sales battlecards, 5-axis ICP prospect fit scoring, and tech stack teardowns over MCP and REST with cited public-web evidence.

DeepMark

DeepMark helps teachers deliver rapid, consistent marking with meaningful feedback for every student — in a fraction of the time. What once took a week, now takes one free period.

広告掲載