MSSQL MCP Server

This project is an MCP (Model Context Protocol) server for connecting to Microsoft SQL Server databases. It uses MCPO to introduce an OpenAPI proxy in front of the MCP server, enabling OpenAPI-compatible clients to interact with the MCP server via a standardized HTTP interface. The server provides tools for schema inspection and querying, all accessible via the MCP protocol or through the OpenAPI proxy.

Diagram

flowchart LR
    User --> |Prompt| Agent
    Agent --> |OpenAPI| Container
    Container --> |T-SQL| Database

Features

• Connects to Microsoft SQL Server using MCP
• Provides tools for querying and schema inspection
• Designed for integration with MCP-compatible clients
• Container-ready (Docker)

Available Tools

• read_query: Execute SELECT queries on the MSSQL database
• list_tables: List all existing tables and their columns

Required Environment Variables

Set the following environment variables to configure the database connection:

• MSSQL_SERVER (name.database.windows.net)
• MSSQL_DATABASE (Name)
• MSSQL_USER (Username)
• MSSQL_PASSWORD (Password)
• MCP_SERVER_NAME (mcp-database-assistant)
• MCP_SERVER_VERSION (1.0.0)
• APPLICATIONINSIGHTS_CONNECTION_STRING (InstrumentationKey=...)

These can be set in your environment or injected at container runtime.

Building and Running with Docker

1. Build the Docker image:

   docker build -t mssql-mcp .
   

2. Run the container:

   docker run --rm -it mssql-mcp
   

3. Default command: The container runs:

   mcpo --config config.json
   

Requirements

• Python 3.11+
• Microsoft ODBC Driver 17 for SQL Server (installed in the Docker image)
• MCP-compatible client (for example, VS Code with MCP extension)

License

See LICENSE.