MSSQL MCP Server

Example Use Cases

• 1

  Run T-SQL queries and transactions safely on Microsoft SQL Server.

• 2

  Explore database schemas, tables, and stored procedures programmatically.

• 3

  Analyze query execution plans without executing the queries.

Description

This MCP server allows any MCP-compatible agent to connect directly to Microsoft SQL Server or Azure SQL instances to run queries, explore database schemas, execute stored procedures, and analyze execution plans through a secure and structured interface. It supports multiple authentication methods, enforces security features like read-only mode and query result limits, and integrates easily with tools like Claude Desktop. The server is built with Python and FastMCP, providing a robust and extensible platform for database interaction.