概要
What is MsSqlMCP?
MsSqlMCP is an MCP Server for SQL Server database schema inspection and read-only query execution. It provides safe, validated SELECT-only SQL access and schema discovery for use with MCP clients like VS Code Copilot and Claude Desktop.
How to use MsSqlMCP?
Configure the SQL Server connection string in appsettings.json, then run dotnet run for console mode. For HTTP transport, use dotnet run -- --http-only. The server supports both stdio and HTTP/SSE protocols for integration with MCP clients.
Key features of MsSqlMCP
- Read-only access: blocks all data modification statements.
- Schema discovery: tables, columns, relationships, stored procedures.
- Safe SQL execution: only SELECT queries allowed.
- Dual transport: stdio and HTTP/SSE protocols.
- Windows Service support for production deployments.
- Compatible with VS Code Copilot and Claude Desktop.
Use cases of MsSqlMCP
- Inspect database schema from AI-powered code editors.
- Execute read-only queries safely through chat interfaces.
- Integrate SQL Server data with MCP-compatible automation tools.
- Deploy as a Windows Service for enterprise database monitoring.
FAQ from MsSqlMCP
What SQL statements are blocked?
The ExecuteSql tool only allows SELECT queries. Blocked statements include INSERT, UPDATE, DELETE, MERGE, TRUNCATE, CREATE, ALTER, DROP, GRANT, REVOKE, DENY, EXEC, EXECUTE, SP_EXECUTESQL, XP_, BACKUP, RESTORE, BULK, OPENROWSET, OPENQUERY, and OPENDATASOURCE.
Can I run MsSqlMCP as a Windows Service?
Yes. Publish the application with dotnet publish -c Release -r win-x64 --self-contained true, then create the service using sc.exe create MsSqlMCP and manage it with net start/stop.
What are the prerequisites?
.NET 10 (or .NET 9 with minor adjustments) and SQL Server. For development, the project runs in console mode; for production, it can be published as a self-contained Windows Service.
Which MCP clients are supported?
MsSqlMCP works with any MCP client, including VS Code Copilot and Claude Desktop. Configuration examples for both stdio and HTTP transport are provided.
How do I troubleshoot startup issues?
Check logs in C:\Services\MsSqlMCP\logs\ (if run as a service), verify the connection string in appsettings.json, ensure SQL Server is accessible from the service account, and test by running MsSqlMCP.exe --http-only manually to see errors.
