🛠️ 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 SQL Server database and a read-only connection string.
- A single
SELECT query with a column that uniquely identifies each row.
- Network access from Zammo to your database.
Step by step
- Open Sources → Add source → SQL Query.
- Enter a Name and pick the Knowledge base the rows should land in. Add an optional Description.
- Paste your Connection string — use a read-only database user.
- 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.
- Set Max rows per run (default 10,000).
- (Optional) add Default tags.
- Select Create + ingest. You'll see a result summary — rows inserted, updated, and removed, plus how long it took.
The SQL data source form: pick a knowledge base, paste a read-only connection string, and enter your SELECT query.
Every setting