Provides secure, STDIO-mode connectivity to MSSQL databases for Claude Desktop and other MCP-compatible clients.
Sponsored
mcp-mssql serves as a crucial bridge for Claude Desktop and other Model Context Protocol (MCP) compliant clients, enabling secure, real-time interaction with MSSQL databases. Operating in STDIO mode, it empowers AI assistants to translate natural language queries into safe SQL commands, leveraging features like schema discovery and guarded execution. With built-in security measures that restrict DDL/DML operations, enforce statement limits, and inject result row caps, it ensures a controlled and read-only data access environment, making it ideal for analytical queries and data exploration without compromising database integrity.
主要功能
01Strict guardrails against harmful SQL commands, multi-statements, and comments
02Automated schema discovery with heuristic tagging for tables and columns (`discover_schema`)
03Automatic `TOP 5000` injection and 15-second query timeout for result control and performance
040 GitHub stars
05Safe execution of single `SELECT` statements, preventing DDL/DML operations (`run_sql_safe`)
06Secure MSSQL database connection and health check (`connect_db`)
使用案例
01Enabling natural language to SQL (NL-to-SQL) capabilities for MSSQL data exploration
02Connecting AI assistants like Claude Desktop to MSSQL databases for data interaction
03Securely querying and extracting data from MSSQL databases via an MCP-compatible client
