Mining MCP Server

A Microsoft SQL Server MCP (Model Context Protocol) server built with FastMCP. Provides tools to query and explore SQL Server databases through Claude Desktop and other MCP clients.

Prerequisites

• Restored SQL Server database (e.g., UU_BR_Shovel.bak)
• Python 3.13+
• SQL Server instance running locally

Setup

1. Install dependencies:

uv sync

2. Configure environment variables in .env:

MSSQL_HOST=localhost
MSSQL_PORT=1433
MSSQL_USER=sa
MSSQL_PASSWORD=your_password
MSSQL_DATABASE=your_database_name

3. (Optional) Configure Logfire for telemetry:

LOGFIRE_TOKEN=your_logfire_token

Running Locally

python main.py

The server will start and be available to MCP clients like Claude Desktop.

Features

• List databases, schemas, and tables
• Describe table schemas
• Execute SQL queries
• Search tables by pattern
• Get sample data from tables

Built with FastMCP 2.0.