DBMCP

DBMCP lets you run queries against MSSQL databases from MCP clients, returning real-time results via Server-Sent Events. It’s useful for building live data dashboards, dashboards, or any client that needs on-demand database access without implementing custom client-server protocols.

How to use

You connect your MCP client to the DBMCP server and issue SQL queries against your MSSQL database. The server accepts queries from clients over SSE and streams the results back as they’re produced. Use this to build live data views and dashboards that refresh as data changes.

How to install

Prerequisites you need before installing DBMCP:

Install and run DBMCP using either Docker for quick start or run locally with Python.

# Docker (recommended for quick start)
docker-compose up -d # or
docker-compose up --watch # Hot Reloading for Dev

# Local development (Python)
uv sync
pip install -r requirements.txt

# Start the server locally
(dbmcp) python server.py

Additional notes and configuration

Environment variables required for MSSQL connection must be defined in your environment or an .env file. The following variables are used to configure the MSSQL connection:

Usage by MCP client

Configure your MCP client to connect to the DBMCP HTTP endpoint and start sending queries. Example client configuration references the DBMCP SSE endpoint so the client can subscribe to live query results.

Available tools

execute_query

Runs a SQL query on the MSSQL database and streams the resulting rows back to the MCP client via Server-Sent Events.