EdmondLu/sqlserver-mcp

tools

• analyze_module_temp_tables

  Analyze local temp table creation, usage, multiline statements, and column flow inside a module

• batch_metadata

  Run independent metadata requests in parallel with per-item errors

• compare_module_to_file

  Compare a database module definition with a known local file

• compare_module_to_repo

  Auto-discover matching repository .sql files and compare the best unambiguous candidate with the database module

• compare_modules_to_files

  Validate and compare an ordered deployment set with differences-only, field selection, diff suppression, and token budgets

• compare_table_to_file

  Compare a CREATE TABLE script's effective structure with the target table

• describe_query_result

  Describe guarded query result columns without executing the query, optionally applying explicit UI placeholder replacements

• describe_table

  Inspect compact shape, write_contract, keys, performance, or full metadata

• explain_query_plan

  Return an estimated-plan summary, with raw XML only when requested

• explain_query_plan_summary

  Return only the compact estimated-plan summary

• find_column

  Find tables and views containing a column

• find_field_consumers

  Combine column, module, and configured page/low-code consumers

• find_objects

  Search tables, views, procedures, and functions

• find_page_by_save_procedure

  Find configured pages that reference a save procedure

• find_page_by_table

  Find configured pages that reference a table or view

• find_usage

  Rank literal identifier/text/regex usage with source location and confidence

• get_callees

  Find confirmed/static/dynamic callees

• get_callers

  Find confirmed/static/dynamic callers and caller transaction signals

• get_constraints

  Inspect key, unique, default, and check constraints

• get_dependencies

  Find incoming and outgoing dependencies

• get_dependency_graph

  Build a bounded confirmed dependency graph

• get_foreign_keys

  Inspect incoming and outgoing foreign keys

• get_indexes

  Inspect index metadata

• get_module_definition

  Read a module definition, optionally by keyword or line range, with explicit discontinuous slices[]

• get_object_overview

  Return compact metadata and dependency context

• health_check

  Distinguish MCP version, SQL Server product version/edition, SQL permissions, MCP policy, and effective blockers

• profile_column

  Profile NULL/empty values, lengths, format quality, limit saturation, and samples

• reload_connection

  Clear cached credentials, SQL connection pools, and metadata snapshots

• resolve_object

  Resolve exact and similar object names, including legacy view-to-table mappings

• run_readonly_batch

  Run a rollback-only diagnostic batch using local #temp state

• run_readonly_query

  Run one guarded read-only query with optional named parameters

• search_config_text

  Search configured application/configuration text and locator metadata with match-column and audit metadata

• search_sql_modules

  Search SQL module definitions with next-step compare hints

• test_connection

  Validate the connection and current SQL identity

• validate_deployment

  Combine one module file's static validation, target comparison, drift, and deployment risk

• validate_tsql_file

  Summary-first static validation of a local .sql file without claiming unverified deployment safety

• validate_tsql_script

  Summary-first static parse/metadata validation without execution or database writes

• verify_config_patch_file

  Parse a configuration UPDATE patch and verify its allow-listed current value without writes

• verify_deployment_set

  Verify tables, modules, and configuration patches together with one deployment state