Skip to main content
Glama

insert_table_record

Inserts a single record into a Caspio table. The payload is a flat JSON object of field name/value pairs (e.g., {'Name': 'John', 'Age': 30}). Only include editable fields -- do not include auto-generated fields (Autonumber, Timestamp, Random ID, GUID, Prefixed Autonumber, Formula, or PK_ID). Returns the full created record including PK_ID (a system-generated unique identifier present on every Caspio table record). 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 and confirm which fields exist and which are editable.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
payloadYesA JSON object of field name/value pairs for the new record. Keys are field names, values are the data to insert. Example: {'LibraryName': 'Main Library', 'City': 'Portland', 'State': 'Oregon'}
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
Behavior4/5

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

Annotations already declare readOnlyHint=false and destructiveHint=false, so the description adds value by explaining the return payload (full created record including PK_ID) and the constraint that auto-generated fields must be excluded. It does not cover error cases or idempotency, but the key behavioral traits are disclosed beyond annotations.

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

Conciseness4/5

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

The description is moderately long, but every sentence serves a purpose: the first sentence states the action, the second gives the example and format, the third lists exclusions, and the fourth covers case-insensitivity and the discover_tables prerequisite. It is front-loaded and free of filler, though slightly verbose.

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 tool with two parameters, no output schema, and a write operation, this description is complete. It covers the payload format, required field sourcing, editable-field restrictions, return value, and the critical dependency on discover_tables. An agent has everything needed to call it correctly without guessing.

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%, yet the description still adds substantial meaning: it clarifies payload is a flat JSON object, provides an example, states field names are case-insensitive, mandates the source of field names (discover_tables), and specifies which fields must not be included. This goes far beyond the schema's property 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?

States a specific verb ('inserts') and resource ('a record into a Caspio table'), and explicitly contrasts with view insertion by naming the target as a 'table'. This clearly distinguishes it from insert_view_record and update/delete siblings without needing to open schemas.

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?

Gives explicit when-to-use guidance: call discover_tables first for any undiscovered table, and never guess field names. It also details constraints (only editable fields, exclude auto-generated) and explains the tableId parameter must come from discover_tables. This is actionable and prevents common mistakes.

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