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

# Database Agent

> Use the AI agent in Zite Database to create tables, ask questions, analyze records, update fields, and connect integrations.

The Database Agent is an AI helper built into the Zite Database editor. Use it to create and organize your database, ask questions about your records, analyze trends, update fields, and connect integrations without leaving your table.

<Frame>
  <img src="https://mintcdn.com/zite/VCjUW6SL4ZZ5LeYX/images/database-Agent.webp?fit=max&auto=format&n=VCjUW6SL4ZZ5LeYX&q=85&s=8c5f12aa75e5143a2e33356cedba5058" alt="Database Agent open beside a Zite Database table" width="3000" height="2000" data-path="images/database-Agent.webp" />
</Frame>

## Open the agent

Click `Agent` at the top of your database. The Database Agent opens beside your table, so you can keep your records visible while you ask questions or make changes.

You can use the agent while working in any table or view.

## What it can do

<Frame>
  <img src="https://mintcdn.com/zite/LHj3Cm_bkE86rCz_/images/database-agent-email-1.webp?fit=max&auto=format&n=LHj3Cm_bkE86rCz_&q=85&s=df4c7266582c1dd95cde932a45b0c935" alt="Database Agent sending an email" width="3001" height="2000" data-path="images/database-agent-email-1.webp" />
</Frame>

<CardGroup cols={2}>
  <Card title="Explore and analyze records" color="#FFC738" icon="chart-line" iconType="regular">
    Ask questions about your data, summarize records, compare groups, find patterns, and understand trends from the current database.
  </Card>

  <Card title="Create tables and fields" color="#FFC738" icon="table-cells-large" iconType="regular">
    Ask the agent to design a database structure, create tables, add fields, rename fields, or suggest the right schema for your workflow.
  </Card>

  <Card title="Run custom scripts" color="#FFC738" icon="code" iconType="regular">
    Use custom scripts to query records, update data, paginate through larger result sets, and perform bulk operations with approval.
  </Card>

  <Card title="Work with external data" color="#FFC738" icon="cloud-arrow-down" iconType="regular">
    Pull in information from uploaded spreadsheets, web pages, URLs, or connected services to clean, summarize, enrich, or act on data.
  </Card>

  <Card title="Connect and call integrations" color="#FFC738" icon="plug" iconType="regular">
    Connect tools like Slack, Gmail, OpenAI, Airtable, Google Sheets, or Stripe, then use them from scripts and workflows after approval.
  </Card>
</CardGroup>

<Note>
  Changes that write data, update your schema, run scripts, or connect integrations require your approval before they run.
</Note>

## What it can't do yet

* **Run on a schedule:** The agent only runs when you message it. For recurring jobs, use an automation tool like Zapier or n8n.
* **Work across multiple databases at once:** The agent works with the current database. It can't inspect another Zite database as a second data source in the same request.
* **Directly edit existing connected apps or forms:** The agent can suggest next steps and help create connected workflows, but app and form edits still happen in their editors.

## Example prompts

<AccordionGroup>
  <Accordion title="Create or update tables">
    * "Create a CRM database with Contacts, Companies, Deals, and Tasks."
    * "Add a Priority field with Low, Medium, and High options."
    * "Create a linked record field that connects each Deal to a Company."
  </Accordion>

  <Accordion title="Ask questions and analyze trends">
    * "Show me all deals in the pipeline with their current stage and value."
    * "Which customers have the highest total contract value?"
    * "Summarize overdue tasks by owner."
  </Accordion>

  <Accordion title="Add integrations">
    * "Connect this database to a Zite app."
    * "Create a workflow that adds a new record when a form is submitted."
    * "Send a Slack message when a deal is marked Closed Won."
    * "Fetch company websites for these accounts and save them to a Website field."
  </Accordion>
</AccordionGroup>

## Chat history

You can start a new agent chat whenever you want to work on a different task or reset the conversation.

Previous chats are saved, so you can reopen earlier conversations to review what you asked, continue the same task, or understand why a change was made.

<div className="zite-related-topics">
  <a href="/help/database/getting-started/make-database">Make a Database</a>
  <a href="/help/database/getting-started/manage-views">Manage Views</a>
  <a href="/help/database/getting-started/ai-fields">AI Fields</a>
</div>

<div className="zite-related-topics">
  <a href="/help/database/getting-started/make-database">Make a Database</a>
  <a href="/help/database/configure-database/manage-views">Manage Views</a>
  <a href="/help/database/configure-database/ai-fields">AI Fields</a>
</div>

<div className="zite-related-topics">
  <a href="/help/database/getting-started/create-a-database">Create a Database</a>
  <a href="/help/database/configure-database/manage-views">Manage Views</a>
  <a href="/help/database/configure-database/ai-fields">AI Fields</a>
</div>
