{"type":"mcp_server","name":"mssql-mcp","description":"The MSSQL MCP Server enables database interaction and business intelligence by running SQL queries, analyzing data, and generating business insight memos, adapting SQLite modifications for MSSQL. The MSSQL MCP Server","category":"Database","language":"Python","stars":39,"forks":1,"owner":"daobataotie","github_url":"https://github.com/daobataotie/mssql-mcp","homepage":null,"setup":"## Setup\n\n1.  **Install packages**:\n\n   ```bash\n   CD /d ~/mssql-mcp  \n   pip install -r requirements.txt  \n   ```\n\n2.  **config**: Create `config.json` in the same folder as `server.py` and add the following:\n\n   ```json\n   {\n       \"database\": {\n           \"driver\": \"ODBC Driver 17 for SQL Server\",\n           \"server\": \"server ip\",\n           \"database\": \"db name\",\n           \"username\": \"username\",\n           \"password\": \"password\",\n           \"trusted_connection\": false\n       },\n       \"server\": {\n           \"name\": \"mssql-manager\",\n           \"version\": \"0.1.0\",\n           \"host\": \"0.0.0.0\",\n           \"port\": 8080\n       }\n   }\n   ```\n\n3.  **Claude Desktop 、 Windsurf**: Add the following to `claude_desktop_config.json`, using your path:\n\n   ```json\n   {\n       \"mcpServers\": {\n           \"mssql\": {\n               \"command\": \"python\",\n               \"args\": [\n                   \"~/server.py\" # your path\n               ]\n           }\n       }\n   }\n   ```\n\n4.  **Cursor**: Add according to the diagram (see `imgs/cursor_config.png`) for Cursor MCP, using your path.\n\n5.  **MCP Inspector**: Run the following command, using your path:\n\n   ```bash\n   npx -y @modelcontextprotocol/inspector python C:\\mssql-mcp\\src\\server.py\n   ```","tools":"## Available Tools\n\n\t\t1. `read_query` (Execute SELECT queries to read data from the database)\n\t\t2. `write_query` (Execute INSERT, UPDATE, or DELETE queries)\n\t\t3. `create_table` (Create new tables in the database)\n\t\t4. `list_tables` (Get a list of all tables in the database)\n\t\t5. `describe-table` (View schema information for a specific table)\n\t\t6. `append_insight` (Add new business insights to the memo resource)","faq":null,"created_at":"2025-03-13T03:48:56+00:00","updated_at":"2025-03-28T03:10:08+00:00","source_url":"https://model-context-protocol.com/servers/mssql-server-database-interaction-business-intelligence","related_articles":[]}