The Alyio.McpMssql tool functions as a specialized, read-only Model Context Protocol (MCP) server for Microsoft SQL Server. It provides robust capabilities for metadata discovery, allowing clients to explore databases, schemas, tables, views, procedures, and functions. Users can execute parameterized queries to retrieve data safely, and perform in-depth query analysis, including execution plan inspection, without modifying the underlying database. Designed with security in mind, it strictly enforces no DML/DDL operations, ensuring a safe environment for agent-based workflows and integration with AI development tools.
Características Principales
01Flexible profile-based configuration for multiple connections and Azure AD authentication
02Strict read-only access with no DML/DDL enforcement
034 GitHub stars
04Extensive metadata discovery for SQL Server objects
05In-depth query analysis, including execution plan retrieval
06Execution of parameterized T-SQL SELECT queries
Casos de Uso
01Integrating Microsoft SQL Server with MCP-compatible AI agents and development tools
02Analyzing SQL query performance and execution plans within an MCP environment
03Providing secure, read-only data access for reporting, analytics, and data exploration
