mssql-mcp
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 4 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@3.0.0
Installing a package runs its code. Use a sandbox for anything you have not read.
Calling its tools
4 tools that take no input and look read-only were called once with nothing. 1 returned a result.
mssql_connection_status | Returned a result under 0.1 s · 63 characters |
mssql_list_schema_objects | No usable answer tool reported an error: ❌ Schema query failed: No active database connection. Use connect_database first. |
mssql_get_schema | No usable answer tool reported an error: ❌ Schema query failed: No active database connection. Use connect_database first. |
mssql_list_databases | No usable answer tool reported an error: ❌ List databases failed: No active database connection. Use connect_database first. |
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.
1 tool with commands in capitals or very long text
- Gives the agent orders in
mssql_read_table_rows:ames are validated as safe identifiers. WHERE clause values MUST be passed via 'parameters' using @paramName placeholders. Pagination: limit (1-200, default 20) and
Common and usually harmless: it is how many makers stress how a tool should be used.
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
mssql_connect_database
Connects to MS SQL Server using environment variables (DB_SERVER, DB_DATABASE, DB_USER, DB_PASSWORD, DB_PORT, DB_ENCRYPT, DB_TRUST_SERVER_CERTIFICATE). No credentials accepted as parameters — all connection settings come from the server environment only. Idempotent: calling again reconnects.
mssql_disconnect_database
Closes the current database connection and releases the connection pool. Safe to call even if not connected. Idempotent.
mssql_connection_status
Returns the current connection status, server address, database name, and connection pool metrics. Read-only. Safe to call at any time.
mssql_run_sql_query query, parameters, response_format
Executes an arbitrary SQL statement against the connected database. ⚠️ WARNING: This tool can read AND modify data (INSERT, UPDATE, DELETE, DDL). Always prefer parameterized inputs via the 'parameters' field — never embed user-supplied values directly in the query string. Example: query='SELECT * FROM dbo.Users WHERE Id = @id', parameters={id: 42}mssql_execute_query query, parameters, response_format
Deprecated alias for mssql_run_sql_query. Use mssql_run_sql_query instead. ⚠️ This tool can read AND modify data.
9 more tools
mssql_list_schema_objects objectType, schemaName, limit, offset, response_format
Lists tables, views, stored procedures, or functions in the connected database. Read-only. Supports filtering by schema name and pagination. Example: objectType='tables', schemaName='dbo', limit=20
mssql_get_schema objectType, schemaName, response_format
Deprecated alias for mssql_list_schema_objects. Use mssql_list_schema_objects instead.
mssql_describe_table_columns tableName, schemaName, response_format
Returns column definitions for a table: name, data type, length, nullability, default, and ordinal position. Read-only. Uses parameterized queries to prevent injection.
mssql_describe_table tableName, schemaName, response_format
Deprecated alias for mssql_describe_table_columns.
mssql_read_table_rows tableName, schemaName, columns, limit, offset, whereClause, orderBy, parameters, response_format
Returns rows from a table with optional column projection, WHERE filtering, ORDER BY, and pagination. Read-only. Table and schema names are validated as safe identifiers. WHERE clause values MUST be passed via 'parameters' using @paramName placeholders. Pagination: limit (1-200, default 20) and offset. Example: tableName='Orders', schemaName='dbo', columns=['OrderId','Total'], limit=50
mssql_get_table_data tableName, schemaName, limit, offset, whereClause, orderBy, parameters, response_format
Deprecated alias for mssql_read_table_rows. Use mssql_read_table_rows instead. ⚠️ whereClause must use @paramName placeholders for all values.
mssql_execute_stored_procedure procedureName, schemaName, parameters, response_format
Executes a stored procedure by name. ⚠️ May modify data — use only when an action is intended. Schema and procedure names are validated as safe identifiers. Pass all value parameters via 'parameters'.
mssql_execute_procedure procedureName, schemaName, parameters, response_format
Deprecated alias for mssql_execute_stored_procedure.
mssql_list_databases limit, offset, response_format
Lists all databases visible on the connected SQL Server instance with state and recovery information. Read-only. Supports pagination.
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/BYMCS/mssql-mcp |
| Install scripts | None declared by it or anything installed with it. |
| Tarball | sha512-azf2othoh7sayIbluOtA85U8UTjE8Iznay9tfgnrXjcizw0KN1XAmFAVL41eocDUuqrYDZcwiSF9AvXcAnGn2w== |
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)
New version out? Ask for a fresh report.