Skip to main content

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#

1. Go to the Database page2. Click on "Extensions" in the sidebar 3. Find the extension you would like to enable/disable 4. Click the toggle.

Full list of extensions#

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

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

hstore_plpython3u

Transform between hstore and plpython3u

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

jsonb_plpython3u

Transform between jsonb and plpython3u

lo

Large Object maintenance

ltree

Data type for hierarchical tree-like structures

ltree_plpython3u

Transform between ltree and plpython3u

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

plpython3u

PL/Python3U untrusted procedural language

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