PostgreSQL and MySQL
Register a SQL database, choose an SSL mode, and make it the default connection for new chats.
Add a connection
From Databases, choose Add connection and supply the host, port, database name, user, and password. Credentials are encrypted before they are stored and are never sent back to the browser: the UI shows a redacted summary.
Use a read-only role
ChatPlotDB only ever issues read queries, but the safest posture is a database
user that cannot do anything else. Grant SELECT on the tables you want
queried and nothing more.
SSL modes
Pick the mode your server requires:
| Mode | Behaviour |
|---|---|
require | Encrypt; do not verify the certificate |
prefer | Encrypt if the server supports it |
allow | Encrypt only if the server insists |
disable | No encryption |
verify-ca and verify-full exist in the data model but need a CA certificate
that the API does not yet accept, so they are not selectable.
The default connection
One connection per context is the default. New chats open against it, so the common case needs no selection. Change it from the connection's menu.
Test and refresh
Test re-opens the connection and reports failures without changing anything. After a schema change, re-run Config Studio so the config reflects the new tables: the agent reads the config, not the live schema, when it plans a query.