MCP-MSSQL-SERVER
0
The Python MSSQL MCP Server is a Model Context Protocol implementation that integrates with Microsoft SQL Server databases, allowing asynchronous data access and execution of SQL queries through a unified interface. It features FastAPI integration and is equipped with comprehensive error handling and security measures.
Python MSSQL MCP Server
A Model Context Protocol server implementation in Python for accessing Microsoft SQL Server databases. The server enables Language Models to inspect table schemas and execute SQL queries through a standardized interface.
Features
- Asynchronous operation with
asyncio - Environment-based configuration using
python-dotenv - Comprehensive logging system
- Connection pooling via pyodbc
- FastAPI integration for API endpoints
- Pydantic models for data validation
Prerequisites
- Python 3.x
- Required Python packages: pyodbc, pydantic, python-dotenv, mcp-server
- ODBC Driver 17 for SQL Server
Usage with MCP Clients
Integrate this server with MCP clients like Claude Desktop, Cursor, and WindSurf by configuring the respective client files.
Security Features
- Environment variable based configuration
- Connection string security
- Input validation through Pydantic
License
This project is licensed under the MIT License.