About codegiveness.mssql-mcp
codegiveness.mssql-mcp is an MCP server in the Science category: a Model Context Protocol (MCP) server for Microsoft SQL Server, built in C#/.NET 10. Lets AI agents (Claude Desktop, Cursor, etc.) safely query and interact with SQL Server databases through a controlled tool surface.
Install
git clone https://github.com/codegiveness/mssql-mcpThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Tools (9)
analyze_db_healthSummary health check: size, VLFs, fragmentation, stats staleness, blocking.
Parameters not published.
analyze_indexesMissing-index analysis from `sys.dm_db_missing_index_*` DMVs (workload-wide or per-query).
Parameters not published.
execute_sqlExecute a T-SQL batch. SELECT in Restricted; DML/DDL in Unrestricted.
Parameters not published.
explain_queryShow the execution plan summary (or raw XML) without executing the query.
Parameters not published.
get_object_detailsReturn columns, parameters, indexes, and triggers for a specific object.
Parameters not published.
get_top_queriesTop queries by CPU/duration/reads from `sys.dm_exec_query_stats`.
Parameters not published.
list_databasesList all databases with an `is_current` flag (system DBs excluded).
Parameters not published.
list_objectsList tables/views/procedures/functions with schema, type, and limit filters (default 1000).
Parameters not published.
list_schemasList schemas in the current or specified database.
Parameters not published.
Ask AI
Ask AI about codegiveness.mssql-mcp
Powered by Claude · Grounded in docs
Security checks
6 checks have not been run yet.