The Mssql_mcp_server provides Claude Desktop with secure access to Microsoft SQL Server databases through tools for listing tables and executing SQL queries (SELECT, INSERT, UPDATE, DELETE). It supports multiple authentication methods including SQL authentication, Windows authentication, and Azure AD, while accommodating LocalDB, on-premises, and Azure SQL deployments with configurable ports and encryption options. This server solves the problem of enabling AI assistants to directly query and manipulate SQL Server databases in a controlled, secure manner.
claude mcp add --transport stdio richardhan-mssql_mcp_server uvx mssql_mcp_server