Create a database

Add a database

Open your project and choose Databases. In a blank project you will see No database provisioned yet and Create Database. Otherwise choose + New Database.

In Create Additional Database:

1. Database Label: a friendly name.
2. PostgreSQL Database Name: accept the suggestion or type one. Lowercase letters, numbers, underscores and hyphens, starting with a letter; unique across the platform; checked as you type.
3. PostgreSQL Engine Version: pick one (the picker offers 14 to 18, 17 preselected).
4. Database Extensions (Optional): for example pgvector or PostGIS. Extensions that do not support the chosen version are disabled.
5. Provision Database.

An application role named <name>_app and credentials are created with it.

Check it

Databases > Fleet Instances lists the database with role Primary or Additional, engine and status. Set Primary switches the primary database without deleting anything. The database picker in the sidebar and top bar controls which database each page shows.

DB Settings shows the engine version it really runs, encoding, timezone, extensions and limits such as Statement Timeout and Connection Limit.

Limits

Accounts have a default cap on databases, shown on Usage & Billing as used / max; Request Increase asks for more. Creating databases is blocked if the account is paused for unpaid usage.

Try it

Create a database labelled "main". Then open DB Settings and read Runs on PostgreSQL N.

Recap

• Each database has its own name, role and connection.
• A project can hold several databases; one is primary.