mcp-mssql-server

# MCP MS SQL Server A Model Context Protocol (MCP) server for Microsoft SQL Server that provides tools for database operations, data analysis, and visualization generation. ## Installation ```bash pip install mcp-mssql-server ## Features This MCP server provides 8 powerful tools: 1. **sql_query** - Execute SQL queries with permission controls 2. **get_database_info** - Get server and database information 3. **show_tables** - List all tables in the database 4. **describe_table** - Get detailed table structure information 5. **show_indexes** - Display table indexes 6. **generate_analysis_notebook** - Create Jupyter notebooks for data analysis 7. **generate_visualization** - Create interactive visualizations (bar, scatter, pie, line, heatmap, table) 8. **generate_powerbi_visualization** - Generate Power BI compatible data exports ## Installation 1. Clone this repository 2. Install dependencies using uv: ```bash cd mcp-mssql-server uv pip install -e . ``` ## Configuration use uv pip install -r requirements.txt to install all the requirements. 1. Copy the `.env` file and update with your database credentials: ```bash # Database Type (mssql) DB_TYPE=mssql # SQL Server Configuration MSSQL_SERVER=tcp:your-server.database.windows.net MSSQL_PORT=1433 MSSQL_USER=your-username MSSQL_PASSWORD=your-password MSSQL_DATABASE=your-database MSSQL_ENCRYPT=true MSSQL_TRUST_SERVER_CERTIFICATE=true # Security Settings ALLOW_WRITE_OPERATIONS=false ALLOW_INSERT_OPERATION=false ALLOW_UPDATE_OPERATION=false ALLOW_DELETE_OPERATION=false # Performance Settings CONNECTION_POOL_MIN=1 CONNECTION_POOL_MAX=10 QUERY_TIMEOUT=30000 ``` 2. Update the password field with your actual password. ## Usage ### Running the MCP Server ```bash uv run python main.py ``` Or with logging: ```bash uv run python main.py --log uv run python mssql.py --log ``` ### Using with Claude Desktop Add the following to your …