Reference

Postgres Compatibility

See the supported and unsupported Postgres features and extensions Vercel supports.
Table of Contents

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.

ExtensionExtension Version (PostgreSQL 15)Note
address_standardizer3.3.3
address_standardizer_data_us3.3.3
autoinc (spi)1.0
bloom1.0
btree_gin1.3
btree_gist1.7
citext1.6
cube1.5
dict_int1.0
earthdistance1.1
fuzzystrmatch1.1
h3_pg4.1.3
hll2.18
hstore1.8
hypopg1.4.1
insert_username (spi)1.0
intagg1.1
intarray1.5
ip4r2.4.2
isn1.2
lo1.1
ltree1.2
moddattime (spi)1.0
pg_graphql1.4.0
pg_hashids1.2.1
pg_hint_plan1.7.0
pg_ivm1.9
pg_jsonschema0.2.0
pg_partman5.1.0
pg_prewarm1.2
pg_roaringbitmap0.5
pg_stat_statements1.10
pg_tiktoken0.0.1
pg_trgm1.6
pg_uuidv71.6.0
pgcrypto1.3
pgjwt0.2.0
pgrouting3.4.2The PostGIS extension must be installed first.
pgrowlocks1.2
pgstattuple1.5
pgTAP1.3.3
pgvector0.7.4Install with CREATE EXTENSION vector;
pgx_ulid0.1.3Install with CREATE EXTENSION vector;
plcoffee3.1.8
plls3.1.8
plpgsql1.0Pre-installed with PostgreSQL.
plpgsql_check2.5.3
plv83.2.3
postgis3.3.3
postgis_raster3.3.3
postgis_tiger_geocoder3.3.3Cannot be installed using the Vercel Postgres SQL Editor. Use your psql user credentials to install this extension.
postgis_topology3.3.3
prefix1.2.0
rdkit4.6.0
refint (spi)1.0
roaringbitmap0.5
rum1.3
seg1.4
tablefunc1.0
tcn1.0
timescaledb2.17.0Only Apache-2 licensed features are supported. Compression is not supported.
tsm_system_rows1.0
tsm_system_time1.0
unaccent1.1
unit7
uuid-ossp1.1Double-quote the extension name when installing: CREATE EXTENSION "uuid-ossp"
xml21.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 October 29, 2024