Databases

Databases are SQL databases optimized for agents. You can create a database, inspect its tables, ask questions in chat, show query results, and make approved data or structure changes.

Creating Databases

Create a database when you need a structured place to store records, lists, imports, calculations, or lightweight internal tools.

  1. Open Databases from the app.
  2. Click the + button.
  3. Open the new database from the list.
  4. Use the chat input to describe what you want to store or inspect.

New databases start without tables. The database chat can help design a schema, import attached data, create tables, and keep the description up to date.

Reading a Database

Each database page has a split view. The left side shows the database description or table data, and the right side shows the database chat.

The database description explains the purpose of the database, the rules for using it, and the meaning of each table. When tables exist, they appear in the table navigation near the top of the page. Click a table to preview up to 100 rows, then click a row to expand all fields.

Asking Database Questions

Database chat can inspect structure, run read-only SQL, summarize tables, and display query results in the table pane.

You can ask questions like "What tables are in this database?", "Show me the latest customers", "Which orders are missing an email address?", or "Explain how this schema works". If a query returns a table-shaped result, the result can appear as a custom query view on the left.

Changing Data and Structure

Database chat can change data or schema, but only after you clearly ask for the change. This keeps accidental edits from happening during normal exploration.

For data changes, ask exactly what should be inserted, updated, or deleted. For structure changes, describe the table or column change you want. Before major changes, the assistant can create a snapshot so the database can be restored if something goes wrong.

Using Snapshots

Snapshots are temporary restorable copies of a database. They are useful before imports, cleanup jobs, or schema edits.

Ask the database chat to create a snapshot with a short name, list available snapshots, or restore a previous snapshot. Old snapshot files are cleaned up automatically after about a day, so treat them as short-term safety points rather than long-term backups.

Managing Databases

The database list shows every database in your workspace with a short table summary. Open a database to inspect it, chat with it, or delete it.

Use Reset Chat from the database menu when you want to start a fresh database conversation. Use Delete only when you no longer need the database, because deleting it removes the database file, its tables, and its attached chat history.