Skip to main content
Glama

delete_table_records

Destructive

Deletes one or more records from a Caspio table that match the WHERE clause. This is irreversible. WHERE is required and supports Microsoft SQL Server syntax. A broad WHERE clause will delete all matching records. To delete a single record, filter by PK_ID or another unique field. Returns the count of deleted records. IMPORTANT: field names in WHERE are case-insensitive and must come from discover_tables' field list -- never guess. Call discover_tables first for any table not already discovered earlier in this conversation to get its tableId.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
whereYesWHERE clause (required). Determines which records are deleted. Examples: 'PK_ID=42'; 'Status=N'Archived' AND CreatedDate<'2025-01-01'
tableIdYesTable Id (obtained from discover_tables, e.g. 'd99357') -- the table's name has no meaning for API calls; only the Id can be used here.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.7/5.0
Behavior5/5

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

Annotations already flag destructiveHint, but the description adds crucial behavioral context: deletion is irreversible, a broad WHERE clause deletes all matching records, single-record deletion requires a unique field filter, and the call returns the deleted count. These go well beyond the structured annotations.

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 multi-sentence but every sentence contributes essential guidance: purpose, irreversibility, WHERE semantics, single-record strategy, return count, and field-name sourcing. It is front-loaded with the core action and remains tightly organized without redundancy.

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

Completeness5/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 output schema, the description fully covers what an agent needs: required WHERE clause, broad-delete danger, irreversible nature, return value, prerequisite discover_tables call, and field-name validation. Nothing critical is left to inference.

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

Parameters4/5

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

Schema coverage is 100%, so the baseline is 3. The description adds extra meaning for the 'where' parameter: Microsoft SQL Server syntax support, case-insensitive field names, and a warning that field names must come from discover_tables. It also reinforces that tableId must be the discovered ID, not a name.

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 states a specific action ('Deletes one or more records'), a specific resource ('a Caspio table'), and a precise selection criterion ('match the WHERE clause'). It clearly differentiates from view-related siblings by scoping to tables and mentioning tableId from discover_tables.

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

Usage Guidelines4/5

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

It gives clear context: use this tool to delete table records matching a WHERE clause, call discover_tables first, and avoid guessing field names. It does not explicitly name delete_view_records as an alternative, but the table-vs-view distinction is clear enough from context.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.

Resources