The MSSQL server acts as an MCP (Model Context Protocol) server, enabling clients like Claude Code, Cursor, and Windsurf to interact with Microsoft SQL Server databases. It provides a comprehensive set of 20 tools for various database operations, allowing users to browse procedures, views, functions, and tables, retrieve their source code and schemas, execute SELECT queries, and even perform DDL operations for creating/altering procedures and views. Designed with security in mind, it restricts destructive commands, ensuring safe database interactions while offering multi-database support and flexible JSON-based configuration.
主要功能
01Comprehensive suite of 20 database management tools
02Flexible configuration via a single JSON file for managing N databases
03Supports concurrent connections to multiple MSSQL databases
04Enhanced security by blocking destructive commands (e.g., DROP, DELETE, UPDATE) and restricting query types
05Delayed connection until the first request to optimize resource usage
060 GitHub stars
使用案例
01Browsing and retrieving metadata for SQL Server objects (procedures, views, functions, tables)
02Executing read-only SELECT queries and obtaining execution plans for analysis
03Creating and modifying stored procedures and views through DDL commands
04Searching for objects by name or text within definitions across the database
05Comparing object definitions between two different databases
