Connection Fields by Database Type
The connection editor renders the fields that actually apply to the database you pick, with the label each engine uses. A generic "Database" box is wrong for most engines, so the form adapts: pick a type and the right fields appear.
What the "database" slot means per engine
| Engine | Field | Meaning |
|---|---|---|
| PostgreSQL, Supabase, SQL Server, MySQL/MariaDB, PlanetScale | Database | The database / catalog (for MySQL and PlanetScale, schema and database are the same). Supabase and PlanetScale take the same fields as PostgreSQL and MySQL, with TLS (SSL Mode in the IDE, SSL / TLS in DB DevOps) starting at Require and Verify Full, since both hosts accept only TLS. |
| Oracle | Service Name / PDB | The Oracle service name used to connect (EZConnect host:port/service). For a pluggable database this is the PDB, e.g. FREEPDB1. It is not a schema, in Oracle a schema is a user, so it never appears in the schema list. Use an account with access to ALL_USERS to browse schemas. |
| SQLite | Database File Path | Filesystem path to the .db/.sqlite file (or :memory:). No host or credentials. |
| MongoDB | Auth Database | The database your credentials authenticate against (default admin). A full Connection String field is also offered and overrides the host/port/auth fields. |
| Redis | Database Number | The numeric DB index (0-15 by default). |
| Snowflake | Account Identifier, Warehouse, Database, Schema | The account identifier is the part of your Snowflake URL before .snowflakecomputing.com, such as myorg-myaccount (required), with the user name and password. Warehouse, database and schema are where the session starts; blank uses the user's defaults. Role and Access URL, for a private link, are under advanced. No host or port. |
| Google BigQuery | Project ID, Dataset | The project jobs run and bill in (required) and the dataset unqualified names resolve to. The Service Account Key is the key file's JSON, sealed like a password; blank uses the server's own Google credentials. Location and Endpoint URL are under advanced. No host or port. |
| InfluxDB | Organization, Bucket | The organization the API token belongs to (required) and the bucket InfluxQL queries, line protocol writes and the navigator start in. Host and port (8086) reach the InfluxDB 2 HTTP API; the API Token is required and sealed like a password; SSL Mode other than Disable uses HTTPS. |
| Amazon DynamoDB | Region | The AWS region the tables are in. Access Key ID and Secret Access Key sign the requests (blank uses the server's own AWS identity); Endpoint URL, under advanced, points at DynamoDB Local or a private endpoint. No host or port. |
| ClickHouse | Database | The database queries run in (default default), over the HTTP interface on port 8123; the username defaults to default. |
Required vs. optional
A database type the product has no connector for is refused when the connection is saved, with <engine> has no connector, so DB Studio cannot connect to it.
Only the fields a connection cannot be built without are required, host (for networked engines), Oracle's Service Name, and SQLite's file path. Username and password are optional, because trust / integrated / no-auth setups are valid; a bad credential surfaces the driver's real error when you Test or connect rather than being pre-guessed by the form. Advanced, driver-honored options (SSL mode, timeouts, SQL Server encryption) live under the advanced/additional-parameters area and only appear for engines that honor them.