All servers / Database / SQL Server MCP server
SQL Server MCP server
MCP server for Microsoft SQL Server
Tested by ConnectATDScore 84 out of 100. Tested 2026-11-19 on package version 3.0.4. Package: mssql-mcp-node · source
Score breakdown
| Runs | 18 / 20 | |
|---|---|---|
| Tool descriptions | 18 / 20 | |
| Package safety | 20 / 20 | |
| Maintenance | 20 / 20 | |
| Adoption | 8 / 20 |
What we saw
- Starts and answers the MCP handshake: yes (9.4 seconds including download)
- Tools offered: 11
- Last published: 2026-09-11
- Weekly downloads (npm): 573
- 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.
execute_read_query4 of 4 parameters describedRun a SELECT-style SQL query against a configured database. The query executes inside a transaction that is ALWAYS rolled back, so accidental DML/DDL is non-durable (this is a guardrail, not a sandbox: an explicit `COMMIT TRANSACTION` in the query string ends the wrapper and following writes will persist - rely on a least-privilege SQL login for real isolation). Results are streamed; the server cancels the underlying request once `offset + limit` rows have been seen, so `truncated:true` means more rows exist.
execute_write_query2 of 2 parameters describedRun a mutating SQL statement. DISABLED unless MSSQL_ENABLE_WRITES=true. There is no keyword denylist - the database user's grants are the source of truth. Use a least-privilege account for the relevant `dbKey`.
list_databasesno parametersLists every database the server has credentials for, plus connection-pool status. Passwords are never returned.
describe_database1 of 1 parameter describedHigh-level summary of a configured database: object counts (tables/views/procs) and the current user.
list_tables3 of 3 parameters describedPaginated list of base tables. Use `offset`/`limit` to walk the catalog. Returns total row count for the caller to size pagination.
list_views3 of 3 parameters describedPaginated list of views. Use `offset`/`limit` to walk the catalog.
list_indexes1 of 2 parameters describedIndexes on a specific table, including columns and uniqueness/primary-key flags. Use to inform JOIN and WHERE choices.
list_foreign_keys3 of 4 parameters describedForeign-key relationships in the database, optionally filtered to one table. Paginated - large schemas should narrow with `table` or walk pages.
list_stored_procedures3 of 3 parameters describedPaginated list of stored procedures.
describe_table1 of 2 parameters describedColumn schema for a table. Accepts bare or `schema.table` identifiers (e.g. `dbo.Users`).
describe_procedure1 of 2 parameters describedParameters of a stored procedure. Accepts bare or `schema.procedure` identifiers (e.g. `dbo.usp_UpdateUser`).
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.