MsSqlMCP
@jdlemes
About MsSqlMCP
MCP to query SQL Server database schema, such as tables, columns, and relationships
Config
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryTools
5Get all table names in the database
Get columns (fields) for a specific table
Get foreign key relationships between tables
Get stored procedure definition
Execute a read-only SELECT query
Overview
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.
Frequently asked questions
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.
Basic information
More Databases MCP servers
ClickHouse MCP Server
ClickHouseConnect ClickHouse to your AI assistants.
MCP MongoDB Server
kiliczshA Model Context Protocol Server for MongoDB
MCP Alchemy
runekaagaardA MCP (model context protocol) server that gives the LLM access to and knowledge about relational databases like SQLite, Postgresql, MySQL & MariaDB, Oracle, and MS-SQL.
Meilisearch MCP Server
meilisearchA Model Context Protocol (MCP) server for interacting with Meilisearch through LLM interfaces.
Neon MCP Server
neondatabaseMCP server for interacting with Neon Management API and databases
Comments