@jdlemes
Basic information
MCP to query SQL Server database schema, such as tables, columns, and relationships
No standard config provided
This server doesn't expose a parseable MCP config block in its README. See the repository for install instructions.
RepositoryGet 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
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.
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.
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.
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`.
.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.
MsSqlMCP works with any MCP client, including VS Code Copilot and Claude Desktop. Configuration examples for both stdio and HTTP transport are provided.
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.
MCP server for interacting with Neon Management API and databases
Verified golf club data for AI agents: holes, par, address, phone, booking links, facilities, visitor rules and green fees for golf clubs in Spain (Canary Islands and mainland), expanding across Europe. Every fact comes
A powerful multi-database server implementing the Model Context Protocol (MCP) to provide AI assistants with structured access to databases.
The official Redis MCP Server is a natural language interface designed for agentic applications to manage and search data in Redis efficiently
A Model Context Protocol (MCP) server that enables secure interaction with MySQL databases
Comments