Mssql MCP Server acts as a powerful bridge, connecting leading AI assistants like Claude, Gemini, OpenAI, Copilot, and Cursor directly to your Microsoft SQL Server databases. It empowers AI agents with comprehensive capabilities including in-depth schema discovery, secure query execution (SELECT, INSERT, UPDATE, DELETE), DDL operations, stored procedure management, and essential performance diagnostics. Built with enterprise-grade security, it offers flexible access control modes (readonly, readwrite, admin), automatic row limits, keyword blocking, and column-level data masking, ensuring safe and controlled interaction between AI and your critical database infrastructure.
主な機能
010 GitHub stars
02Support for SQL Server, Windows, and Azure Active Directory Authentication
03Advanced Performance & DBA Diagnostics
04Secure Query Execution & DDL Operations
05Comprehensive Schema Discovery
06Robust Security Modes & Column-Level Data Masking
ユースケース
01Automating database schema exploration and query generation for developers using AI.
02Enabling AI-driven performance monitoring and DBA tasks on SQL Server.
03Empowering AI assistants (Claude, Gemini, Copilot) to interact with SQL Server databases.
