// SCAN REPORT

Mssql Mcp Node

11 tools. 2 can modify or destroy data without limits.

2 write tools that can modify data. Rate limits recommended.

Last updated: 29 Jun 2026

2 can modify or destroy data

9 read-only

11 tools total

Verified server · catalogue entry verified 29/06/2026 · full schemas captured for 10 of 11 tools

How to control Mssql Mcp Node ↓

TOOL MAP

What Mssql Mcp Node exposes to your agents

Read (9) Write / Execute (2) Destructive / Financial (0)

Running more than one server? Check your whole stack →

CONTEXT-WINDOW COST

What Mssql Mcp Node costs in tokens

1,990 tokens of tool definitions, loaded on every request

1.0% of a 200k context window

350 heaviest tool: execute_read_query

Full per-tool breakdown → Model it in the token calculator →

MOST DANGEROUS TOOLS

High Risk

The most dangerous Mssql Mcp Node tools

Execute · High execute_read_query Although intended for read-only SELECT queries, the tool executes arbitrary SQL inside a transaction that can be escaped via COMMIT TRANSACTION, allowing writes and DDL to persist. Execute · Critical execute_write_query This tool executes arbitrary mutating SQL, which can include INSERT, UPDATE, DELETE, DROP, or TRUNCATE statements with no keyword-level restrictions.

2 of Mssql Mcp Node's 11 tools can modify, destroy, or commit something on every call — and an agent calls them with no built-in limits.

POLICY

How to control Mssql Mcp Node

PolicyLayer is an MCP gateway — it sits between your AI agents and Mssql Mcp Node, and nothing reaches the server without passing your rules. These are the rules we recommend:

Cap read operations

{
  "describe_database": {
    "limits": [
      {
        "counter": "describe_database_per_minute",
        "window": "minute",
        "max": 60,
        "scope": "grant"
      }
    ]
  }
}

Controls API costs and prevents retry loops from exhausting upstream rate limits.

Create a free account and register Mssql Mcp Node — nothing to install.
Add these rules — paste them, or build them visually. Tune the limits to your setup.
Point your MCP client (Claude, Cursor, anything) at your gateway URL.

ENFORCE POLICY ON MSSQL MCP NODE →

Instant setup, no code required.

FULL CATALOGUE

All 11 Mssql Mcp Node tools

EXECUTE 2 tools

Execute execute_read_query Run a SELECT-style SQL query against a configured database. The query executes inside a transaction that is AL Execute execute_write_query Run a mutating SQL statement. DISABLED unless MSSQL_ENABLE_WRITES=true. There is no keyword denylist - the dat

READ 9 tools

Read describe_database High-level summary of a configured database: object counts (tables/views/procs) and the current user. Read describe_procedure Parameters of a stored procedure. Accepts bare or schema.procedure identifiers (e.g. dbo.usp_UpdateUser). Read describe_table Column schema for a table. Accepts bare or schema.table identifiers (e.g. dbo.Users). Read list_databases Lists every database the server has credentials for, plus connection-pool status. Passwords are never returned Read list_foreign_keys Foreign-key relationships in the database, optionally filtered to one table. Paginated - large schemas should Read list_indexes Indexes on a specific table, including columns and uniqueness/primary-key flags. Use to inform JOIN and WHERE Read list_stored_procedures Paginated list of stored procedures. Read list_tables Paginated list of base tables. Use offset/limit to walk the catalog. Returns total row count for the caller to Read list_views Paginated list of views. Use offset/limit to walk the catalog.

EXPLORE

Related servers

Other MCP servers with similar tools — same risk classification, starter policies for each.

FAQ

Questions about Mssql Mcp Node

Is the Mssql Mcp Node MCP server safe to use without restrictions? +

The Mssql Mcp Node server is primarily read-only with 9 read tools. While it cannot modify data, an agent in a retry loop can make thousands of API calls per minute, exhausting rate limits and running up costs. Rate limiting is still recommended.

How many tools does the Mssql Mcp Node MCP server expose? +

11 tools across 2 categories: Execute, Read. 9 are read-only. 2 can modify, create, or delete data.

How do I enforce a policy on Mssql Mcp Node? +

Register the Mssql Mcp Node MCP server in PolicyLayer, apply the suggested rules above (adjust the limits to your use case), and point your AI client at the PolicyLayer proxy URL instead of the server directly. Your agents keep the same tools; PolicyLayer evaluates every call against policy before it executes. Nothing to install, live in minutes.

Enforce policy on every Mssql Mcp Node tool call.

Deterministic rules across all 11 Mssql Mcp Node tools. Per-identity grants. Full audit log. Live in minutes. Nothing to install.

ENFORCE POLICY ON MSSQL MCP NODE →

Instant setup, no code required.

11 Mssql Mcp Node tools catalogued and risk-classified — across an index of 43,000+ MCP servers.