Skip to main content
Glama

update_table_records

Updates one or more records in a Caspio table that match the WHERE clause. The payload is a flat JSON object containing only the fields to update (e.g., {'Status': 'Closed', 'ClosedDate': '2026-01-15'}). Fields not included in the payload remain unchanged. WHERE is required and supports Microsoft SQL Server syntax. Be cautious: a broad WHERE clause will update all matching records. To update a single record, filter by PK_ID or another unique field. Returns all updated records. IMPORTANT: field names 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 updated. Examples: 'PK_ID=42'; 'Status=N'Open' AND AssignedTo=N'John''
payloadYesA JSON object of field name/value pairs to update. Only include fields that should change. Example: {'Status': 'Closed', 'Notes': 'Resolved by admin'}
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.8/5.0
Behavior5/5

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

Annotations only declare readOnlyHint=false and destructiveHint=false, which is minimal. The description adds substantial behavioral context: broad WHERE clauses update all matching records (with a caution), partial updates leave omitted fields unchanged, field names are case-insensitive, and the tableId must be the ID not the name. This fully compensates for the sparse 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?

Every sentence earns its place. The description is front-loaded with the primary action, then covers payload format, WHERE behavior, caution, return, and field-name sourcing in a logical order. It is long but not verbose; no filler or repetition.

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 mutation tool with three required parameters, a nested payload, no output schema, and no annotation-provided safety details, this description is remarkably complete. It explains prerequisites (discover_tables), the source of valid field names, the risk of broad WHERE, return behavior, and the meaning of tableId. An agent has everything needed to invoke it correctly.

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

Parameters5/5

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

Schema coverage is 100%, but the description adds meaning beyond the schema: it clarifies that WHERE is required and supports MS SQL syntax, that the payload should contain only fields to update, and that tableId is the API ID, not the table name. These are critical details an agent needs to call the tool correctly, going well beyond the schema's baseline descriptions.

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 verb ('Updates'), resource ('Caspio table'), and scope ('match the WHERE clause'). It clearly distinguishes from siblings like update_view_records, insert_table_record, and delete_table_records by consistently referencing 'table' and describing update semantics. The return behavior ('Returns all updated records') adds further specificity.

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?

The description provides clear context on when to use the tool (updating table records) and gives actionable guidance: filter by PK_ID for a single record, call discover_tables first to obtain tableId, and never guess field names. It implicitly separates from view updates by focusing on tables, but it does not explicitly name alternatives or state when NOT to use this tool, so it falls short of a 5.

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