Mssql MCP
UnclaimedA Model Context Protocol (MCP) server for Microsoft SQL Server, built in C#/.NET 10
Set up this server
01 / Choose your client
02 / Before you connect
Authentication is not specified. Check the project instructions before connecting.
Project instructions03 / Add the configuration
claude mcp add --transport stdio 'codegiveness-mssql-mcp' -- 'npx' '-y' '@codegiveness/mssql-mcp' '--version'04 / Check it in your client
Open your client’s MCP settings and confirm the server connects and lists its tools. A copied configuration does not confirm a working connection.
More in Databases
Browse the full directoryUnclaimed listing
Is this your MCP server?
This listing was auto-indexed from the public record. Claim it to edit the page, set compatibility and unlock growth tools. Takes under two minutes.
Claim this serverSecurity profile
Claimed and verified servers get a weekly static scan that shows what the code can reach: external services, environment variables, shell commands, agent configuration folders, plus any dependencies with known advisories. Claim this listing to get one. How the security profile works
9 of 9 tools
Documented tools (9)
From project documentation. A server handshake does not verify each tool’s description or behavior.
analyze_db_health
Summary health check: size, VLFs, fragmentation, stats staleness, blocking.
analyze_indexes
Missing-index analysis from sys.dmdbmissingindex DMVs (workload-wide or per-query).
execute_sql
Execute a T-SQL batch. SELECT in Restricted; DML/DDL in Unrestricted.
explain_query
Show the execution plan summary (or raw XML) without executing the query.
get_object_details
Return columns, parameters, indexes, and triggers for a specific object.
get_top_queries
Top queries by CPU/duration/reads from sys.dmexecquerystats.
list_databases
List all databases with an iscurrent flag (system DBs excluded).
list_objects
List tables/views/procedures/functions with schema, type, and limit filters (default 1000).
list_schemas
List schemas in the current or specified database.
Tool change history
FAQ
Questions about Mssql MCP Server
- How do I connect Mssql MCP Server to Claude?
- Run `claude mcp add codegiveness-mssql-mcp -- npx -y @codegiveness/mssql-mcp --version` in Claude Code, or add the same command and arguments under mcpServers in Cursor's mcp.json or Claude Desktop's claude_desktop_config.json, then restart the client. The blocks above are ready to paste.
- Is Mssql MCP Server free?
- The listed licence is MIT. Check the upstream terms for permitted use and commercial requirements; a public repository does not by itself mean the software is free or open source. Connected APIs and hosted services may have separate charges.
- What can Mssql MCP Server do?
- Mssql MCP Server documents 9 tools to the agent, including analyze_db_health, analyze_indexes, execute_sql. The descriptions above come from project documentation. A live handshake does not test individual tool behavior.