Extensions

See which PostgreSQL extensions are available for your database, enable or disable them and understand "needs approval".

Updated Nov 12, 2026

Extensions add features to PostgreSQL, such as vector search, geospatial types or fuzzy text matching.

When you create a database

The create forms list common extensions with their supported versions: UUID generation (uuid-ossp), cryptographic functions (pgcrypto), trigram search (pg_trgm), pgvector, PostGIS, query statistics (pg_stat_statements), hstore, citext, btree_gin and unaccent. Tick the ones you want. The first two are preselected.

Manage them afterwards

Open Databases > DB Settings.
In PostgreSQL engine & extensions, look at the line Runs on PostgreSQL N. The list shows what that server can install.
Use Search extensions and the filters All, Enabled, Available and Needs approval.
Choose Enable on an extension. Choose Disable to remove one (you are asked to confirm).

Active Extensions & Modules shows what is on now.

Needs approval

Databases share servers, so some extensions are not offered: ones that run code on the host, read server files or reach other databases. Others are listed as needs approval; contact support to request one.

Good to know

Disabling fails if a table, column or function still uses the extension.
Core extensions provided by the platform cannot be removed.
Before an upgrade, an extension your database uses must exist on the target version. See PostgreSQL versions and upgrades.
pg_stat_statements feeds the slow-query view in the advisor. See Query Advisor and performance.

More guides in Console: databases

Create a database

Add a PostgreSQL database to a project, choose its version and extensions, and manage several databases in one project.

Connection strings, direct and pooled connections

Find your host, port and credentials, choose between the pooled, regular and direct connection, and test that they work.

Your database's own address

Use the per-database address shown on the Connection page, what is faster about it, and how to rename it safely.

The SQL editor

Run queries and scripts against your database from the Console, use templates and history, and understand the safety limits.

Import data into a database

Bring a database over from another host, or upload a .sql or .sql.gz dump, from the Backups page.

PostgreSQL versions and upgrades

Choose a version when you create a database and upgrade to a newer one from DB Settings, with a verified copy.