All servers / Database / Microsoft SQL MCP server
Microsoft SQL MCP server
MCP server for Microsoft SQL Server database access and comprehensive schema exploration using tedious. Includes enhanced stored procedure tools for complete SQ
Tested by ConnectATDScore 84 out of 100. Tested 2026-11-18 on package version 1.3.0. Package: mssql-mcp-server · source
Score breakdown
| Runs | 18 / 20 | |
|---|---|---|
| Tool descriptions | 20 / 20 | |
| Package safety | 20 / 20 | |
| Maintenance | 14 / 20 | |
| Adoption | 12 / 20 |
What we saw
- Starts and answers the MCP handshake: yes (6.5 seconds including download)
- Tools offered: 33
- Last published: 2026-07-01
- Weekly downloads (npm): 2,367
- License: MIT · Direct dependencies: 4
Want this server set up for your team?
ConnectATD builds AI automation and wires up MCP servers like this one. Tell us what you are trying to do.
Talk to ConnectATDTools and how they are described
Agents choose tools from these descriptions. Under each name you can see how many of its parameters are explained.
list_connectionsno parametersList all available named database connections configured in the server
test_connection1 of 1 parameter describedTest the database connection and return basic server information
list_databases1 of 1 parameter describedList all databases available on the SQL Server instance
list_tables2 of 2 parameters describedList all tables in the connected database
describe_table3 of 3 parameters describedGet detailed schema information for a specific table including columns, data types, and constraints
sample_data4 of 4 parameters describedRetrieve sample data from a table (top 10 rows by default)
execute_query2 of 2 parameters describedExecute a custom SQL SELECT query with automatic limit (top 20 rows). Disabled unless MSSQL_ENABLE_EXECUTE_QUERY=true.
get_relationships2 of 2 parameters describedGet foreign key relationships between tables in the database
list_stored_procedures3 of 3 parameters describedList all stored procedures, functions, and their basic information
describe_stored_procedure4 of 4 parameters describedGet detailed information about a specific stored procedure including parameters and definition
list_views3 of 3 parameters describedList all views in the database with their basic information
describe_view4 of 4 parameters describedGet detailed information about a specific view including its definition and dependencies
list_triggers3 of 3 parameters describedList all triggers in the database with their associated tables
describe_trigger3 of 3 parameters describedGet detailed information about a specific trigger including its definition and events
list_functions3 of 3 parameters describedList all user-defined functions (scalar, table-valued, etc.)
list_indexes4 of 4 parameters describedList all indexes on tables with usage statistics and detailed information
analyze_table_stats3 of 3 parameters describedGet table row counts, size information, and last update statistics
find_missing_indexes3 of 3 parameters describedIdentify potentially missing indexes based on query execution patterns
analyze_index_usage4 of 4 parameters describedShow detailed index usage statistics to identify unused or underutilized indexes
analyze_database_size1 of 1 parameter describedGet comprehensive database size information including data and log file sizes
list_constraints3 of 3 parameters describedList all constraints (check, unique, foreign key, etc.) across tables in the database
analyze_check_constraints3 of 3 parameters describedExtract and analyze business rules from check constraints
list_user_defined_types2 of 2 parameters describedList all user-defined data types and their definitions
find_computed_columns3 of 3 parameters describedList computed columns and their formulas to understand derived business logic
list_default_constraints3 of 3 parameters describedList all default value constraints and their definitions
analyze_data_distribution5 of 5 parameters describedGet data distribution patterns for columns to understand data quality and patterns
find_lookup_tables3 of 3 parameters describedIdentify reference/lookup tables automatically based on table patterns
analyze_null_patterns3 of 3 parameters describedFind columns with high null percentages and analyze null patterns
detect_audit_columns2 of 2 parameters describedIdentify common audit trail patterns (created/modified dates, user tracking)
get_stored_procedure_definition4 of 4 parameters describedGet the complete SQL query/definition of a stored procedure - this is the actual source code
get_multiple_stored_procedure_definitions4 of 4 parameters describedGet complete SQL definitions for multiple stored procedures at once
get_all_stored_procedure_definitions4 of 4 parameters describedGet complete SQL definitions for all stored procedures in a schema
search_stored_procedures_by_content5 of 5 parameters describedSearch for stored procedures containing specific text or patterns in their SQL definition
Tested in a sandbox with an empty environment: no API keys, a throwaway folder, nothing from a real account. A passing test shows the server runs and responds. It is not a security audit.