MSSQL Database Query

🚀 Database MCP Server (DBMCP)

DBMCP is an MCP (Model - Client Protocol) database server that enables you to execute queries on the database. This server communicates with clients via SSE (Server-Sent Events), executes database queries, and returns results.

🚀 Quick Start

✨ Features

• Allows database query execution.
• Communicates with clients using SSE.

📦 Installation

Environment Variable Configuration

Set environment variables in the .env file, for example:

MSSQL_HOST=MSSQL Server Address
MSSQL_USER=Username
MSSQL_PASSWORD=Password
MSSQL_PORT=1433

Run with Docker

docker-compose up -d # Or
docker-compose up --watch # Hot reload for developers

Run Locally

1. Install dependencies:

uv sync # Or
pip install -r requirements.txt

2. Start the server:

(dbmcp) python server.py

💻 Usage Examples

Basic Usage

Add the following JSON configuration to your MCP client (such as Claude Desktop, Cursor, etc.):

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

📚 Documentation

Supported Databases

• MSSQL