Integration · Company data

Connect Claude & ChatGPT to Zite

Ask your AI how many leads came in this month, to find a record, or to add a new row to a table. It reads your Zite databases, schemas, tables and records, runs read-only SQL queries and computes counts, sums and averages. It can also create, update and delete records and add tables and fields.

Connect Zite free

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

Try asking

“How many leads did we get per source this month?”
The AI reads the schema, then counts records grouped by the source field with a date filter.
“Show all open support requests assigned to Maria.”
It lists records in the table with a filter on status and assignee.
“Which ten orders were the biggest this year?”
It gets the schema for table and column names, then runs a read-only SQL query.

What your AI can do

Records

List, filter, sort, create, update and delete records in any table.

Queries and totals

Run read-only SQL queries and compute a count, sum, average, min or max, optionally grouped.

Tables and fields

Read database schemas, create and rename tables, and add or change fields.

“Add a new supplier: Nordic Parts, contact [email protected].”
It creates a record in the suppliers table with the values you gave.
“Add a Priority field to the Tasks table.”
It adds a new field with a name and type to the table.
“Delete the duplicate record for Acme.”
It finds both records and deletes the one you confirm. Deleting is permanent.

15 tools for Zite

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

aggregate_recordsChanges dataCompute a count, sum, average, min or max (`operation`) over a field (`field_id`) in a table, with optional filter and group_by.
create_fieldChanges dataAdd a field (column) to a table with `name` and `type`.
create_recordChanges dataCreate a record in a table: `record` is an object of field names (or IDs) to values.
create_tableChanges dataCreate a table in a database with a `name` and its `fields` (name and type).
delete_recordDeletesPermanently delete one record by `record_id`. This cannot be undone.
get_databaseGet one database by `database_id`, with its tables.
get_database_schemaGet the schema of a database by `database_id`: tables and, with include_fields, their fields. Use before writing records or SQL.
get_recordGet one record by `database_id`, `table_id` and `record_id`.
list_databasesList your Zite databases with their IDs and names.
list_recordsChanges dataList records in a table by `database_id` and `table_id`, with optional filter, sort, limit and offset.
list_table_fieldsList the fields (columns) of a table by `database_id` and `table_id`.
rename_tableChanges dataRename a table by `table_id` with a new `name`.
run_sql_queryChanges dataRun a read-only SQL query (`sql`, optional params) against a database. Get the schema first for table and column names.
update_fieldChanges dataRename or reconfigure a field by `field_id`.
update_recordChanges dataUpdate a record by `record_id`: `record` holds only the fields to change.

Set up in three steps

1
Pick the app
Create a free PipMCP account and choose Zite from the app list.
2
Paste your key
Paste a Zite API key. In Zite open Settings > Developer (app.zite.com/home/settings/developer), generate an API key and copy it. Database and table IDs are in the URL when you open a database: app.zite.com/database/{databaseId}/{tableId}.
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 Zite?

The AI can list databases, read schemas, tables, fields and records, run read-only SQL and compute counts, sums, averages, minimums and maximums. It can create, update and delete records, create and rename tables, and add or change fields.

Does the AI see my Zite API key?

No. Your Zite 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 changing fields changes your table structure. These tools can require your approval before they run. 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 Zite account.

Can the AI change my data with SQL?

No. The SQL tool is read-only. Changes go through the record tools (create, update and delete) and the table and field tools, which you can switch on or off one by one.