Database Extensions
Enable and disable PostgreSQL extensions per project.
PostgreSQL extensions can be managed individually for each project under Project Settings → Database.
Enabled by default
New projects get a set of commonly needed extensions enabled automatically, so the things people usually reach for work without setup:
| Extension | What it gives you |
|---|---|
pg_cron | Scheduled jobs inside the database |
pg_net | Asynchronous HTTP requests from SQL |
vault | Encrypted secret storage |
citext | Case-insensitive text columns |
pgcrypto | Cryptographic functions, UUID generation |
Others are available and can be enabled per project.
Managing extensions
- Open the project
- Go to Settings → Database
- Toggle an extension on or off
- Changes apply to that project only
Disabling an extension that database objects depend on will fail, or break those objects. Check what uses an extension before turning it off — pg_cron jobs and vault secrets are the usual culprits.
Existing projects
Projects created before this release keep whatever extensions they already had. The defaults above apply to newly created projects; enable anything you want on an existing project from the same screen.
Verifying
Connect to the project database and list what is installed:
SELECT extname, extversion FROM pg_extension ORDER BY extname;