Formbyte

CRITICAL FIRST STEP for any data analysis task. Returns the database table name, column definitions, and field types for a specific form. ⚠️ MANDATORY USAGE RULE: You MUST call this tool BEFORE calling `query_form_data`. You cannot write correct SQL without knowing the exact table name (e.g., "form_submissions_f_xyz") and column names (e.g., "item_satisfaction"). Returns: - Table name - Column list (mappings between Item ID and Database Column Name) - Data types

get-form-schema

Change the theme of a form with a specific formId.

change-form-theme

Execute multiple SQL queries to retrieve form submission data. Supports SELECT statements and aggregate functions (COUNT, AVG, SUM, etc.) for statistical analysis. Usage: Call this tool when user wants to query form submission data or perform statistical analysis. Supports executing multiple queries in a single call for comprehensive analysis. Important notes: 1. Must call get_form_schema first to get table structure before calling this tool 2. Only SELECT queries are supported, UPDATE, DELETE, etc. are not allowed 3. Table name format: form_submissions_{formId} 4. Column name format: item_{itemId} 5. System columns: id (record ID), submitted_at (submission timestamp) Data volume limits: - Each query returns maximum 100 records by default - If isComplete=false in any result, that query's data is incomplete; recommend using aggregate queries instead of raw row queries SQL construction recommendations: - Count total: SELECT COUNT(*) as total FROM form_submissions_{formId} - Group statistics: SELECT item_xxx, COUNT(*) as count FROM ... GROUP BY item_xxx - Time trends: SELECT DATE(submitted_at) as date, COUNT(*) FROM ... GROUP BY date - Conditional filtering: SELECT * FROM ... WHERE item_xxx = 'value' LIMIT 100

query-form-data

Display one bounded page of submitted answers for a selected form when the user explicitly requests those answers. Requires a connected Formbyte account and access to the selected form. Returns question labels and answer statistics for this page; the UI receives the selected answers and their submission times to display the table and recent-submission metrics. Defaults to 25 responses, with at most 100 per call. Statistics describe the returned page, not the complete form. Optional fieldIds limits the displayed questions. Does not modify the form, publish it, retrieve account profiles, or request extra respondent information. Do not use it merely to open a form or get a submission count.

get-form-responses

Get the download url for form responses. ⚠️ MANDATORY USAGE RULE: You MUST call this tool BEFORE getting the download url. You cannot get the download url without knowing the exact formId.

get-form-response-download-url

List forms created by the user with support for search, filtering, and sorting. Usage: - Call when user requests to view form list - Call when user searches for specific forms (with query parameter) - Call when user wants to see recently created/updated forms (set sortBy) Default behavior: Sort by update time in descending order (most recently updated first).

list-forms

Create a draft form from the user's requested questions, edit items in a selected form, or open that form in the editor. Requires a connected Formbyte account; access is limited to that account's forms. Creates persist a new form; updates may overwrite or delete existing questions, including on published forms. This tool does not publish a form or retrieve submitted answers. Include only task-relevant questions; do not request passwords, authentication secrets, payment card details, government identifiers or protected health information. Do not add contact or demographic questions unless needed for the user's stated purpose. Welcome and end screens are not counted when referring to question numbers.

manage-form

Share a form with a specific formId. ⚠️ MANDATORY USAGE RULE: You MUST call this tool BEFORE sharing the form. You cannot share the form without knowing the exact formId.

share-form