Skip to main content
Glama

discover_tables

Read-only

Discovers tables in the Caspio account along with their field schemas in a single call. Tables are the primary data storage objects in Caspio (similar to database tables); table names are customer-defined and reflect their specific use case (e.g., Patients, ParkingPermits, Inventory_Items). Returns each matching table's id (required by query_table, insert_table_record, update_table_records, delete_table_records, and get_attachment_metadata), name, and field definitions. Each field includes: name (the identifier used in all queries), dataType, label (optional friendly display name), unique, editable (false for auto-generated fields like Autonumber, Timestamp, GUID, Random ID, and Formula -- do not include these in insert or update payloads), and description. Caspio API data types: STRING (short text, max 255 chars), TEXT (long text, max 64K chars), NUMBER (decimal), INTEGER (whole number), CURRENCY, DATE/TIME, YES/NO (boolean -- use 1 for true and 0 for false in queries), FILE (legacy, referenced separate file object), ATTACHMENT, LIST-STRING / LIST-NUMBER / LIST-DATE/TIME, PASSWORD, TIMESTAMP, RANDOM ID, AUTONUMBER, PREFIXED AUTONUMBER, GUID. Use field name (never label) in SELECT, WHERE, ORDER BY, and GROUP BY clauses. Use nameFilter to search for a specific table, or omit it to list all tables.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
pageSizeNoNumber of results per page (default = 25)
nameFilterNoFilter tables by name (case-insensitive, partial match). Omit to list all tables.
pageNumberNoPage number (default = 1)
includeTriggeredActionsNoInclude each table's triggered-action definitions in the response (default = false). Set to true to include this extra data when needed.

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A4.3/5.0
Behavior5/5

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

Annotations already mark the call read-only, open-world, and non-destructive, and the description adds substantial behavior: it discloses that auto-generated fields are not editable and should be excluded from insert/update payloads, explains Caspio data types, and warns to use field names rather than labels in queries. This is exactly the contextual behavior an agent needs and goes well beyond the annotation hints.

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 long but front-loaded, with the core purpose in the first sentence and supporting detail organized by schema fields, data types, and query usage. The full data-type enumeration is justified because it directly affects how an agent will interpret fields, though the length keeps it from being maximally concise.

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?

With no output schema, the description takes on the burden of describing return values and does so well: it lists the returned id/name/field definitions, per-field attributes, and data-type semantics. It does not spell out the pagination response shape, but pageSize/pageNumber are already self-described in the schema, so the remaining gap is minor.

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?

The input schema already documents all four parameters with full descriptions and defaults, so the baseline is 3. The description only restates nameFilter behavior ('Use nameFilter to search for a specific table, or omit it to list all tables') and does not add new parameter-specific meaning; the bulk of its added value is about result-field semantics, not the parameters.

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 opens with a specific verb and resource: 'Discovers tables in the Caspio account along with their field schemas in a single call.' It further distinguishes the resource from sibling tools by calling tables 'the primary data storage objects in Caspio' and enumerating the returned schema, so an agent can recognize it as the table-discovery tool rather than discover_views or discover_directories.

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 provides clear usage context by explaining that the returned id is required by query_table, insert_table_record, update_table_records, delete_table_records, and get_attachment_metadata, and by closing with instructions to use nameFilter or omit it to list all tables. It does not explicitly name sibling discovery tools or give when-not-to-use conditions, so it falls just 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