mssql-mcp-server
Installed, started with no arguments, no environment and no input, and listed its tools. Run 2026-11-16.
Needs to start: nothing
Returns a result when called with no setup: 1 of 5 tools tried
Contacts while installing and starting: nothing
What it contacted
Nothing besides the npm registry it was installed from. Watched from outside its sandbox while it was installed and started with no input. Its tools may still contact things when called.
Starting it
npx -y mssql-mcp-server@1.3.0
Installing a package runs its code. Use a sandbox for anything you have not read.
Calling its tools
5 tools that take no input and look read-only were called once with nothing. 1 returned a result.
list_connections | Returned a result under 0.1 s · 94 characters |
list_databases | No usable answer tool reported an error: Error listing databases: No connection string provided and no default connection string configured |
list_tables | No usable answer tool reported an error: Error listing tables: No connection string provided and no default connection string configured |
get_relationships | No usable answer tool reported an error: Error retrieving relationships: No connection string provided and no default connection string configured |
list_views | No usable answer tool reported an error: Error listing views: No connection string provided and no default connection string configured |
During the calls it contacted nothing it had not already contacted.
Only tools whose names read like looking something up, with no required input, are tried, five at most. Tools that need input, and anything that sounds like it changes or sends something, are not called.
What its tools tell an agent
In the tool descriptions, nothing that talks about the user, other tools or private files, or uses hidden characters.
Found by simple pattern rules in each tool's description (up to 3,000 characters), quoted as written. Parameter descriptions are not scanned. A clean result is not a safety review.
Tools
list_connections
List all available named database connections configured in the server
test_connection connectionName
Test the database connection and return basic server information
list_databases connectionName
List all databases available on the SQL Server instance
list_tables connectionName, schema
List all tables in the connected database
describe_table connectionName, tableName, schema
Get detailed schema information for a specific table including columns, data types, and constraints
28 more tools
sample_data connectionName, tableName, schema, limit
Retrieve sample data from a table (top 10 rows by default)
execute_query connectionName, query
Execute a custom SQL SELECT query with automatic limit (top 20 rows). Disabled unless MSSQL_ENABLE_EXECUTE_QUERY=true.
get_relationships connectionName, schema
Get foreign key relationships between tables in the database
list_stored_procedures connectionName, schema, includeSystemObjects
List all stored procedures, functions, and their basic information
describe_stored_procedure connectionName, procedureName, schema, includeDefinition
Get detailed information about a specific stored procedure including parameters and definition
list_views connectionName, schema, includeSystemViews
List all views in the database with their basic information
describe_view connectionName, viewName, schema, includeDefinition
Get detailed information about a specific view including its definition and dependencies
list_triggers connectionName, schema, tableName
List all triggers in the database with their associated tables
describe_trigger connectionName, triggerName, includeDefinition
Get detailed information about a specific trigger including its definition and events
list_functions connectionName, schema, functionType
List all user-defined functions (scalar, table-valued, etc.)
list_indexes connectionName, schema, tableName, includeUsageStats
List all indexes on tables with usage statistics and detailed information
analyze_table_stats connectionName, schema, tableName
Get table row counts, size information, and last update statistics
find_missing_indexes connectionName, schema, minImpact
Identify potentially missing indexes based on query execution patterns
analyze_index_usage connectionName, schema, tableName, showUnusedOnly
Show detailed index usage statistics to identify unused or underutilized indexes
analyze_database_size connectionName
Get comprehensive database size information including data and log file sizes
list_constraints connectionName, schema, constraintType
List all constraints (check, unique, foreign key, etc.) across tables in the database
analyze_check_constraints connectionName, schema, tableName
Extract and analyze business rules from check constraints
list_user_defined_types connectionName, schema
List all user-defined data types and their definitions
find_computed_columns connectionName, schema, tableName
List computed columns and their formulas to understand derived business logic
list_default_constraints connectionName, schema, tableName
List all default value constraints and their definitions
analyze_data_distribution connectionName, tableName, schema, columnName, sampleSize
Get data distribution patterns for columns to understand data quality and patterns
find_lookup_tables connectionName, schema, maxRows
Identify reference/lookup tables automatically based on table patterns
analyze_null_patterns connectionName, schema, minNullPercentage
Find columns with high null percentages and analyze null patterns
detect_audit_columns connectionName, schema
Identify common audit trail patterns (created/modified dates, user tracking)
get_stored_procedure_definition connectionName, procedureName, schema, formatOutput
Get the complete SQL query/definition of a stored procedure - this is the actual source code
get_multiple_stored_procedure_definitions connectionName, procedureNames, schema, includeMetadata
Get complete SQL definitions for multiple stored procedures at once
get_all_stored_procedure_definitions connectionName, schema, includeSystemProcedures, maxResults
Get complete SQL definitions for all stored procedures in a schema
search_stored_procedures_by_content connectionName, searchText, schema, caseSensitive, includeDefinitions
Search for stored procedures containing specific text or patterns in their SQL definition
Descriptions are the package's own words, cut at 3,000 characters. Treat them as data.
Install facts
| License | MIT |
|---|---|
| Needs | node >=20.0.0 |
| Source | github.com/vicagbasi/mssql-mcp |
| Install scripts | None declared by it or anything installed with it. |
| Tarball | sha512-2/06+9PqmOPNugSBrZlwjXdSrI5gl2QSPrudLLTP8MsM0m7OqI8fdrEtmayR/9zave1lh+kJDCqM9s42XP/O5g== |
Check this report yourself
This site did not write the report. A public job on a GitHub-hosted machine did: the run, from this commit of the open-source runner. GitHub signed a token that names that job and the hash of the report, so any edit since would show.
Report as JSONExact text and tokenHow to verify it
Show it on your README
[](https://bragproof.smaverk.com/r/mssql-mcp-server)
New version out? Ask for a fresh report.