🛠️ How-to guide

<aside> 🗄️

WHAT IT DOES

SQL Query turns rows from your own database into knowledge. You register a read-only SELECT, and Zammo keeps the results in sync — adding new rows, updating changed ones, and removing rows that are gone.

</aside>

When to use it

Use it when the answer lives in a database — a directory, a catalog, a status table — and you want your agent to draw on live records rather than a static export.

Before you start

• Access: Editor, Content Manager, Publisher, or Admin (see Roles & Permissions).
• A Knowledge Bases already created — you choose one during setup.
• A reachable Microsoft SQL Server database and a read-only connection string. (Today, only Microsoft SQL Server databases are supported.)
• SQL Query is a paid-plan feature — on other plans, choosing it shows an upgrade prompt.
• A single SELECT query with a column that uniquely identifies each row.
• Network access from Zammo to your database.

Step by step

1. Open Sources → Add source → SQL Query.
2. Enter a Name and pick the Knowledge base the rows should land in. Add an optional Description.
3. Paste your Connection string — use a read-only database user.
4. Enter the SQL (a single SELECT) and the Row id column that uniquely identifies each row. Optionally set a Title column and a Content column.
5. Select Test connection & query to confirm Zammo can connect and your query returns rows — this is required before you can save.
6. Set Max rows per run (default 10,000).
7. (Optional) add Default tags.
8. Select Create + ingest. You'll see a result summary — rows inserted, updated, and removed, plus how long it took.