Overview

Extensions are exactly as they sound - they "extend" the database with functionality which isn't part of the Postgres core. Supabase has pre-installed some of the most useful open source extensions.

Enable and disable extensions#

Go to the Database page in the Dashboard.
Click Extensions in the sidebar.
Enable or disable an extension.

Full list of extensions#

Supabase is pre-configured with over 50 extensions. You can also install your own SQL extensions directly in the database through our SQL editor.

Filter extensions

`address_standardizer`

Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.

`address_standardizer-3`

Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.

`address_standardizer_data_us`

Address Standardizer US dataset example

`address_standardizer_data_us-3`

Address Standardizer US dataset example

`adminpack`

Administrative functions for PostgreSQL

`amcheck`

Functions for verifying relation integrity

`autoinc`

Functions for autoincrementing fields

`bloom`

Bloom access method - signature file based index

`btree_gin`

Support for indexing common datatypes in GIN

`btree_gist`

Support for indexing common datatypes in GiST

`citext`

Data type for case-insensitive character strings

`cube`

Data type for multidimensional cubes

`dblink`

Connect to other PostgreSQL databases from within a database

`dict_int`

Text search dictionary template for integers

`dict_xsyn`

Text search dictionary template for extended synonym processing

`earthdistance`

Calculate great-circle distances on the surface of the Earth

`file_fdw`

Foreign-data wrapper for flat file access

`fuzzystrmatch`

Determine similarities and distance between strings

`hstore`

Data type for storing sets of (key, value) pairs

`http`

HTTP client for PostgreSQL, allows web page retrieval inside the database.

`insert_username`

Functions for tracking who changed a table

`intagg`

Integer aggregator and enumerator (obsolete)

`intarray`

Functions, operators, and index support for 1-D arrays of integers

`isn`

Data types for international product numbering standards

`lo`

Large Object maintenance

`ltree`

Data type for hierarchical tree-like structures

`moddatetime`

Functions for tracking last modification time

`pageinspect`

Inspect the contents of database pages at a low level

`pg_buffercache`

Examine the shared buffer cache

`pg_cron`

Job scheduler for PostgreSQL

`pg_freespacemap`

Examine the free space map (FSM)

`pg_prewarm`

Prewarm relation data

`pg_stat_statements`

Track execution statistics of all SQL statements executed

`pg_trgm`

Text similarity measurement and index searching based on trigrams

`pg_visibility`

Examine the visibility map (VM) and page-level visibility info

`pgaudit`

Provides auditing functionality

`pgcrypto`

Cryptographic functions

`pgjwt`

JSON Web Token API for Postgresql

`pgrowlocks`

Show row-level locking information

`pgstattuple`

Show tuple-level statistics

`pgtap`

Unit testing for PostgreSQL

`plcoffee`

PL/CoffeeScript (v8) trusted procedural language

`pljava`

PL/Java procedural language (https://tada.github.io/pljava/)

`plls`

PL/LiveScript (v8) trusted procedural language

`plpgsql`

PL/pgSQL procedural language

`plpgsql_check`

Extended check for plpgsql functions

`plv8`

PL/JavaScript (v8) trusted procedural language

`postgis`

PostGIS geometry and geography spatial types and functions

`postgis-3`

PostGIS geometry and geography spatial types and functions

`postgis_raster`

PostGIS raster types and functions

`postgis_raster-3`

PostGIS raster types and functions

`postgis_sfcgal`

PostGIS SFCGAL functions

`postgis_sfcgal-3`

PostGIS SFCGAL functions

`postgis_tiger_geocoder`

PostGIS tiger geocoder and reverse geocoder

`postgis_tiger_geocoder-3`

PostGIS tiger geocoder and reverse geocoder

`postgis_topology`

PostGIS topology spatial types and functions

`postgis_topology-3`

PostGIS topology spatial types and functions

`postgres_fdw`

Foreign-data wrapper for remote PostgreSQL servers

`refint`

Functions for implementing referential integrity (obsolete)

`seg`

Data type for representing line segments or floating-point intervals

`sslinfo`

Information about SSL certificates

`tablefunc`

Functions that manipulate whole tables, including crosstab

`tcn`

Triggered change notifications

`tsm_system_rows`

TABLESAMPLE method which accepts number of rows as a limit

`tsm_system_time`

TABLESAMPLE method which accepts time in milliseconds as a limit

`unaccent`

Text search dictionary that removes accents

`uuid-ossp`

Generate universally unique identifiers (UUIDs)

`xml2`

XPath querying and XSLT