> ## Documentation Index
> Fetch the complete documentation index at: https://zite.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Manage and Query Zite databases with ChatGPT

> Use the Zite app in ChatGPT to inspect, query, analyze, and update your Zite databases.

## Overview

The Zite app for ChatGPT lets you work with your Zite workspace data from a ChatGPT conversation. After you connect your Zite account, ChatGPT can inspect your databases, query records, analyze results, run aggregations, and help create or update database structure and records.

<img src="https://mintcdn.com/zite/fy6e39QXSA3Mjwd2/help/images/mcp/zite-chatgpt-app.png?fit=max&auto=format&n=fy6e39QXSA3Mjwd2&q=85&s=4a203916148dd67fb5ef343425d681b7" alt="Zite app listing in the ChatGPT app marketplace" title="Zite app in ChatGPT" style={{ width:"100%", display:"block", border:"1px solid #E5E7EB", borderRadius:"12px" }} width="2380" height="1686" data-path="help/images/mcp/zite-chatgpt-app.png" />

<Note>
  The Zite app can only access your workspace data after you authorize it in ChatGPT. If you ask ChatGPT to change database data, review the proposed change carefully before continuing.
</Note>

## Connect the Zite app

<Steps>
  <Step title="Connect Zite in ChatGPT from the link">
    Open the [Zite app page in ChatGPT](https://chatgpt.com/apps/zite/asdk_app_6a0dfddea830819180d3eaf355793e42), then click `Start chat`.

    If you are not signed in, ChatGPT will ask you to log in before you can connect the app.
  </Step>

  <Step title="Authorize Zite">
    Follow the prompts to connect the Zite app. ChatGPT will send you to Zite to authorize access, then return you to the chat once the connection is active.
  </Step>

  <Step title="Ask a database question">
    Ask ChatGPT to find, summarize, or analyze records in your Zite databases. Include the database or table name when you know it.
  </Step>

  <Step title="Make changes when needed">
    You can ask ChatGPT to create records, update records, add fields, or make other database changes. For bulk updates or important data, ask ChatGPT to show a preview before applying the change.
  </Step>
</Steps>

## Example prompts

| Goal              | Example prompt                                                                              |
| ----------------- | ------------------------------------------------------------------------------------------- |
| Find data         | "Show the 10 most recent records in the Support tickets table where Status is Open."        |
| Summarize records | "Count deals by Stage and show the total value for each stage."                             |
| Inspect structure | "List my Zite databases and the tables in each one."                                        |
| Review fields     | "Show the fields in the Customers table, including their field types."                      |
| Create a record   | "Create a customer record for Acme Corp with status Prospect and owner Taylor."             |
| Update records    | "Find the account named Acme Corp and set Renewal status to In review."                     |
| Add a field       | "Add a single-select Priority field to the Tasks table with Low, Medium, and High options." |

## Tips for better results

* Mention the database and table names when your workspace has similar data in multiple places.
* Include filters, date ranges, or field names if you only want a specific set of records.
* Ask for a table, summary, or bullet list when you want the answer in a specific format.
* Use record IDs or unique values when updating records, especially if multiple records have similar names.
* Ask ChatGPT to preview large changes before applying them.

## Troubleshooting

<AccordionGroup>
  <Accordion title="I cannot find the Zite app in ChatGPT">
    Open the [Zite app page](https://chatgpt.com/apps/zite/asdk_app_6a0dfddea830819180d3eaf355793e42) directly, or search for `Zite` from the ChatGPT Apps page. If the app is unavailable, your ChatGPT plan or workspace settings may not allow apps.
  </Accordion>

  <Accordion title="ChatGPT cannot see a database">
    Make sure you authorized the correct Zite account and have access to the workspace, database, and tables you are asking about.
  </Accordion>

  <Accordion title="ChatGPT cannot update a record">
    Check that your Zite role allows edits to that database. If the record is hard to identify, include a unique field value or ask ChatGPT to list matching records before updating anything.
  </Accordion>
</AccordionGroup>

<Card title="Connect ChatGPT to Zite with MCP" icon="openai" href="/help/database/mcp/chatgpt">
  Learn more about the ChatGPT connection for Zite databases.
</Card>