MSSQL

About

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.

Key Features

• Strict guardrails against harmful SQL commands, multi-statements, and comments
• Automated schema discovery with heuristic tagging for tables and columns (`discover_schema`)
• Automatic `TOP 5000` injection and 15-second query timeout for result control and performance
• 0 GitHub stars
• Safe execution of single `SELECT` statements, preventing DDL/DML operations (`run_sql_safe`)
• Secure MSSQL database connection and health check (`connect_db`)

Use Cases

• Enabling natural language to SQL (NL-to-SQL) capabilities for MSSQL data exploration
• Connecting AI assistants like Claude Desktop to MSSQL databases for data interaction
• Securely querying and extracting data from MSSQL databases via an MCP-compatible client