Advertise
MCP.so
Sign In

A2db MCP Server

@agentic-eng

Repository

Basic information

Category

Other

Transports

stdio

Author

agentic-eng

Submitted by

Denis Tee

About A2db MCP Server

No overview available yet

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

A2db MCP Server config

Add this server to your MCP-compatible client using the configuration below.

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

A2db MCP Server tools

Tool list not available yet

This listing does not currently have a tool list to display. This does not mean the server has no tools; check its documentation for supported capabilities.

Fetch the live tool list by running this server in a temporary sandbox using the button above.

Overview

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

Frequently asked questions

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.

Comments

More Other MCP servers

Sequential Thinking

modelcontextprotocol

Model Context Protocol Servers

88.2K

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.

Codelf

unbug

A search tool helps dev to solve the naming things problem.

14.2K

Reactive Resume

amruthpillai

A one-of-a-kind resume builder that keeps your privacy in mind. Completely secure, customizable, portable, open-source and free forever. Try it out today!

39.5K

Screenpipe

screenpipe

YC (S26) | Open Computer History | Continuously record your company computer work, map your workflows, help you find work worth automating, and power your agents' context

22.0K
Advertise