# Zoho Creator MCP > Zoho Creator MCP connects your AI agent directly into Zoho Creator's low-code ecosystem. You can manage entire business applications—from simple record updates to complex structural metadata retrieval—using natural conversation. This lets you automate data entry, build custom workflows, and interact with structured forms without ever touching the UI or writing code. ## Overview - **Category:** industry-titans - **Price:** Free - **Tags:** low-code, custom-applications, crud-operations, business-automation, app-development, database-management ## Description This MCP lets your AI agent read, write, and structure data across any application built in Zoho Creator. Instead of logging into a web portal, your agent interacts directly with the underlying database structures. You can execute full CRUD operations on records, fetch detailed metadata about forms and reports, or list every available application workspace to keep things organized. If you're building complex business logic that touches multiple systems—say, updating an inventory count, then sending an alert via messaging, and finally logging the transaction in accounting—you don't have to stop your AI agent. You can chain this Zoho Creator MCP with other services through Vinkius, letting one agent automate a complete workflow spanning dozens of platforms. It’s about treating your low-code application suite as just another set of reliable APIs you can talk to. ## Tools ### add_record Creates a brand new entry into a specific Zoho Creator form. ### delete_record Removes an existing record from the system. ### get_api_status Checks if the current connection and credentials are valid for use. ### get_form_fields Lists the specific field definitions and types used in a given form. ### get_app_metadata Retrieves structural information about an entire application, like its underlying components. ### get_record_details Fetches all information for one record when you know its unique ID. ### get_report_records Grabs a list of records based on the rules defined in a specific report. ### list_applications Retrieves a list of all applications you have access to in your Zoho Creator account. ### list_app_forms Lists all available forms within an entire application. ### list_app_reports Shows every custom report that has been built for the application. ### list_workspaces Lists the different working environments or sandboxes available across your creator accounts. ### update_record Changes specific data points for an existing record, leaving other fields untouched. ## Prompt Examples **Prompt:** ``` Retrieve the metadata and form fields for the 'Employee Directory' application so I can see what data is collected. ``` **Response:** ``` I've fetched the metadata for 'Employee Directory'. The main form 'Add_Employee' contains 6 fields: Full_Name, Email, Department, Joining_Date, Salary, and Manager_ID. Would you like me to add a new record to it? ``` **Prompt:** ``` Add a new record to the 'Inventory Manager' app under the 'Products' form with Name 'Ergonomic Chair' and Price '199.99'. ``` **Response:** ``` The record for 'Ergonomic Chair' has been successfully added to the 'Products' form in the 'Inventory Manager' application. The new record ID is 38920188492001. ``` **Prompt:** ``` Fetch the latest records from the 'Sales Tracker' report where the status is 'Pending Approval'. ``` **Response:** ``` I've retrieved the records from the 'Sales Tracker' report. There are currently 4 sales records with the status 'Pending Approval'. The highest value deal is 'Acme Corp Contract' at $45,000. ``` ## Capabilities ### Manage records Create, read, update, and delete specific data entries within any defined form or report. ### Examine application structure Retrieve the technical details of your apps, like field types and report definitions, so you know exactly what data is available to work with. ### Discover workspaces List all accessible applications and user environments to pinpoint which system holds the necessary data or form. ### Automate updates Modify existing records programmatically, even skipping internal workflow triggers when you know the update shouldn't initiate standard processes. ## Use Cases ### Tracking Inventory Changes An ops manager needs to log a received shipment. They ask the agent to `add_record` into the 'Inventory Manager' app, specifying product name and quantity. The agent handles the form mapping and ensures the data lands exactly where it needs to. ### Auditing Application Design A developer wants to see if a new field was added to an old form. They instruct the agent to use `get_app_metadata` and then `get_form_fields`, which returns the precise definition of the data structure, allowing them to verify schema integrity. ### Running Pre-Cleanup Checks Before migrating users, an IT admin needs to know how many apps exist. They ask the agent to run `list_applications` and then `list_workspaces`, giving them a complete map of every environment they need to audit. ### Refreshing Client Records A sales team needs to update key details for a client account. Instead of opening the record, they tell the agent to `update_record` with the new contact information and status flag instantly. ## Benefits - Stop clicking through forms. You can use `add_record` or `update_record` to change data directly via natural language instructions, saving hours of manual UI time. - Need to know what fields are available? Use `get_form_fields` to programmatically inspect a form's structure before writing any logic against it. No guessing required. - The whole ecosystem is visible through `list_applications` and `list_workspaces`. Your agent can tell you exactly which app or workspace holds the data you need, eliminating search time. - You don't have to rebuild reports from scratch; use `get_report_records` to pull defined datasets instantly. It’s reading structured results, not just raw data dumps. - The ability to skip workflow triggers when using `update_record` lets you perform necessary maintenance or bulk updates without accidentally kicking off alerts or processes that shouldn't run. ## How It Works The bottom line is that you talk to your AI agent using natural language, and it translates those instructions into specific API calls against your Zoho Creator environment. 1. Subscribe to this MCP and provide your Zoho Creator OAuth Access Token. 2. Specify your Account Owner name and Data Center URL within Vinkius. 3. Use any MCP-compatible client to instruct the agent, asking it to perform actions like listing apps or fetching record details. ## Frequently Asked Questions **How do I check if my credentials are correct using the Zoho Creator MCP?** You run `get_api_status`. This tool checks your connection and confirms that the provided access token is still active and authorized for use. **What's the difference between `list_app_forms` and `get_form_fields`?** First, you call `list_app_forms` to get a list of all forms in an application. Then, if you know which form you want, you use `get_form_fields` to see the detailed definition—like field names and data types—for that specific form. **Can I update a record without triggering internal workflows?** Yes. The MCP supports updating records using `update_record`, which allows you to specify that workflow triggers should be skipped, letting you perform maintenance updates safely. **Which tool do I use if I need data from a filtered list of records?** Use `get_report_records`. This function is designed to fetch records based on the criteria and filtering rules already set up within a Zoho report, giving you structured results. **If I need to inventory all available applications in my Zoho Creator environment, should I use `list_applications` first?** Yes. Using `list_applications` gives you a clean list of every accessible application and workspace title. This is the best starting point when your agent needs to know which systems exist before interacting with them. **When I need to delete data, what's the safest way to use `delete_record`?** You must provide a valid record ID for `delete_record`. The tool will confirm if the record exists and requires appropriate permissions. Always verify that you are deleting the correct item before running this command. **Beyond just seeing form details, how do I use `get_app_metadata` to understand an application's full architecture?** `get_app_metadata` pulls together all structural definitions for an app. It shows you not only the forms but also related report and field type definitions, giving a complete blueprint of the low-code structure. **Before I try to fetch data from reports, should I use `list_app_reports` to see what's available?** Absolutely. Running `list_app_reports` shows you all the names of the report types within an application. This is a necessary pre-step because you need the exact report name before using tools like fetching records. **How do I find my Zoho Creator Account Owner name?** The owner name is typically your Zoho username or company ID. You can find it in the URL when accessing your Creator app: `zoho.com/creator/owner_name/...` **Which Data Center (DC) URL should I use?** Use the URL corresponding to your account region: `https://creator.zoho.com` (US), `https://creator.zoho.eu` (EU), `https://creator.zoho.in` (IN), etc.