MSSQL MCP Server

Example Use Cases

• 1

  Run read-only or controlled SQL queries against a Microsoft SQL Server database to fetch structured data for reasoning or responses.

• 2

  A secure, proxied database connection with safeguards (blocking DROP/ALTER/etc.), input validation, and timeout/query length limits.

• 3

  Integrate a Claude or other MCP-capable client with MSSQL instances in local, Docker, or cloud environments using connection pooling and optional encryption.

Description

This MCP server provides tools for executing SQL queries against Microsoft SQL Server, with support for connection strings or individual connection parameters, connection pooling, and configurable encryption options. It includes safeguards to block dangerous SQL operations, validate inputs, and enforce query limits and timeouts. The project is installable via npm or Smithery and is distributed under the MIT license for local or containerized deployment.

Capabilities(33 total)