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.

Connect Caspio free

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.

18 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_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.
delete_table_recordDeletesPermanently delete one record by `table_id` and `record_pk_id`. This cannot be undone.
get_tableGet one table's details by `table_id`.
get_table_recordGet one record from a table by `table_id` and the record's primary key `record_pk_id`.
get_viewGet one view's details by `view_id`.
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_directoriesList the user directories (app login user lists) in your account.
list_directory_usersList the users in a directory by `directory_id`, with `where`, `select` and paging.
list_filesList files in your file storage, optionally in a `folder_id`.
list_foldersList folders in your file storage, optionally inside a parent `folder_id`.
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_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.
search_filesSearch files in your file storage by `name`.
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.

Set up in three steps

1
Pick the app
Create a free PipMCP 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:
1. Click your name, then Settings › Connectors › Add custom connector.
2. Paste your link as the Remote MCP server URL.
3. 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 PipMCP 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 PipMCP Pro plan or above. PipMCP 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.