About Ms SQL MCP
Ms SQL MCP is an MCP server in the Science category: microsoft SQL Server MCP.
Install
git clone https://github.com/A-Point-Systems-ltd/ms-sql-mcpThis server has no ConduID identity, so agent calls to it are not receipted. Pin the version you install and review the source before granting it credentials.
Tools (6)
**DescribeTable**Full table metadata: columns (type, nullability, descriptions), indexes, constraints, foreign keys, triggers. Preferred over ad-hoc `sys.*` queries for one table.
Parameters not published.
**DescribeView**View metadata, column list, and full T-SQL definition.
Parameters not published.
**GetObject**Stored procedure, function, or trigger: parameters (where applicable) + definition. `objectType`: `StoredProcedure`, `Function`, or `Trigger`. Trigger names accept `name`, `schema.name`, or `schema.table.name`.
Parameters not published.
**GetServerInfo**Server version/edition, hardware DMVs (with graceful degradation), and user-database counts.
Parameters not published.
**ListObjects**List objects by `objectType`: `Table`, `View`, `StoredProcedure`, `TableFunction`, `ScalarFunction`, `Function` (scalar + table), `TableTrigger`, `SysObject`. Optional `partialName` does a `LIKE` filter on name and `schema.name`. For `SysObject`, optional `sysObjectType` filters by `sys.objects.type` (`U`, `V`, `P`, `FN`, …).
Parameters not published.
**ReadData****All** read-only `SELECT` / `WITH … SELECT` queries. Use for user tables, `sys.*`, `INFORMATION_SCHEMA`, and DMVs.
Parameters not published.
Ask AI
Ask AI about Ms SQL MCP
Powered by Claude · Grounded in docs
Security checks
6 checks have not been run yet.