Integration · Company data

Connect Claude & ChatGPT to Teable

Ask your AI questions about the data in your Teable bases and let it keep your tables up to date. It can list and search records with filters, count them, and read a record's comments and change history. It can also create tables, add fields, create records in bulk and update or delete single records.

Connect Teable free

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

Try asking

“How many open orders are in the Orders table?”
The AI finds the table, checks its fields and counts the records that match the filter.
“Show me all leads from Denmark added this month.”
It lists the records in the Leads table with a filter on country and created date.
“Add these five new customers to the Customers table.”
It checks the table's fields and creates the five records, converting values to the field types if needed.

What your AI can do

Records

List, search, filter and count records, create them in bulk, update or delete one, and read comments and change history.

Tables and fields

List and create tables, list and add fields with their types, and list a table's views.

Spaces and bases

List the spaces you can access and their bases, and search a space for bases and tables by name.

“Mark record rec123 as shipped.”
It updates only the status field on that record. The other fields stay as they are.
“Who changed the price on this product, and when?”
It reads the record's change history, optionally for just the price field or a date range.
“Create a table for event sign-ups with name, email and date fields.”
It creates the table in the base you choose, with the three fields.

19 tools for Teable

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

count_recordsCount the records in a table by `table_id`, optionally within a view or matching a `filter` or `search`.
create_fieldChanges dataAdd a field (column) to a table: `table_id`, `type` (e.g. singleLineText, number, date) and `name`, with type `options` if needed.
create_recordsChanges dataCreate records in a table (`table_id`): `records` is a list of {fields: {field name: value}}. Set `typecast` true to convert values to the field types.
create_tableChanges dataCreate a table in a base (`base_id`) with `name`, optional `description`, and optional starting `fields` and `records`.
delete_recordDeletesDelete one record by `table_id` and `record_id`.
get_baseGet one base by `base_id`.
get_current_userGet the Teable user connected to this token (name, email, ID).
get_recordGet one record by `table_id` and `record_id`.
get_record_historyGet the change history of a record by `table_id` and `record_id`, optionally for a date range or certain fields.
get_tableGet one table by `base_id` and `table_id`.
list_basesList the bases in a space by `space_id`.
list_fieldsList a table's fields (columns) by `table_id`, with names, IDs and types. Check this before reading or writing records.
list_record_commentsList the comments on a record by `table_id` and `record_id`.
list_recordsList or search records in a table by `table_id`, with optional `view_id`, `filter`, `search`, `order_by`, `projection` (fields to return) and `take` (max 1000).
list_spacesList the spaces you can access, with their IDs.
list_tablesList the tables in a base by `base_id`, with their IDs.
list_viewsList the views of a table by `table_id`.
search_spaceSearch a space (`space_id`) for bases, tables and other items by name with `search`.
update_recordChanges dataUpdate one record by `table_id` and `record_id`; `record` is {fields: {field name: new value}}. Only the fields you pass change.

Set up in three steps

1
Pick the app
Create a free PipMCP account and choose Teable from the app list.
2
Paste your key
Paste a Teable personal access token. In Teable, open Settings › Personal access tokens and click Create Token. Pick an expiry, the scopes (for example table and record read and write) and the spaces or bases it may access, then copy the token. It is shown only once.
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 Teable?

It can list spaces, bases, tables, fields and views, search a space, list, search and count records, and read record comments and history. It can create tables, fields and records, update records and delete single records.

Does the AI see my Teable token?

No. Your Teable personal access token is encrypted at rest and never shown to the AI. After you save it, it is 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 and other changes can require your approval before they run. Every tool call is logged.

Does it work with ChatGPT?

Yes. In ChatGPT, open Settings › Apps & Connectors › Advanced, turn on Developer mode and 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, and you do not need a credit card to start. Paid plans are billed per completed task. You also need your own Teable account.

Can I limit which bases the AI can reach?

Yes. When you create the personal access token in Teable, you pick its scopes and the spaces or bases it may access. Teable blocks anything outside that, on top of the tools you switch on in PipMCP.