Integration · Company data

Connect Claude & ChatGPT to Quickbase

Ask your AI to find records in a Quickbase table, run a saved report, or add a new record. It can list the tables and fields in an app, query records with Quickbase filters, add or update records, see what changed since a given time, and download file attachments. You get answers from your Quickbase apps without building a new report first.

Connect Quickbase free

Free plan, no credit card. Takes about a minute.

Try asking

“Which projects in the Projects table are still open?”
The AI looks up the table's fields, then queries the records with a filter on the status field and returns the matches.
“Run the Overdue tasks report.”
It finds the report among the table's saved reports and runs it, returning its records.
“Add a customer record for Acme Ltd with Sara Jensen as contact.”
It checks the field IDs for the table and adds a new record with those values.

What your AI can do

Apps, tables and fields

Read app details, list tables, fields and relationships, and look up a field's type and choice values.

Records

Query records with Quickbase filters, sorting and paging, add or update records, and list records changed since a given time.

Reports and files

List, read and run saved reports, and download file attachments from records.

“Set the status of record 214 to Done.”
It updates the existing record by its record ID instead of adding a new one.
“What changed in the Orders table since Monday?”
It lists the records in the table that changed after that time.
“How are the tables in this app connected?”
It lists the tables in the app and the parent and child relationships of each table.

13 tools for Quickbase

These tools are switched on when you connect. You can switch any of them off, or require your approval before it runs.

download_file_attachmentDownload a file attachment from a record, identified by `table_id`, `record_id`, the file field's `field_id` and `version_number`.
get_appGet one Quickbase app's details by `app_id` (the ID after /db/ in the app's address), such as name, description and date format.
get_fieldGet one field's properties by `field_id` and `table_id`, such as label, type and choice values.
get_reportGet a saved report's definition (columns, filter, sorting) by `report_id` and `table_id`.
get_tableGet one table's details (name, record names, key field) by `table_id` and `app_id`.
list_changed_recordsChanges dataList records in table `from` that changed after the timestamp `after`, optionally limited to a `field_list` of field IDs.
list_fieldsList the fields (columns) of a table by `table_id`, with each field's numeric ID, label and type. Use the field IDs when querying or writing records.
list_reportsList the saved reports of a table by `table_id`. Use to find a report's ID.
list_table_relationshipsList the relationships (parent/child links) of a table by `table_id`.
list_tablesList the tables in an app by `app_id`. Use to find a table's ID before working with its records.
query_recordsChanges dataQuery records from a table: `from` is the table ID, `select` the field IDs to return, `where` a Quickbase query string such as {6.EX.'Acme'}, plus optional `sort_by`, `group_by` and `options` (top, skip) for paging.
run_reportChanges dataRun a saved report by `report_id` and `table_id` and return its records.
upsert_recordsChanges dataAdd or update records in table `to`: `data` is a list of records keyed by field ID, e.g. {"6": {"value": "Acme"}}. Include the record ID field (or set `merge_field_id`) to update existing records instead of adding new ones.

Set up in three steps

1
Pick the app
Create a free PipMCP account and choose Quickbase from the app list.
2
Paste your key
Paste a Quickbase user token and enter your Quickbase domain, for example acme.quickbase.com. In Quickbase, open the user menu on the global bar > Profile > Manage my user tokens, click New user token, give it a name, assign it to the apps it may use and save. Then copy the token.
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 Quickbase?

It can read app details, tables, fields, relationships, records and saved reports, run reports, list records changed since a given time and download file attachments. It can also add new records and update existing ones.

Does the AI see my Quickbase user token?

No. Your Quickbase 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 by leaving upsert_records off. Adding and updating records can require your approval before it runs. 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?

PipMCP has a free plan with no credit card required. Paid plans bill per completed task. You also need your own Quickbase account.

Which Quickbase apps can the AI reach?

Only the apps you assign to the user token when you create it in Quickbase. You can change that later under Manage my user tokens. On top of that, the AI can only use the tools you switch on in PipMCP.