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.

Supported extensions

The following table lists the PostgreSQL extensions Vercel Postgres supports.

Extension	Extension Version (PostgreSQL 15)	Note
`address_standardizer`	3.3.3
`address_standardizer_data_us`	3.3.3
`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.3
`hll`	2.18
`hstore`	1.8
`hypopg`	1.4.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.4.0
`pg_hashids`	1.2.1
`pg_hint_plan`	1.7.0
`pg_ivm`	1.9
`pg_jsonschema`	0.2.0
`pg_partman`	5.1.0
`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.6.0
`pgcrypto`	1.3
`pgjwt`	0.2.0
`pgrouting`	3.4.2	The PostGIS extension must be installed first.
`pgrowlocks`	1.2
`pgstattuple`	1.5
`pgTAP`	1.3.3
`pgvector`	0.7.4	Install with CREATE EXTENSION vector;
`pgx_ulid`	0.1.3	Install with CREATE EXTENSION vector;
`plcoffee`	3.1.8
`plls`	3.1.8
`plpgsql`	1.0	Pre-installed with PostgreSQL.
`plpgsql_check`	2.5.3
`plv8`	3.2.3
`postgis`	3.3.3
`postgis_raster`	3.3.3
`postgis_tiger_geocoder`	3.3.3	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.6.0
`refint (spi)`	1.0
`roaringbitmap`	0.5
`rum`	1.3
`seg`	1.4
`tablefunc`	1.0
`tcn`	1.0
`timescaledb`	2.17.0	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

Exceptions

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.

Installing an extension

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

CREATE EXTENSION vector;

Updating an extension

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

Local Development

Limits

Was this helpful?