Skip to content

MCP Server

AI-DBA runs as an MCP (Model Context Protocol) server, exposing database diagnostics as tools for AI agents.

Starting the Server

node dist/index.js --config config.yaml serve

The server communicates over stdio (JSON-RPC).

MCP Tools

Six tools are registered:

databases

List databases/schemas on an engine. 

{"name": "databases", "arguments": {"engineId": "my-mysql"}}

tables

List tables (optional database/schema filter). 

{"name": "tables", "arguments": {"engineId": "my-mysql", "database": "information_schema"}}

describe-table

Show column metadata for a table. 

{"name": "describe-table", "arguments": {"engineId": "my-mysql", "table": "blocking_test"}}

indexes

List indexes for a table. 

{"name": "indexes", "arguments": {"engineId": "my-mysql", "table": "blocking_test"}}

processes

List active connections/sessions. 

{"name": "processes", "arguments": {"engineId": "my-mysql"}}

blocking-chains

Detect blocking chains. 

{"name": "blocking-chains", "arguments": {"engineId": "my-mysql"}}

Integration with AI Agents

Hermes Agent

Add to your MCP client config:

mcp_servers:
  ai-dba:
    command: node
    args: ["/path/to/ai-dba/dist/index.js", "--config", "/path/to/ai-dba/config.yaml", "serve"]

Claude Code

Add to .mcp.json:

{
  "mcpServers": {
    "ai-dba": {
      "command": "node",
      "args": ["/path/to/ai-dba/dist/index.js", "--config", "/path/to/ai-dba/config.yaml", "serve"]
    }
  }
}

Cursor

Add to MCP settings:

{
  "mcp.ai-dba": {
    "command": "node",
    "args": ["/path/to/ai-dba/dist/index.js", "--config", "/path/to/ai-dba/config.yaml", "serve"]
  }
}

Read-Only Guardrails

The query tool (available via sql REPL command) enforces read-only access:

  • MySQL: Allows SELECT, SHOW, WITH, EXPLAIN, DESCRIBE
  • PostgreSQL: Allows SELECT, WITH, EXPLAIN
  • SQL Server: Allows SELECT, WITH, EXPLAIN
  • Oracle: Allows SELECT, WITH, EXPLAIN, DESCRIBE
  • MongoDB: Allows find, aggregate, count, distinct, ping

Any write operation (INSERT, UPDATE, DELETE, DROP, createCollection, etc.) is rejected with an error message.