Execute read-only SQL queries on Microsoft SQL Server, supporting SELECT, temp table batches, and whitelisted stored procedures. Returns data as JSON or Markdown.
Establish a connection to Microsoft SQL Server databases using environment variables for configuration, enabling database interactions through the MCP server.
Find current blocking chains in SQL Server: identifies blocked sessions, lead blockers (including idle sessions with open transactions), resources, duration, and SQL text. Requires VIEW SERVER STATE.
Enables AI assistants to connect and query Microsoft SQL Server databases using natural language, executing read-only SQL queries for safe data inspection and analysis.
This read-only MCP Server allows you to connect to Microsoft SQL Server data from Claude Desktop through CData JDBC Drivers. For full CRUD support, check out the first managed MCP platform: CData Connect AI (https://www.cdata.com/ai/).
Retrieve recent deadlock history from Azure SQL system_health session. Parses deadlock XML to identify victim, participants, resources, and SQL text for troubleshooting.
Retrieve a comprehensive list of all resources on the connected MCP server, including URIs, names, descriptions, and MIME types, with metadata for reliable access.
Test connectivity to a Microsoft SQL Server instance and retrieve server version and metadata. Specify server, port, database, and credentials to validate access.