SQL Server MCP Server

Example Use Cases

• 1

  Execute SQL queries and retrieve detailed database schema metadata from SQL Server.

• 2

  Secure multi-key API authentication and encrypted connection management.

• 3

  Integration with Visual Studio Code Copilot to enhance database interaction capabilities.

Description

This MCP server connects to one or more SQL Server databases, providing features such as SQL query execution, detailed database metadata retrieval including tables, views, and stored procedures, and a multi-key API authentication system. It supports encrypted connection strings, key rotation, and robust logging, designed with clean architecture and dependency injection for testability. The server exposes multiple endpoint types including standard MCP, JSON-RPC 2.0, and direct REST APIs, facilitating integration with various clients.