Skip to content
Reference
2 min read

Postgres Compatibility

See the supported and unsupported Postgres features and extensions Vercel supports.
Table of Contents
Choose a framework to optimize documentation to:

    Vercel Postgres is available on Hobby and Pro plans

    Vercel Postgres has integrated many PostgreSQL extensions, which will be automatically available to your database. Vercel's Postgres compatibility is based on our Neon integration.

    The following table lists the PostgreSQL extensions Vercel Postgres supports.

    Extension
    Extension Version (PostgreSQL 15)
    Note
    address_standardizer
    3.3.2
    address_standardizer_data_us
    3.3.2
    autoinc (spi)
    1.0
    bloom
    1.0
    btree_gin
    1.3
    btree_gist
    1.7
    citext
    1.6
    cube
    1.5
    dict_int
    1.0
    earthdistance
    1.1
    fuzzystrmatch
    1.1
    h3_pg
    4.1.2
    hll
    2.16
    hstore
    1.8
    hypopg
    1.3.1
    insert_username (spi)
    1.0
    intagg
    1.1
    intarray
    1.5
    ip4r
    2.4.2
    isn
    1.2
    lo
    1.1
    ltree
    1.2
    moddattime (spi)
    1.0
    pg_graphql
    1.1.0
    pg_hashids
    1.2.1
    pg_hint_plan
    1.4.1
    pg_jsonschema
    1.1.0
    pg_hashids
    1.2.1
    pg_prewarm
    1.2
    pg_roaringbitmap
    0.5
    pg_stat_statements
    1.10
    pg_tiktoken
    0.0.1
    pg_trgm
    1.6
    pg_uuidv7
    1.0
    pgcrypto
    1.3
    pgjwt
    0.2.0
    pgrouting
    3.1.4
    The PostGIS extension must be installed first.
    pgrowlocks
    1.2
    pgstattuple
    1.5
    pgTAP
    1.2.1
    pgvector
    0.4.0
    Install with CREATE EXTENSION vector;
    pgx_ulid
    0.1.3
    Install with CREATE EXTENSION vector;
    plcoffee
    3.1.5
    plls
    3.1.5
    plpgsql
    1.0
    Pre-installed with PostgreSQL.
    plpgsql_check
    2.3
    plv8
    3.1.5
    postgis
    3.3.2
    postgis_raster
    3.3.2
    postgis_tiger_geocoder
    3.3.2
    Cannot be installed using the Vercel Postgres SQL Editor. Use your psql user credentials to install this extension.
    postgis_topology
    3.3.3
    prefix
    1.2.0
    rdkit
    4.3.0
    refint (spi)
    1.0
    roaringbitmap
    0.5
    rum
    1.3
    seg
    1.4
    tablefunc
    1.0
    tcn
    1.0
    timescaledb
    2.10.1
    Only Apache-2 licensed features are supported. Compression is not supported.
    tsm_system_rows
    1.0
    tsm_system_time
    1.0
    unaccent
    1.1
    unit
    7
    uuid-ossp
    1.1
    Double-quote the extension name when installing: CREATE EXTENSION "uuid-ossp"
    xml2
    1.1
    • Vercel Postgres supports the uuid-ossp extension for generating UUIDs instead of the uuid extension.
    • The sslinfo extension is not supported. Vercel Postgres handles connections through a proxy that checks SSL.
    • The pg_cron extension is not supported. Vercel Postgres scales to zero when it is not being used, which means that a scheduler that runs inside the database cannot be implemented. Consider using an external scheduler like Vercel Cron Jobs.
    • The file_fdw extension is not supported. Files would not remain accessible when Vercel Postgres scales to zero.

    You can install extensions from the CLI interface in your dashboard on Vercel, or with a PostgreSQL client of your choice.

    CREATE EXTENSION vector;
    ALTER EXTENSION extension_name UPDATE TO 'x.x.x';

    You can check the version of an extension with:

    SELECT * FROM extension_name;
    Last updated on December 1, 2023