Connects Claude to Microsoft SQL Server databases in strict read-only mode. You get five tools: list_profiles for managing multiple connections, get_server_properties for limits and metadata, list_objects and get_object for exploring catalogs/schemas/tables/views/procedures, and run_query for executing parameterized SELECTs. The analyze_query tool returns execution plan summaries with cost estimates, operator details, and performance warnings without running the full query. Configuration works through environment variables for single connections or appsettings.json for multiple profiles. Supports Azure SQL with Microsoft Entra authentication modes. Results can be returned inline (500 row limit) or as snapshot resources (10,000 rows). Built as a .NET global tool with hard enforcement against DML and DDL operations.
claude mcp add --transport stdio alyiox-mcp-mssql uvx mcp-mssql