Knowledge sources
Databases
Connect PostgreSQL, MySQL, SQL Server, Oracle, Snowflake, SAP HANA or SQLite so agents can answer questions with live SQL queries.
La documentation existe en anglais et en turc, comme l'interface de Harmona. Cette page est affichée en anglais.
A Database connection lets agents answer questions from live data. The agent turns the question into SQL, runs it against your database and explains the result. Nothing is copied: every answer uses the data as it is at that moment.
Supported databases
| Database | What you enter | Default port |
|---|---|---|
| PostgreSQL | Host, port, database name, username, password, schema (default `public`) | 5432 |
| MySQL | Host, port, database name, username, password, optional schema | 3306 |
| Microsoft SQL Server | Host, port, optional instance (for example `SQLEXPRESS`), database name, username, password, schema (default `dbo`) | 1433 |
| Oracle | Host, port, service name (for example `ORCL`), username, password, optional schema | 1521 |
| Snowflake | Host, port, database name, warehouse (for example `COMPUTE_WH`), username, password, optional schema | 443 |
| SAP HANA | Host, port, username, password, optional database name and schema | 30015 |
| SQLite | The `.db` database file | — |
Oracle needs no extra driver on your side.
Connect a database
- 1Go to Studio → Connections, click Create Connection and choose Database.
- 2Pick the Database Type, then enter a Connection Name and a Description.
- 3Fill in the connection details. The port is filled in for you.
- 4Click Create Connection.
- 5When Harmona asks Analyze this database?, click Analyze database, or Not now to choose tables first.
Tables and descriptions
Before an agent can answer anything, Harmona reads the schema and writes a description of every table and column. Agents use these descriptions to write correct queries. The analysis costs model usage in proportion to the size of the schema.
- Update analysis analyzes new and out-of-date tables only. This is usually enough.
- Choose tables… under More analysis options lets you pick specific tables, then click Analyze selected.
- Analyze from scratch re-runs every table. Your own edits are kept either way.
Open a table to read its description and column details. Click a description to edit it. Each column shows how sure the analysis is:
| Badge | Meaning |
|---|---|
| Verified | A query against your data confirmed the description. |
| Needs review | The column stayed ambiguous. The description is a guess, and correcting it improves every answer that uses the table. |
| Edited | A person wrote it. Re-analyzing keeps it. |
Short or cryptic names like `ord_amt` or `cst_flg` are where your edits help most. A clear connection Description helps too: it gives the analysis the business context behind the names. To remove a table from the connection, click Deactivate Table.
Attention
Use a read-only user
Agents are instructed to run only SELECT queries, and the tiles a Worker saves only read.
Give Harmona a read-only user
The model that writes table descriptions is set under Management → Organization Settings → General: SQL analysis model, and SAP HANA analysis model for HANA, whose schemas are often larger. See Deep document analysis.
Mis à jour 2026-09-24