--- title: "Extensions - Xata" description: "All extensions listed below are currently available for PostgreSQL 14, 15, 16, 17, and 18. These extensions provide additional functionality to enhance your database, from spatial data processing to text search and monitoring tools." source: "https://xata.io/docs/platform/extensions" --- Skip to main content ## ​Available PostgreSQL extensions Extensions that require preloading must be added to the “Preloaded Libraries” section in your branch settings before their configuration parameters become available. Once an extension is preloaded, you can configure its parameters in the PostgreSQL Configuration section. If you remove an extension from the preload list, any configured parameters for that extension will be automatically removed. | Extension | Description | Version | Prerequisites | | --------------------------------------------------------------------------------------------------- | ----------------------------------------------------------- | ------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [address_standardizer](https://postgis.net/docs/Extras.html#Address_Standardizer) | Standardizes address data using rules-based parsing | 3.6.3 | | | [address_standardizer_data_us](https://postgis.net/docs/Extras.html#Address_Standardizer_Tables) | US address data for address_standardizer | 3.6.3 | | | [amcheck](https://www.postgresql.org/docs/current/amcheck.html) | Functions for verifying relation integrity | 1.5 | | | [auth_delay](https://www.postgresql.org/docs/current/auth-delay.html) | Configurable delay after failed authentication attempts | 1.0 | Add `auth_delay` to “Preloaded Libraries” in branch settings to configure its parameters. | | [auto_explain](https://www.postgresql.org/docs/current/auto-explain.html) | Automatic query plan logging | 1.0 | Add `auto_explain` to “Preloaded Libraries” in branch settings to configure its parameters. | | [autoinc](https://www.postgresql.org/docs/current/contrib-spi.html#id-1.11.7.47.8) | Functions for automatic increment of fields | 1.0 | | | [bloom](https://www.postgresql.org/docs/current/bloom.html) | Bloom index access method | 1.0 | | | [btree_gin](https://www.postgresql.org/docs/current/btree-gin.html) | Support for indexing common datatypes in GIN | 1.3 | | | [btree_gist](https://www.postgresql.org/docs/current/btree-gist.html) | Support for indexing common datatypes in GiST | 1.8 | | | [citext](https://www.postgresql.org/docs/current/citext.html) | Case-insensitive text data type | 1.8 | | | [cube](https://www.postgresql.org/docs/current/cube.html) | Multi-dimensional cube data type | 1.5 | | | [dblink](https://www.postgresql.org/docs/current/dblink.html) | Cross-database queries | 1.2 | | | [dict_int](https://www.postgresql.org/docs/current/dict-int.html) | Text search dictionary template for integers | 1.0 | | | [dict_xsyn](https://www.postgresql.org/docs/current/dict-xsyn.html) | Text search dictionary template for synonyms | 1.0 | | | [earthdistance](https://www.postgresql.org/docs/current/earthdistance.html) | Earth distance calculations | 1.2 | | | [fuzzystrmatch](https://www.postgresql.org/docs/current/fuzzystrmatch.html) | Determine similarities and distance between strings | 1.2 | | | [hll](https://github.com/citusdata/postgresql-hll) | HyperLogLog data type for cardinality estimation | 2.19 | | | [hstore](https://www.postgresql.org/docs/current/hstore.html) | Key-value store data type | 1.8 | | | [hypopg](https://hypopg.readthedocs.io/) | Hypothetical indexes for query planning | 1.4.2 | | | [intagg](https://www.postgresql.org/docs/current/intagg.html) | Integer aggregator (deprecated in favor of array_agg) | 1.1 | | | [intarray](https://www.postgresql.org/docs/current/intarray.html) | Functions for 1-D arrays of integers | 1.5 | | | [insert_username](https://www.postgresql.org/docs/current/contrib-spi.html#id-1.11.7.47.9) | Automatic username insertion | 1.0 | | | [ip4r](https://github.com/RhodiumToad/ip4r) | IPv4 and IPv6 types and functions | 2.4 | | | [isn](https://www.postgresql.org/docs/current/isn.html) | International Standard Number data types | 1.3 | | | [lo](https://www.postgresql.org/docs/current/lo.html) | Large Object maintenance functions | 1.2 | | | [ltree](https://www.postgresql.org/docs/current/ltree.html) | Tree-like structures data type | 1.3 | | | [moddatetime](https://www.postgresql.org/docs/current/contrib-spi.html#id-1.11.7.47.10) | Automatic timestamp updates | 1.0 | | | [pageinspect](https://www.postgresql.org/docs/current/pageinspect.html) | Low-level page inspection | 1.13 | | | [pg_buffercache](https://www.postgresql.org/docs/current/pgbuffercache.html) | Buffer cache inspection | 1.6 | | | [pg_cron](https://github.com/citusdata/pg_cron) | Job scheduler for PostgreSQL | 1.6 | Enable `pg_cron` in the “Preloaded Libraries” section of “Advanced settings” under “Branch settings”. | | [pg_duckdb](https://github.com/duckdb/pg_duckdb) | DuckDB embedded in Postgres | 1.1.0 | **Analytics image only**. Automatically preloaded on analytics branches. Configure `duckdb.postgres_role` parameter to set the PostgreSQL role allowed to use DuckDB privileged features (defaults to `xata`). | | [pg_freespacemap](https://www.postgresql.org/docs/current/pgfreespacemap.html) | Free space map examination | 1.3 | | | [pg_hint_plan](https://github.com/ossc-db/pg_hint_plan) | Query execution plan hinting | 1.8.0 | Available on PostgreSQL 16, 17, and 18 only. Add `pg_hint_plan` to “Preloaded Libraries” in branch settings to configure its parameters. | | [pg_partman](https://github.com/pgpartman/pg_partman) | Partition management extension for PostgreSQL | 5.4.1 | | | [pg_prewarm](https://www.postgresql.org/docs/current/pgprewarm.html) | Database prewarming | 1.2 | Add `pg_prewarm` to “Preloaded Libraries” in branch settings to configure its parameters. | | [pg_repack](https://github.com/reorg/pg_repack) | Remove bloat from tables and indexes without exclusive lock | 1.5.3 | | | [pg_surgery](https://www.postgresql.org/docs/current/pgsurgery.html) | Row surgery functions for modifying rows | 1.0 | | | [pg_trgm](https://www.postgresql.org/docs/current/pgtrgm.html) | Trigram matching for similarity searches | 1.6 | | | [pg_visibility](https://www.postgresql.org/docs/current/pgvisibility.html) | Visibility map examination | 1.2 | | | [pg_walinspect](https://www.postgresql.org/docs/current/pgwalinspect.html) | WAL inspection functions | 1.1 | Available on PostgreSQL 16, 17, and 18 only. | | [pgrowlocks](https://www.postgresql.org/docs/current/pgrowlocks.html) | Row locking information | 1.2 | | | [pg_stat_statements](https://www.postgresql.org/docs/current/pgstatstatements.html) | Query execution statistics | 1.12 | Add `pg_stat_statements` to “Preloaded Libraries” in branch settings to configure its parameters. | | [pgstattuple](https://www.postgresql.org/docs/current/pgstattuple.html) | Functions to show tuple-level statistics | 1.5 | | | [pgaudit](https://github.com/pgaudit/pgaudit) | Audit logging extension for PostgreSQL | 18.0 | Add `pgaudit` to “Preloaded Libraries” in branch settings to configure its parameters. | | [pgcrypto](https://www.postgresql.org/docs/current/pgcrypto.html) | Cryptographic functions | 1.4 | | | [pgrouting](https://docs.pgrouting.org/) | Routing functionality for PostGIS/PostgreSQL | 4.0.1 | | | [pgtap](https://pgtap.org/) | Unit testing framework for PostgreSQL | 1.3.4 | | | [plpgsql](https://www.postgresql.org/docs/current/plpgsql.html) | PL/pgSQL procedural language | 1.0 | | | [postgres_fdw](https://www.postgresql.org/docs/current/postgres-fdw.html) | Foreign data wrapper for PostgreSQL | 1.2 | | | [postgis](https://postgis.net/) | PostGIS geometry and geography spatial types and functions | 3.6.3 | | | [postgis_raster](https://postgis.net/docs/RT_reference.html) | PostGIS raster extension | 3.6.3 | | | [postgis_sfcgal](https://postgis.net/docs/SFCGAL_User_Manual.html) | PostGIS SFCGAL support | 3.6.3 | | | [postgis_tiger_geocoder](https://postgis.net/docs/Extras.html#Tiger_Geocoder) | PostGIS tiger geocoder and reverse geocoder | 3.6.3 | | | [postgis_topology](https://postgis.net/docs/Topology.html) | PostGIS topology spatial types and functions | 3.6.3 | | | [prefix](https://github.com/dimitri/prefix) | Prefix matching operator | 1.2.0 | | | [refint](https://www.postgresql.org/docs/current/contrib-spi.html#id-1.11.7.47.11) | Referential integrity triggers (example) | 1.0 | | | [seg](https://www.postgresql.org/docs/current/seg.html) | Floating-point intervals | 1.4 | | | [sslinfo](https://www.postgresql.org/docs/current/sslinfo.html) | Information about SSL connections | 1.2 | | | [tablefunc](https://www.postgresql.org/docs/current/tablefunc.html) | Functions that manipulate whole tables, including crosstab | 1.0 | | | [tcn](https://www.postgresql.org/docs/current/tcn.html) | Triggered change notifications | 1.0 | | | [tsm_system_rows](https://www.postgresql.org/docs/current/tsm-system-rows.html) | TABLESAMPLE method which accepts number of rows | 1.0 | | | [tsm_system_time](https://www.postgresql.org/docs/current/tsm-system-time.html) | TABLESAMPLE method which accepts time in milliseconds | 1.0 | | | [unaccent](https://www.postgresql.org/docs/current/unaccent.html) | Text search dictionary that removes accents | 1.1 | | | [uuid-ossp](https://www.postgresql.org/docs/current/uuid-ossp.html) | UUID generation functions | 1.1 | | | [vector](https://github.com/pgvector/pgvector) | Vector similarity search for PostgreSQL | 0.8.1 | | | [wal2json](https://github.com/eulerto/wal2json) | Logical replication output plugin for JSON | 2.6 | | ## ​Request an extension **Need an extension we don’t have?** 📩 [Request an extension](https://xata.canny.io/xata-postgres-extensions) We’re always looking to expand our extension offerings. If you need an extension that’s not currently available, please let us know through our feature request portal. We’ll review your request and respond there. ## ​Getting help If you need help with a specific extension, we recommend checking the official documentation linked in the table above. For general PostgreSQL extension support, you can also refer to the [PostgreSQL documentation](https://www.postgresql.org/docs/current/). If you run into an issue or discover a bug with an extension, we recommend reporting it to the extension’s upstream maintainers. If a fix is released, we’re happy to update to the latest version of the extension. For additional support, you can also [contact our support team](https://xata.io/contact-support). ## ​Custom extensions We don’t actively maintain third-party extension code, but we’re happy to help you get the extensions you need. If you require a custom extension that’s not listed above, we encourage you to [contact our support team](https://xata.io/contact-support) to discuss. ### ​BYOC for custom extensions If you need to install custom extensions that aren’t available in our standard offering, consider our [Bring Your Own Cloud (BYOC) deployment model](/docs/core-concepts/deployment#bring-your-own-cloud-byoc). This allows you to run the entire Xata dataplane in your own Kubernetes cluster, giving you full control over which extensions are installed and configured. Was this page helpful? [Previous](/docs/platform/logs) [Schemas](/docs/platform/schemas) [Next](/docs/platform/schemas)