MSSQL MCP Server

Example Use Cases

• 1

  Run ad-hoc SELECT queries and retrieve tabular results from an MSSQL database.

• 2

  Perform data modification operations (INSERT/UPDATE/DELETE), create tables, or inspect table schemas programmatically.

• 3

  Generate and append business insight memos based on queried data and integrate those insights into downstream workflows or UIs.

Description

MSSQL MCP Server implements a Model Context Protocol (MCP) interface for interacting with Microsoft SQL Server databases. It supports executing SELECT and write queries, creating and listing tables, inspecting table schemas, and appending business insight memos. The project is designed to integrate with agent frontends like Claude Desktop, Cursor, and the MCP Inspector to enable automated data querying and business intelligence workflows. It is implemented in Python and uses pyodbc with an ODBC Driver for SQL Server.