Skip to main content
Glama

create_report

Створити звіт (фільтр/view) для форми. Підтримує умови фільтрації, групування, суму/середнє по групі, видимі колонки, сортування. Для дат: yesterday, today, last_7_days, last_30_days, this_month, this_week, between (+ from/to), before, after тощо.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
ascNotrue=за зростанням (default), false=за спаданням. Застосовується до sort_by.
nameYesНазва звіту
orderNoasc або desc — напрям сортування ГРУП (лише коли задано group_field_ids). Це НЕ поле для сортування — для цього використовуй sort_by.
app_idYesProject ID (from list_projects)
sort_byNoID або назва поля для сортування записів (використовується разом з asc).
per_pageNoЗаписів на сторінку (default 10)
criteriasNoУмови фільтрації. Для дат: yesterday, today, last_7_days, last_30_days, this_week, this_month, next_7_days, between (+ from/to), before, after. Для текстів: is, is_not, contains, not_contains, starts_with, ends_with, is_empty, is_not_empty. Для чисел: is, is_not, less_than, greater_than, between.
entity_idYesForm ID (from list_forms or describe_project)
no_data_textNoТекст, який побачить власник, коли під фільтри звіту не підпадає ЖОДЕН запис. ⚠️ Пиши його ЗАВЖДИ для звітів із фільтром — у новому проєкті записів ще нема, тож першим цей звіт покажуть саме порожнім. Мовою користувача і про ЙОГО бізнес: «Сьогодні візитів ще немає — вони зʼявляться тут, щойно клієнт запишеться», а не «немає даних».
property_idsNoID або назви полів що відображаються (пусто = всі)
total_by_groupNo1 = показати суму числового поля по кожній групі. Обов'язково вказати total_by_group_column_id.
group_field_idsNoID полів для групування (GROUP BY). Наприклад, групувати по статусу.
average_by_groupNo1 = показати середнє числового поля по кожній групі. Обов'язково вказати average_by_group_column_id.
only_groupname_and_countNo1 = показати лише назву групи та кількість записів (без деталей)
total_by_group_column_idNoID або назва числового поля для підрахунку суми по групі.
average_by_group_column_idNoID або назва числового поля для підрахунку середнього по групі.

TDQS

B3.4/5.0
Behavior2/5

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

The annotations provide limited safety information (all hints false), so the description must carry the burden of behavioral disclosure. It does state 'Create', implying a mutation, but it does not explain side effects, permission requirements, the report's visibility, or whether it can overwrite existing reports. No additional behavioral context is provided beyond the basic create action.

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 concise, consisting of two sentences: the first clearly states the purpose, and the second lists capabilities and date filter examples. It is front-loaded with the main action and avoids unnecessary filler. The second sentence is a slightly dense enumeration ending with 'etc.', but it remains efficient and to the point.

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

Completeness3/5

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

With 16 parameters and no output schema, the description provides only a high-level feature overview and does not explain parameter interrelationships (e.g., total_by_group requiring total_by_group_column_id) or prerequisites beyond what the schema already provides. The schema is detailed, but the description alone is not fully sufficient for an agent to understand the tool's full context, though it is adequate when combined with the schema.

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% with thorough descriptions for all 16 parameters, including detailed guidance for criterias and no_data_text. The tool description adds only a high-level mention of date filters and grouping, which is already fully covered in the schema. Per the baseline rule, a score of 3 is appropriate when the schema carries the parameter semantics.

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 action 'Create' and the resource 'report (filter/view) for the form', with a specific verb+resource pair. It further distinguishes itself from siblings like create_chart and create_saved_view by enumerating unique capabilities: filtering, grouping, sum/average by group, visible columns, and sorting. This makes the tool's purpose unambiguous and well-differentiated.

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

Usage Guidelines3/5

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

The description implicitly indicates when to use the tool ('for a form' and supporting grouping/summaries), but it does not explicitly state when to use it over alternatives like create_saved_view or create_chart, nor does it provide exclusions or preconditions such as requiring an existing form. This is implied usage rather than explicit guidance.

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.

TDQS

B3.2/5.0
Disambiguation5/5

Each tool clearly targets a specific resource and action (e.g., create_form vs. delete_form, add_dashboard_item vs. create_calendar). Overlapping functions like delete_few_records and delete_records_by_filter are distinguished by scope. The descriptions provide sufficient detail to avoid confusion.

Naming Consistency4/5

Most tools follow a verb_noun pattern (create_, delete_, update_, list_, get_). Minor inconsistencies exist (add_ vs create_, set_ for permissions, check_ for status). Overall predictable and readable.

Tool Count3/5

118 tools is unusually large for an MCP server, but each tool addresses a distinct entity or operation within a comprehensive database platform. The count is borderline heavy; while justified by the domain, it may overwhelm agents.

Completeness5/5

The toolset covers creation, retrieval, updating, deletion, and management for all major entities (projects, forms, fields, records, portals, groups, reports, charts, maps, templates, schedules, etc.). Gaps are minimal (e.g., no duplicate_project), and critical workflows like bulk operations and AI site generation are included.

Resources