SQL Server Express MCP

Example Use Cases

• 1

  Execute read-only SELECT queries against permitted SQL Server Express databases to fetch structured data for decision-making.

• 2

  Perform write operations (INSERT/UPDATE/DELETE) or create new tables in SQL Server Express as part of automated data workflows.

• 3

  Discover schema information and list available tables/databases when interacting with a SQL Server Express instance.

Description

This MCP server provides a bridge between agents (e.g., Claude Desktop) and Microsoft SQL Server Express, supporting both Windows and SQL Server authentication. It requires Python 3.10+ and the Microsoft ODBC Driver 18 and can be started as a command-line MCP server for use by agent frameworks. The server exposes tools to read and write queries, create and describe tables, list tables, and restrict access to a configured set of databases. It simplifies secure programmatic access to SQL Server Express instances for automation and agent-driven workflows.