PostgreSQL extensions are powerful add-ons that enhance PostgreSQL’s functionality beyond its core features. They introduce new data types, functions, and operators to the database - usually to support a specific use case.

This rich ecosystem of extensions is available to you out of the box in Nile. No need to install or even run CREATE EXTENSION commands. Just use the extension in your queries. You can experiment with the extensions and try them out in the Nile console, by navigating to the Extensions tab on the left.

Don’t see an extension you need? Let us know by creating a GitHub issue.

Pgvector

Perform vector similarity search and build AI-powered features

PostGIS

Add support for geographic objects, allowing you to run location queries in SQL

Pgcrypto

Encryption functions and hashing algorithms

Uuid-ossp

UUID generation functions

​
Search and Indexing

Bloom

Probabilistic index that can be useful for columns with many distinct values

Btree_Gin

GIN index support for B-tree indexable data types.

Btree_Gist

GiST index support for B-tree indexable data types.

Citext

Case-insensitive text type

Fuzzystrmatch

Functions for fuzzy string matching

Pg_bigm

Full-text search using bigrams

Pg_similarity

Text similarity measures in PostgreSQL

Pg_trgm

Similarity search in PostgreSQL using trigrams

Prefix

Prefix search functionality

​
Statistical and Analytical

Cube

Data type for multi-dimensional cubes

Financial

Specialized function for computing the Irregular Internal Rate of Return (XIRR)

Hll

HyperLogLog++ algorithm for estimating the number of unique elements in a set

Intagg

Integer aggregator and enumerator functions

Intarray

Functions and operators for integer arrays

Quantile

Efficient quantile and percentile calculations

Random

Random data generator extension with wide range of data types

Tablefunc

Cross tabulation and pivot operations

Xicor

Incremental correlation calculations in PostgreSQL

​
Geospatial

Earthdistance

Functions for calculating great-circle distances between points on Earth.

H3

Spatial indexing system developed by Uber

H3_PostGIS

Extends H3 functionality with PostGIS integration

Pgrouting

Geospatial routing extension for PostgreSQL

Postgis_raster

Raster Data Support for PostGIS

​
Data Types and Storage

Emailaddr

specialized data type for storing and validating email addresses

Hstore

Store key-value pairs within a single PostgreSQL value

Ip4r

IPv4 and IPv6 types and range operations

Isn

International Standard Number data types

Ltree

Hierarchical tree-like structures in PostgreSQL databases

Rdkit

Chemical structure types and functions

Seg

Line segment and floating-point interval data type

Unit

SI unit conversion and dimensional analysis

Was this page helpful?

CompatibilityPgvector