Integration · Company data
Connect Claude & ChatGPT to Caspio
Ask your AI to find records in a Caspio table, add a new row or update a field. It can list your tables, views and their fields, filter records, browse your file storage and see the users in your app directories. Questions about your Caspio data get answered without building a report first.
Free plan, no credit card. Takes about a minute.
Try asking
“Which tables do I have in Caspio?”
The AI lists the data tables in your account with their IDs.
“Show all records in Orders where Status is Active.”
It checks the table's fields, then lists matching records using a filter on the Status field.
“Add a new contact: Jane Doe, [email protected].”
It reads the table's fields and adds a record with those values.
What your AI can do
Tables and records
List tables and fields, filter, read, add and update records, and delete a record if you switch that on.
Views
Read saved views, their filtered or joined records and single records.
Files, apps and directories
Browse folders and files, search files by name, and list apps, directories and directory users.
“Change record 142 in Projects to status Done.”
It updates only the Status field on that record and leaves the rest as it is.
“Who is in the Customer Portal user directory?”
It lists the users in that directory.
“Find the file called contract-2025.pdf.”
It searches your Caspio file storage by name and shows where the file is.
98 tools for Caspio
These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.
create_directory_fieldChanges dataCreate a new field for a directory. Required: name or data type. Search fields first to avoid duplicates. API summary: Creates a directory field.create_directory_userChanges dataCreate a new user for a directory. Required: body. API summary: Creates a directory user.create_documentVisible to othersCreate a new document. Search documents first to avoid duplicates. Has effects visible outside this system. API summary: Uploads files to multiple table records or attachment fields.create_document_bulk_upload_files_to_attachment_view_fieldsVisible to othersCreate a new document. Search documents first to avoid duplicates. Has effects visible outside this system. API summary: Uploads files to multiple view records or attachment fields.create_document_create_folderChanges dataCreate a new document. Required: name. Search documents first to avoid duplicates. API summary: Creates a folder.create_outgoing_webhookDeletesCreate a new outgoing webhook. Destructive action; may require approval. API summary: Creates an outgoing webhook.create_outgoing_webhook_eventDeletesCreate a new event for a outgoing webhook. Required: type or object id. Destructive action; may require approval. API summary: Creates an event for an outgoing webhook.create_tableChanges dataCreate a new table. API summary: Creates a table.create_table_fieldChanges dataCreate a new field for a table. Required: name or data type. Search fields first to avoid duplicates. API summary: Creates a table field.create_table_recordChanges dataAdd a record to a table by `table_id`, with the field values in `body` as field name to value. Set `echo` to true to get the created record back.create_task_runChanges dataCreate a new run for a task. API summary: Runs a data import/export task.create_userVisible to othersCreate a new user. Required: items. Has effects visible outside this system. API summary: Creates multiple table records.create_user_bulk_create_usersVisible to othersCreate a new user. Required: items. Has effects visible outside this system. API summary: Creates multiple directory users.create_user_bulk_create_view_recordsVisible to othersCreate a new user. Required: items. Has effects visible outside this system. API summary: Creates multiple view records.create_view_recordChanges dataCreate a new record for a view. Required: body. API summary: Creates a view record.delete_directory_fieldDeletesPermanently delete a field by field name. Destructive action; may require approval. API summary: Deletes a directory field.delete_directory_userDeletesPermanently delete a user by user id. Destructive action; may require approval. API summary: Deletes a directory user by UserGUID.delete_documentMoves moneyPermanently delete a document by field name. Financial or irreversible action; may require approval. API summary: Deletes table attachment files that match a condition.delete_document_delete_file_by_keyDeletesPermanently delete a document by document id. Destructive action; may require approval. API summary: Deletes a file by file ID.delete_document_delete_file_from_attachment_view_fieldsMoves moneyPermanently delete a document by field name. Financial or irreversible action; may require approval. API summary: Deletes view attachment files that match a condition.delete_outgoing_webhookDeletesPermanently delete a outgoing webhook by webhook id. Destructive action; may require approval. API summary: Deletes an outgoing webhook and its events.delete_outgoing_webhook_eventDeletesPermanently delete a event by event id. Destructive action; may require approval. API summary: Deletes a webhook event.delete_password_fieldMoves moneyPermanently delete a password field by field name. Financial or irreversible action; may require approval. API summary: Resets a table password-field value.delete_pathsMoves moneyPermanently delete a path. Financial or irreversible action; may require approval. API summary: Deletes a file by file path.delete_record_documentDeletesPermanently delete a document by field name. Destructive action; may require approval. API summary: Deletes a table attachment file.delete_record_document_delete_file_from_attachment_view_fieldDeletesPermanently delete a document by field name. Destructive action; may require approval. API summary: Deletes a view attachment file.delete_table_fieldDeletesPermanently delete a field by field name. Destructive action; may require approval. API summary: Deletes a table field.delete_table_recordDeletesPermanently delete one record by `table_id` and `record_pk_id`. This cannot be undone.delete_user_documentDeletesPermanently delete a document by field name. Destructive action; may require approval. API summary: Deletes a directory-user attachment file.delete_usersMoves moneyPermanently delete a user by table id. Financial or irreversible action; may require approval. API summary: Deletes table records that match a condition.delete_users_bulk_delete_view_recordsMoves moneyPermanently delete a user by view id. Financial or irreversible action; may require approval. API summary: Deletes view records that match a condition.delete_users_delete_usersMoves moneyPermanently delete a user by directory id. Financial or irreversible action; may require approval. API summary: Deletes directory users that match a condition.delete_view_recordDeletesPermanently delete a record by record pk id. Destructive action; may require approval. API summary: Deletes a view record by PKID.download_documentDownload the document for a document. API summary: Downloads a table attachment file.download_document_download_directory_user_attachmentDownload the document for a document. API summary: Downloads a directory-user attachment file.download_document_download_file_by_keyDownload the document for a document. API summary: Downloads a file by file ID.download_document_download_file_from_attachment_view_fieldDownload the document for a document. API summary: Downloads a view attachment file.download_pathDownload the document for a path. API summary: Downloads a file by file path.get_bridge_applicationGet one bridge application by app id. API summary: Gets a Bridge application.get_bridge_application_pageGet one page for a bridge application by app key. API summary: Gets a DataPage.get_directoryGet one directory by directory id. API summary: Gets a directory.get_directory_fieldGet one field for a directory by field name. API summary: Gets a directory field.get_documentGet one document by document id. API summary: Gets folder metadata.get_flex_applicationGet one flex application by app id. API summary: Gets a Flex application.get_outgoing_webhookGet one outgoing webhook by webhook id. API summary: Gets an outgoing webhook.get_outgoing_webhook_eventGet one event for a outgoing webhook by event id. API summary: Gets a webhook event.get_tableGet one table's details by `table_id`.get_table_fieldGet one field for a table by field name. API summary: Gets a table field.get_table_recordGet one record from a table by `table_id` and the record's primary key `record_pk_id`.get_taskGet one task by task id. API summary: Get a task.get_task_get_data_import_export_taskGet one task by task id. API summary: Gets a data import/export task.get_viewGet one view's details by `view_id`.get_view_fieldGet one field for a view by field name. API summary: Gets a view field.get_view_recordGet one record from a view by `view_id` and `record_pk_id`.list_appsList your Caspio apps (Bridge applications), optionally filtered by name.list_data_page_pagesList pages for a data page. Optional filters: method. API summary: Gets the deployment code for a DataPage.list_directoriesList the user directories (app login user lists) in your account.list_directories_2List directories. Optional filters: directory name, directory id, sort field, sort descending, include triggered actions or bridge app id. Results are paginated. API summary: Lists all accessible directories with their field definitions.list_directory_usersList the users in a directory by `directory_id`, with `where`, `select` and paging.list_document_file_infosList file infos for a document. Optional filters: where. API summary: Gets attachment file metadata for multiple table records.list_document_file_infos_get_directory_user_attachment_metadataList file infos for a document. Optional filters: where. API summary: Gets attachment file metadata for multiple directory users.list_document_file_infos_get_file_metadata_from_attachment_view_List file infos for a document. Optional filters: where. API summary: Gets attachment file metadata for multiple view records.list_documents_get_file_metadata_by_keyList documents for a document. API summary: Gets file metadata by file ID.list_documents_get_file_metadata_by_pathList documents. Optional filters: file path. API summary: Gets file metadata by file path.list_filesList files in your file storage, optionally in a `folder_id`.list_flex_applicationsList flex applications. Optional filters: app name, app id, sort field or sort descending. Results are paginated. API summary: Lists Flex applications.list_foldersList folders in your file storage, optionally inside a parent `folder_id`.list_outgoing_webhook_eventsList events for a outgoing webhook. Optional filters: event type, object id or sort descending. Results are paginated. API summary: Lists events for an outgoing webhook.list_outgoing_webhooksList outgoing webhooks. Optional filters: webhook name, status, webhook id, sort field or sort descending. Results are paginated. API summary: Lists all accessible outgoing webhooks with their event definitions.list_outgoing_webhooks_list_outgoing_webhooksList outgoing webhooks. Optional filters: webhook name, status, webhook id, sort field or sort descending. Results are paginated. API summary: Lists outgoing webhooks.list_table_fieldsList the fields (columns) of a table by `table_id`, with their names and data types. Check this before reading or writing records.list_table_recordsList records in a table by `table_id`. Filter with `where` (SQL Server syntax, e.g. Status=N'Active'), choose columns with `select`, sort with `order_by`, and page with `page` and `limit`.list_tablesList the data tables in your Caspio account, optionally filtered by table name. Use to find a table's ID.list_tables_2List tables. Optional filters: table name, table id, sort field, sort descending, include triggered actions or bridge app id. Results are paginated. API summary: Lists all accessible tables with their field definitions.list_tasksList tasks. Optional filters: task name, task id, sort field, sort descending, bridge app id or flex app id. Results are paginated.list_tasks_list_data_import_export_tasksList tasks. Optional filters: task name, task id, sort field or sort descending. Results are paginated. API summary: Lists data import/export tasks.list_view_recordsList records in a view by `view_id`, with `where`, `select`, `order_by`, `page` and `limit` like list_table_records.list_viewsList the saved views (filtered or joined tables) in your account, optionally filtered by name.list_views_2List views. Optional filters: view name, view id, sort field, sort descending, bridge app id or flex app id. Results are paginated. API summary: Lists all accessible views with their field definitions.search_bridge_application_pagesSearch pages for a bridge application by name, sort field or sort descending. Use this to find existing pages before creating a new page. Results are paginated. API summary: Lists DataPages in a Bridge application.search_directory_fieldsSearch fields for a directory by type, name, sort field or sort descending. Use this to find existing fields before creating a new field. Results are paginated. API summary: Lists directory fields.search_documents_searchSearch documents by name, sort field or sort descending. Use this to find existing documents before creating a new document. Results are paginated. API summary: Searches folders by name.search_filesSearch files in your file storage by `name`.search_view_fieldsSearch fields for a view by type, name, sort field or sort descending. Use this to find existing fields before creating a new field. Results are paginated. API summary: Lists view fields.submit_userVisible to othersActivate a user (user id). Has effects visible outside this system. API summary: Activates a directory user.update_data_page_pagesVisible to othersUpdate an existing page identified by app key. Has effects visible outside this system. API summary: Deploys or undeploys a DataPage.update_directory_fieldChanges dataUpdate an existing field identified by field name. Only the fields you pass are changed. API summary: Updates a directory field.update_directory_userChanges dataUpdate an existing user identified by user id. Only the fields you pass are changed. API summary: Updates a directory user by UserGUID.update_document_file_infosVisible to othersUpdate an existing file info identified by field name. Only the fields you pass are changed. Has effects visible outside this system. API summary: Renames table attachment files that match a condition.update_outgoing_webhookDeletesUpdate an existing outgoing webhook identified by webhook id. Only the fields you pass are changed. Destructive action; may require approval. API summary: Updates an outgoing webhook.update_outgoing_webhook_eventDeletesUpdate an existing event identified by event id. Only the fields you pass are changed. Destructive action; may require approval. API summary: Updates a webhook event.update_outgoing_webhook_regenerate_secretsMoves moneyUpdate an existing regenerate secret identified by webhook id. Only the fields you pass are changed. Financial or irreversible action; may require approval. API summary: Regenerates a webhook secret.update_pagesVisible to othersUpdate an existing page identified by app id. Has effects visible outside this system. API summary: Deploys or undeploys all DataPages in a Bridge application.update_password_fieldMoves moneyUpdate an existing password field identified by field name. Only the fields you pass are changed. Financial or irreversible action; may require approval. API summary: Updates a table password-field value.update_table_fieldChanges dataUpdate an existing field identified by field name. Only the fields you pass are changed. API summary: Updates a table field.update_table_recordChanges dataUpdate one record by `table_id` and `record_pk_id`, with the changed field values in `body`. Only the fields you pass change.update_usersVisible to othersUpdate an existing user identified by table id. Only the fields you pass are changed. Has effects visible outside this system. API summary: Updates table records that match a condition.update_view_recordChanges dataUpdate an existing record identified by record pk id. Only the fields you pass are changed. API summary: Updates a view record by PKID.
Set up in three steps
- 1
Pick the app
Create a free HeyMyApps account and choose Caspio from the app list.
- 2
Paste your key
Enter your Caspio account ID (the "c1abc123" in your Integration URL https://c1abc123.caspio.com), plus the Client ID and Client secret. In Caspio go to Integrations › API profiles › Create API profile, copy the credentials from the Credentials tab, and tick the permissions the profile may use on the Permissions tab.
- 3
Add the link to your AI
You get a personal MCP link. Add it to Claude, ChatGPT or Cursor:
- Click your name, then Settings › Connectors › Add custom connector.
- Paste your link as the Remote MCP server URL.
- Switch it on from the + menu in a chat.
Questions
What can the AI do in Caspio?
The AI can list tables, views, fields, apps, directories, directory users, folders and files, and read records from tables and views. It can add and update table records, and permanently delete a record if you switch that tool on.
Does the AI see my Caspio client secret?
No. Your Caspio credentials are encrypted at rest and never shown to the AI. After you save them, they are not shown again, not even to you. The AI only sees the results of the tools it calls.
Can I control what the AI is allowed to do?
Yes. You choose which tools are switched on, so you can start read-only. Deleting a record is permanent and can require your approval before it runs. The permissions you tick on the Caspio API profile also limit what the connection can reach. Every tool call is logged.
Does it work with ChatGPT?
Yes. In ChatGPT go to Settings › Apps & Connectors › Advanced and turn on Developer mode, then add your HeyMyApps link. Developer mode needs a paid ChatGPT plan: Plus, Pro, Business or Enterprise. The same link also works in Claude (Settings › Connectors › Add custom connector), Cursor and other MCP clients.
What does it cost?
Caspio connects with OAuth, and OAuth connections need the HeyMyApps Pro plan or above. HeyMyApps also has a free plan with no credit card, but it does not include this connection. Paid plans bill per completed task. You also need your own Caspio account.
How does the AI filter records?
Record lists take a where filter in SQL Server syntax, for example Status=N'Active', plus the columns to return, the sort order and paging. The AI checks a table's field names first so its filters match your data.
Related integrations
Let your AI work in Caspio today.
Start free. Your key stays encrypted, and you decide what the AI may do.
Connect Caspio freeHeyMyApps is not affiliated with Caspio. Product names are trademarks of their owners.






