Overview

A connection tells STYD how to reach a data source so it can answer questions about it. Connections are managed per workspace.

What a connection is

A connection stores the details STYD needs to read from your data: the driver, host, port, database, user, and password (plus a schema for PostgreSQL). STYD supports PostgreSQL and MySQL databases. Odoo is also supported and has its own section.

A connection belongs to one workspace, and each chat thread uses one connection at a time.

Where to manage connections

Connections are managed from Settings → Connections. An older standalone /connections route may still work as a compatibility or deep link.

A plan is not needed to connect: Odoo instances and PostgreSQL or MySQL databases are not limited by plan (a safety cap of 50 active connections per workspace applies). The free trial covers one Odoo connection and one database. The AI analysis of a database uses an included AI Guide setup, then prompts. Owners and admins can create and edit connections; members have read-only access, and viewers cannot access connections.

Read-only by design

STYD answers by running read-only queries. It is designed to read your data, not change it. Connecting with a read-only database user is the recommended practice.

STYD connects from the internet, so a database must be reachable at a public address. A database on localhost or a private network is not reachable from STYD Cloud, and there is no SSH tunnel option; a custom, private installation can reach it (see Custom AI).

When to create a new connection

You are adding a different database or data source.
You want to keep environments (for example staging and production) separate.
A chat thread needs to ask about a source the workspace cannot yet reach.

After you create one

Test the connection first, then save it. After you save a database, STYD offers to analyse it with the AI Guide. Your first analysis is included while your workspace has an AI Guide setup left (see Pricing) and starts by itself; otherwise STYD shows its price in prompts and an owner or admin confirms it. You can chat with the connection before the analysis is done, but answers improve once it is.