claude-database-tools

delete_data

Permanently removes records from database tables using physical DELETE operations. Use with caution as this bypasses soft delete patterns and cannot be undone.

Instructions

Executes a physical DELETE operation on table records. WARNING: This database uses soft delete patterns (__deleted flag). Consider using update_data to set __deleted = 1 instead for most use cases.

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "tableName": "<tableName>",
      "whereClause": "<whereClause>",
      "confirmDelete": "<confirmDelete>"
    },
    "name": "delete_data"
  }
}

Input Schema

Name	Required	Description
`tableName`	Yes	Name of the table to delete from
`whereClause`	Yes	WHERE clause to identify which records to delete. REQUIRED for safety.
`confirmDelete`	Yes	Must be set to true to confirm physical deletion. Physical deletes are permanent and bypass the soft delete pattern.

Schema Changelog

Changes observed during successful MCP inspections.

First observedv1.0.0Jan 24, 2026

TDQS

A4.4/5.0

Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries full burden and does so effectively: it discloses that this is a physical DELETE (implying permanent, destructive operation), mentions the database's soft delete pattern, and warns about permanence. It doesn't cover rate limits or auth needs, but provides substantial behavioral context.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is perfectly concise with two sentences that each earn their place: the first states the core operation, the second provides critical warnings and alternatives. No wasted words, front-loaded with essential information.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a destructive tool with no annotations and no output schema, the description provides excellent context about the permanent nature of the operation and the soft delete alternative. It could mention what happens on success/failure or return values, but given the warnings and alternatives provided, it's largely complete.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the schema already documents all three parameters thoroughly. The description adds no additional parameter information beyond what's in the schema, meeting the baseline expectation for high schema coverage.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the specific action ('Executes a physical DELETE operation') and resource ('on table records'), distinguishing it from sibling tools like update_data. It explicitly contrasts with soft delete patterns, making the purpose unambiguous.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines5/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides explicit guidance on when to use this tool versus alternatives: it warns that the database uses soft delete patterns and recommends using update_data instead for most cases. This directly addresses sibling tool selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server