Dbmcp
What is Dbmcp
DBMCP is a Model-Client-Protocol (MCP) server designed for executing queries on MSSQL databases. It facilitates communication between clients and databases through Server-Sent Events (SSE).
Use cases
Use cases for DBMCP include web applications that need to fetch data from MSSQL databases in real-time, data analysis tools that require dynamic querying capabilities, and backend services that interact with databases for CRUD operations.
How to use
To use DBMCP, set up the necessary environment variables in the .env file, run the server either using Docker or locally, and configure your MCP client to connect to the server by adding the appropriate JSON configuration.
Key features
Key features of DBMCP include support for MSSQL databases, the ability to execute database queries, and real-time communication with clients via Server-Sent Events (SSE).
Where to use
DBMCP can be used in various fields that require database interactions, particularly in applications that utilize MSSQL databases for data management and querying.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Overview
What is Dbmcp
DBMCP is a Model-Client-Protocol (MCP) server designed for executing queries on MSSQL databases. It facilitates communication between clients and databases through Server-Sent Events (SSE).
Use cases
Use cases for DBMCP include web applications that need to fetch data from MSSQL databases in real-time, data analysis tools that require dynamic querying capabilities, and backend services that interact with databases for CRUD operations.
How to use
To use DBMCP, set up the necessary environment variables in the .env file, run the server either using Docker or locally, and configure your MCP client to connect to the server by adding the appropriate JSON configuration.
Key features
Key features of DBMCP include support for MSSQL databases, the ability to execute database queries, and real-time communication with clients via Server-Sent Events (SSE).
Where to use
DBMCP can be used in various fields that require database interactions, particularly in applications that utilize MSSQL databases for data management and querying.
Clients Supporting MCP
The following are the main client software that supports the Model Context Protocol. Click the link to visit the official website for more information.
Content
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
- Install dependencies:
uv sync # or
pip install -r requirements.txt
- 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"
}
}
}Dev Tools Supporting MCP
The following are the main code editors that support the Model Context Protocol. Click the link to visit the official website for more information.
