{"repo":"daobataotie/mssql-mcp","free":true,"listed":false,"github":"https://github.com/daobataotie/mssql-mcp","clone":"git clone https://github.com/daobataotie/mssql-mcp.git","description":"mssql mcp server","language":"Python","stars":39,"topics":["ai","mcp","model-context-protocol","mssql","mssqlmcp","sqlserver"],"license":"MIT","category":"mcp-servers","readme_excerpt":"MSSQL MCP Server English 中文 Overview MSSQL MCP Server, provides database interaction and business intelligence capabilities. This server enables running SQL queries, analyzing business data, and automatically generating business insight memos. Refer to the official website's SQLite for modifications to adapt to MSSQL Components - read query - Execute SELECT queries to read data from the database - write query - Execute INSERT, UPDATE, or DELETE queries - create table - Create new tables in the database - list tables - Get a list of all tables in the database - describe-table - View schema information for a specific table - append insight - Add new business insights to the memo resource Demo The database table is as follows. The column names are not standardized, and AI will match them on its own. Errors during SQL execution will self correct. The following is the demo. Operating environment - Python 3.x - Packages - pyodbc =4.0.39 - pydantic =2.0.0 - mcp =0.1.0 - ODBC Driver 17 for SQL Server Usage Install packages config Claude Desktop 、 Windsurf Cursor Note：The new version of cursor has also been changed to JSON configuration, please refer to the previous section MCP Inspector Project Structure License MIT License","default_branch":null,"files":null,"tree":[],"storefront":"/r/daobataotie","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/daobataotie/mssql-mcp/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}