Add connection

A connection lets STYD read a data source, Odoo or a database, and answer questions about your data.

Connections are managed from Settings → Connections. Owners and admins add and edit them; members can see them; viewers cannot open Settings.

What you can connect

Odoo
With an Odoo API key (the quickest way, Odoo 15 and later) or with the STYD Bridge add-on (one Odoo user per person). It has its own documentation section.

PostgreSQL
A database, with a read-only user.

MySQL
A database, with a read-only user.

Sample companies
Three fictional companies that STYD provides, so you can ask questions before you connect your own data. They are marked “Sample data”.

Uploaded files
A locked row that holds the documents and spreadsheets you add in Settings → Documents. It is not a database and you do not create it.

Other kinds of database, such as SQL Server, Oracle, SQLite, BigQuery or MongoDB, are not supported. Only read-only queries are executed. STYD never modifies your data.

Create a database connection

Open Settings → Connections

Choose “Add a connection”, then “A database”

Select the database type (PostgreSQL or MySQL)

Enter the server address, port, database, user and password

Choose “Test connection”

Choose “Save connection”

A database must be reachable at a public address. If it only accepts approved addresses, allow STYD’s: the form lists them. Localhost and private-network addresses are refused.

After you save

You can chat with a database as soon as it is saved. STYD also offers to analyse it with the AI Guide, which adds table and column descriptions and a database summary, so answers improve. Your first analysis is included while your workspace still has an AI Guide setup left (see Pricing) and starts by itself, for databases of up to 3,000 columns; otherwise STYD shows its price in prompts first, and an owner or admin confirms it.

An Odoo connection has no analysis: STYD reads Odoo itself.

Test connection

The test connection button verifies that your credentials and database access are valid before saving. If it fails, STYD shows one of four plain messages; see Common connection errors.

Always test your connection before saving to avoid configuration issues.

Managing connections

Edit
You can update connection settings at any time.

Archive
Archiving hides a connection and erases its password or API key; its past answers, sample values, descriptions and linked Odoo users stay until the workspace is deleted. Reconnect it later to use it again, with its history.

Reuse
Connections can be used across multiple chats in the same workspace.

Isolation
Connections belong to a single workspace.

Important notes

Read-only access recommended
Use a database user with read-only permissions for maximum safety.

Schema changes
If you add new tables or columns, analyse the database again so the AI Guide picks them up. After the first analysis, every new one costs prompts, and STYD shows the price before you confirm.

Security
Credentials are securely stored and encrypted.