DBMCP (Database MCP Server)

DBMCP is a MCP (Model-Client-Protocol) server that allows you to execute queries on databases. This server communicates with clients through SSE (Server-Sent Events), executes queries on databases, and returns the results.

Supported Databases

• MSSQL

Installation and Execution

Environment Variables Setup

Set environment variables in the .env file such as:

MSSQL_HOST=MSSQL_server_address
MSSQL_USER=username
MSSQL_PASSWORD=password
MSSQL_PORT=1433

Running with Docker

docker-compose up -d # or
docker-compose up --watch # Hot Reloading for Dev

Running Locally

1. Install dependencies:

uv sync # or
pip install -r requirements.txt

1. Run the server:

(dbmcp) python server.py

Usage

Add following json to your MCP client (Claude Desktop, Cursor, ...)

{
  "mcpServers": {
    "dbmcp": {
      "url": "http://localhost:8080/sse"
    }
  }
}