// SCAN REPORT

MCP SQL Server

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

1 destructive tool with no built-in limits. Policy required.

Last updated: 12 Jun 2026

4 can modify or destroy data

7 read-only

11 tools total

Community server · catalogue entry verified 12/06/2026

How to control MCP SQL Server ↓

TOOL MAP

What MCP SQL Server exposes to your agents

Read (7) Write / Execute (3) Destructive / Financial (1)

Running more than one server? Check your whole stack →

MOST DANGEROUS TOOLS

Critical Risk

The most dangerous MCP SQL Server tools

Destructive · High clear_caches Cache clearing is a destructive operation that cannot be undone. Execute · High execute_query SQL query execution is a classic Execute category action—it runs code (SQL) whose effects depend on the arguments (the query text). Execute · High start_batch_processing The tool permits execution of multiple SQL queries whose effects depend on the content of those queries. Execute · Medium start_performance_monitoring This tool initiates an external operation (performance monitoring) on the database system rather than passively retrieving data.

4 of MCP SQL Server'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 MCP SQL Server

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

Deny destructive operations

{
  "clear_caches": {
    "deny_if": [
      {
        "conditions": [],
        "on_deny": "Blocked by default. Requires approval."
      }
    ]
  }
}

Destructive tools should never be available to autonomous agents without human approval.

Cap read operations

{
  "describe_table": {
    "limits": [
      {
        "counter": "describe_table_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 MCP SQL Server — 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 MCP SQL →

Free to start. No card required.

FULL CATALOGUE

All 11 MCP SQL Server tools

DESTRUCTIVE 1 tools

Destructive clear_caches Initialize cache data

EXECUTE 3 tools

Execute execute_query Execute SQL queries Execute start_batch_processing Process multiple queries in batch Execute start_performance_monitoring Start performance monitoring

READ 7 tools

Read describe_table Get structure of a specific table Read get_connection_pool_status Get database connection pool status Read get_query_stats Get query execution statistics Read get_schema Get database schema information Read get_schema_statistics Get schema statistics information Read list_tables Get list of database tables Read generate_performance_report Generate performance analysis report

EXPLORE

Related servers

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

FAQ

Questions about MCP SQL Server

Can an AI agent delete data through the MCP SQL Server MCP server? +

Yes. The MCP SQL Server server exposes 1 destructive tools including clear_caches. These permanently remove resources with no undo. PolicyLayer blocks destructive tools by default so they never reach the upstream server.

How many tools does the MCP SQL Server MCP server expose? +

11 tools across 4 categories: Destructive, Execute, Read, Write. 7 are read-only. 4 can modify, create, or delete data.

How do I enforce a policy on MCP SQL Server? +

Register the MCP SQL Server 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 MCP SQL Server tool call.

Deterministic rules across all 11 MCP SQL Server tools. Per-identity grants. Full audit log. Live in minutes. Nothing to install.

ENFORCE POLICY ON MCP SQL →

Free to start. No card required.

11 MCP SQL Server tools catalogued and risk-classified — across an index of 43,000+ MCP servers.