What runtime dependencies are required?
Requires .NET 9.0 SDK and a SQL Server instance (local or remote). Visual Studio Code with the Copilot extension is recommended for the intended use case.
SQL Server MCP (MCP) Server
@MCPRUNNER
基本信息
关于 SQL Server MCP (MCP) Server
MCP Server for MSSQL (Microsoft SQL Server)
SQL Server MCP (MCP) Server 配置
SQL Server MCP (MCP) Server 工具
4Initializes the SQL Server connection
Executes a SQL query and returns results as JSON
Retrieves metadata about database tables, columns, keys, etc. You can filter by schema or get all schemas.
Retrieves metadata about tables, views, stored procedures and functions, including schemas, columns, and relationships.
概览
What is SQL Server MCP Server?
This is a Model Context Protocol (MCP) server that connects to one or more SQL Server databases. It is designed to be used by Visual Studio Code as a Copilot Agent, enabling LLM‑driven SQL query execution and database metadata retrieval.
How to use SQL Server MCP Server?
The server requires .NET 9.0 SDK and a running SQL Server instance (local or remote). Set mandatory environment variables MSSQL_MCP_KEY and MSSQL_MCP_API_KEY before starting. Use the provided PowerShell script Start-MCP-Encrypted.ps1 or run the Docker image from mcprunner/mssqlmcp. Client applications authenticate via the API key in HTTP headers and interact using MCP tools such as connectionManager/list, GetTableMetadata, and GetDatabaseObjectsMetadata.
Key features of SQL Server MCP Server
- SQL query execution through MCP tools
- Comprehensive database metadata retrieval (tables, views, stored procedures, functions)
- Detailed schema information including primary/foreign keys
- Connection string encryption with AES‑256
- Key rotation and security management support
- Persistent connection storage via SQLite database
- Robust logging with Serilog and clean architecture
Use cases of SQL Server MCP Server
- Enable Visual Studio Code Copilot to query SQL Server databases
- Retrieve database schema for code generation or documentation
- Securely manage multiple database connections in one place
- Automate database operations through MCP tool calls
常见问题
How are connection strings secured?
Connection strings are encrypted using AES‑256 with a master key provided via the `MSSQL_MCP_KEY` environment variable. Key rotation is supported through dedicated PowerShell scripts.
Where are database connections stored?
Connections are stored persistently in a local SQLite database at `Data/connections.db`. The data directory location can be overridden with the `MSSQL_MCP_DATA` environment variable.
How do I authenticate to the server?
API key authentication is used via HTTP headers. The API key is set using the `MSSQL_MCP_API_KEY` environment variable or generated and configured with the `Set-Api-Key.ps1` script.
What database objects can the server retrieve metadata for?
Metadata can be retrieved for tables, views, stored procedures, and functions. Objects can be filtered by type (TABLE, VIEW, PROCEDURE, ALL) and by schema.
数据库 分类下的更多 MCP 服务器
Schemity
tbsonLocal database MCP server: your agent sees a migration's impact before it runs, for PostgreSQL, MySQL, SQL Server and SQLite, with no database credentials.
nuzur
nuzur is a model-first database platform for MySQL and PostgreSQL. The MCP server lets any AI assistant or agent (Claude, Cursor, Gemini, or anything else that speaks MCP) design your schema, query your data, generate mi
Chroma MCP Server
chroma-coreA Model Context Protocol (MCP) server implementation that provides database capabilities for Chroma
569
NPILayer
NPILayerHealthcare provider data for AI assistants, from the official CMS NPPES dataset (updated weekly). Look up any NPI (active or deactivated), search providers and organizations by name, city, state, ZIP, taxonomy code or pl
Elasticsearch MCP Server
elastic685
评论