About Sqlserver MCP
Sqlserver MCP is an MCP server published by EdmondLu in the Blockchain category: an MCP server that allows Claude Code to diagnose a database conversationally, using battle-tested queries. Built for teams to easily gather DB diagnostic.
The repository has 4 stars and 1 forks, with the last commit a month ago. Recent commit activity is the strongest signal that reported issues will get attention.
Install
git clone https://github.com/EdmondLu/sqlserver-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 (44)
analyze_module_temp_tablesAnalyze local temp table creation, usage, multiline statements, and column flow inside a module
Parameters not published.
batch_metadataRun independent metadata requests in parallel with per-item errors
Parameters not published.
compare_module_to_fileCompare a database module definition with a known local file
Parameters not published.
compare_module_to_repoAuto-discover matching repository `.sql` files and compare the best unambiguous candidate with the database module
Parameters not published.
compare_modules_to_filesValidate and compare an ordered deployment set with differences-only, field selection, diff suppression, and token budgets
Parameters not published.
compare_report_payloadsCompare original/candidate report containers and decompressed bytes without XML reserialization
Parameters not published.
compare_table_to_fileCompare a CREATE TABLE script's effective structure with the target table
Parameters not published.
describe_query_resultDescribe guarded query result columns without executing the query, optionally applying explicit UI placeholder replacements
Parameters not published.
describe_tableInspect compact `shape`, `write_contract`, `keys`, `performance`, or `full` metadata
Parameters not published.
explain_query_planReturn an estimated-plan summary, with raw XML only when requested
Parameters not published.
Show all 44 tools
explain_query_plan_summaryReturn only the compact estimated-plan summary
Parameters not published.
find_columnFind tables and views containing a column
Parameters not published.
find_field_consumersCombine column, module, and configured page/low-code consumers
Parameters not published.
find_objectsSearch tables, views, procedures, and functions
Parameters not published.
find_page_by_save_procedureFind configured pages that reference a save procedure
Parameters not published.
find_page_by_tableFind configured pages that reference a table or view
Parameters not published.
find_usageRank literal identifier/text/regex usage with source location and confidence
Parameters not published.
generate_guarded_report_patchGenerate but never execute an exact-byte-replacement patch whose default branch is read-only preflight
Parameters not published.
get_calleesFind confirmed/static/dynamic callees
Parameters not published.
get_callersFind confirmed/static/dynamic callers and caller transaction signals
Parameters not published.
get_constraintsInspect key, unique, default, and check constraints
Parameters not published.
get_dependenciesFind incoming and outgoing dependencies
Parameters not published.
get_dependency_graphBuild a bounded confirmed dependency graph
Parameters not published.
get_foreign_keysInspect incoming and outgoing foreign keys
Parameters not published.
get_indexesInspect index metadata
Parameters not published.
get_module_definitionRead a module definition, optionally by keyword or line range, with explicit discontinuous `slices[]`
Parameters not published.
get_object_overviewReturn compact metadata and dependency context
Parameters not published.
health_checkDistinguish MCP version, SQL Server product version/edition, SQL permissions, MCP policy, and effective blockers
Parameters not published.
inspect_report_payloadValidate Base64/GZip/UTF-8/XML report bytes, BOM/declaration/newlines, and optional node uniqueness offline
Parameters not published.
profile_columnProfile NULL/empty values, lengths, format quality, limit saturation, and samples
Parameters not published.
read_lobHash one complete text/binary LOB and return resumable untruncated text or Base64 chunks
Parameters not published.
reload_connectionClear cached credentials, SQL connection pools, and metadata snapshots
Parameters not published.
replace_report_payload_fragmentBuild a candidate offline through one unique exact decompressed-byte replacement, without XML reserialization or a database connection
Parameters not published.
resolve_objectResolve exact and similar object names, including legacy view-to-table mappings
Parameters not published.
run_readonly_batchRun a rollback-only diagnostic batch with local variables, local `#temp` DML, and multiple result sets
Parameters not published.
run_readonly_queryRun one guarded read-only query with optional named parameters
Parameters not published.
search_config_textSearch configured application/configuration text and locator metadata with match-column and audit metadata
Parameters not published.
search_sql_modulesSearch SQL module definitions with next-step compare hints
Parameters not published.
test_connectionValidate the connection and current SQL identity
Parameters not published.
validate_deploymentCombine one module file's static validation, target comparison, drift, and deployment risk
Parameters not published.
validate_tsql_fileSummary-first static validation of a local `.sql` file without claiming unverified deployment safety
Parameters not published.
validate_tsql_scriptSummary-first static parse/metadata validation without execution or database writes
Parameters not published.
verify_config_patch_fileParse a configuration UPDATE patch and verify its allow-listed current value without writes
Parameters not published.
verify_deployment_setVerify tables, modules, and configuration patches together with one deployment state
Parameters not published.
Ask AI
Ask AI about Sqlserver MCP
Powered by Claude · Grounded in docs
Security checks
6 checks have not been run yet.