Databases

Managed databases are provisioned in seconds, isolated, and encrypted at rest. Create Postgres, Redis, MySQL, or MongoDB.

Create a database#

1. 1

   New database

   On the Databases page, click “New database”.

2. 2

   Name it and pick an engine

   Choose Postgres, Redis, MySQL, or MongoDB. Optionally attach it to a project, or leave it standalone.

3. 3

   Wait for provisioning

   The host shows “Provisioning…” until the database is ready.

Connect#

Open the Connect tab and click “Reveal connection details” (recorded in your audit log) to see the host, port, username, and password, plus ready-made snippets for a .env file, Node.js, and the CLI (psql, mysql, mongosh, redis-cli).

Query console#

The Data tab opens a console for all four engines. Postgres and MySQL also get a Browse grid over your tables. Run statements with the Run button (⌘/Ctrl+Enter), format SQL, and export results as CSV or JSON.

SELECT * FROM your_table LIMIT 100;

Reset credentials#

Use “Regenerate password” (or Reset password in Settings) to rotate the password. Existing connections are dropped and must reconnect with the new secret.

Snapshots & branches (Postgres)#

• Snapshots — take an on-demand backup with “Take snapshot” and restore it later.
• Branches — copy a database’s schema and data into an isolated branch (e.g. pr-123), then reset or delete it.

Extensions (Postgres)#

Open Settings on a Postgres database to enable curated extensions with one click. pgvector adds the vector column type for embeddings and similarity search.

CREATE TABLE items (id bigserial PRIMARY KEY, embedding vector(3));
INSERT INTO items (embedding) VALUES ('[1,2,3]');

Default ports#

Scheduled backups & retention (Postgres)#

Under Settings, set a cron schedule to snapshot a Postgres database automatically. Retention keeps only the newest N snapshots — older automated ones are pruned (row and object). Any snapshot, manual or automated, can be restored in place with one click.

Connection pooling (Postgres)#

Reveal a Postgres database’s connection details to also get a pooled connection string that routes through PgBouncer (transaction pooling). Use the pooled URL for apps that open many short-lived connections (serverless, high concurrency); use the direct URL for sessions that need prepared statements or LISTEN/NOTIFY.

Postgres

5432

MySQL

3306

MongoDB

27017

Redis

6379

A database can belong to a project or stand alone. A branch is itself a full database you can connect to, reset, or delete independently of its source.