All servers / Database / Microsoft SQL MCP server
Microsoft SQL MCP server
MCP Server for MS SQL Server integration with Claude Desktop, Cursor, Windsurf and VS Code
Tested by ConnectATDScore 83 out of 100. Tested 2026-11-19 on package version 3.0.0. Package: mssql-mcp · source
Score breakdown
| Runs | 18 / 20 | |
|---|---|---|
| Tool descriptions | 17 / 20 | |
| Package safety | 20 / 20 | |
| Maintenance | 20 / 20 | |
| Adoption | 8 / 20 |
What we saw
- Starts and answers the MCP handshake: yes (6.9 seconds including download)
- Tools offered: 14
- Last published: 2026-09-14
- Weekly downloads (npm): 669
- License: MIT · Direct dependencies: 5
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.
mssql_connect_databaseno parametersConnects 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_databaseno parametersCloses the current database connection and releases the connection pool. Safe to call even if not connected. Idempotent.
mssql_connection_statusno parametersReturns the current connection status, server address, database name, and connection pool metrics. Read-only. Safe to call at any time.
mssql_run_sql_query3 of 3 parameters describedExecutes 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_query2 of 3 parameters describedDeprecated alias for mssql_run_sql_query. Use mssql_run_sql_query instead. ⚠️ This tool can read AND modify data.
mssql_list_schema_objects5 of 5 parameters describedLists 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_schema0 of 3 parameters describedDeprecated alias for mssql_list_schema_objects. Use mssql_list_schema_objects instead.
mssql_describe_table_columns3 of 3 parameters describedReturns column definitions for a table: name, data type, length, nullability, default, and ordinal position. Read-only. Uses parameterized queries to prevent injection.
mssql_describe_table0 of 3 parameters describedDeprecated alias for mssql_describe_table_columns.
mssql_read_table_rows9 of 9 parameters describedReturns 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_data0 of 8 parameters describedDeprecated alias for mssql_read_table_rows. Use mssql_read_table_rows instead. ⚠️ whereClause must use @paramName placeholders for all values.
mssql_execute_stored_procedure4 of 4 parameters describedExecutes 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_procedure1 of 4 parameters describedDeprecated alias for mssql_execute_stored_procedure.
mssql_list_databases3 of 3 parameters describedLists all databases visible on the connected SQL Server instance with state and recovery information. Read-only. Supports pagination.
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.