Integrations
Used for data validation and settings management in the MSSQL MCP server implementation
Powers the MSSQL MCP server implementation, allowing for database operations and business intelligence capabilities
MSSQL MCP Server
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
This server cannot be installed
Provides database interaction and business intelligence capabilities, enabling users to run SQL queries, analyze business data, and automatically generate business insight memos for Microsoft SQL Server databases.
Related Resources
Related MCP Servers
- AsecurityAlicenseAqualityAllows AI assistants to list tables, read data, and execute SQL queries through a controlled interface, making database exploration and analysis safer and more structured.Last updated -1360PythonMIT License
- -securityAlicense-qualityEnables execution of SQL queries and management of Microsoft SQL Server database connections through the Model Context Protocol.Last updated -10TypeScriptMIT License
- -securityAlicense-qualityFacilitates interaction with Microsoft SQL Server Express, supporting database operations such as querying, table management, and schema inspection via natural language MCP commands.Last updated -1PythonMIT License
- -securityAlicense-qualityAn easy-to-use bridge that lets AI assistants like Claude and Cursor IDE directly query and explore Microsoft SQL Server databases. No coding experience required!Last updated -25JavaScriptGPL 3.0