> ## 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.

In the Zite Database editor, use it to create and organize your database, ask questions about your records, analyze trends, update fields, and connect integrations while you work.

<Frame>
  <img src="https://mintcdn.com/zite/NE90m6yKntOOw50q/images/database-agent-2.png?fit=max&auto=format&n=NE90m6yKntOOw50q&q=85&s=e12a1e8148ffaf028d62ade76fbf5615" alt="Zite Agent alongside a database view" width="2564" height="1506" data-path="images/database-agent-2.png" />
</Frame>

## Work with the agent

The Agent persists as you move between views, so you can continue the same conversation while working with your data. It keeps the current database context as you ask questions or make changes.

## 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/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>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.