> ## Documentation Index
> Fetch the complete documentation index at: https://thenile.dev/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Introduction

> PostgreSQL Extension Store in Nile

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](https://console.thenile.dev), by navigating to
the `Extensions` tab on the left.

![Extensions in Nile's Console](https://mintcdn.com/nile/PVqSPvIIF-xsKfJe/images/extensions_in_console.png?fit=max\&auto=format\&n=PVqSPvIIF-xsKfJe\&q=85\&s=8a45b20caf3fcc5933adf81dbc1525f4)

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

Request New Extension

## Featured Extensions

> [card] [Pgvector](https://thenile.dev/docs/extensions/vector.md)
>
> Perform vector similarity search and build AI-powered features

> [card] [PostGIS](https://thenile.dev/docs/extensions/postgis.md)
>
> Add support for geographic objects, allowing you to run location queries in
> SQL

> [card] [Pgcrypto](https://thenile.dev/docs/extensions/pgcrypto.md)
>
> Encryption functions and hashing algorithms

> [card] [Uuid-ossp](https://thenile.dev/docs/extensions/uuid-ossp.md)
>
> UUID generation functions

## Search and Indexing

> [card] [Bloom](https://thenile.dev/docs/extensions/bloom.md)
>
> Probabilistic index that can be useful for columns with many distinct values

> [card] [Btree\_Gin](https://thenile.dev/docs/extensions/btree_gin.md)
>
> GIN index support for B-tree indexable data types.

> [card] [Btree\_Gist](https://thenile.dev/docs/extensions/btree_gist.md)
>
> GiST index support for B-tree indexable data types.

> [card] [Citext](https://thenile.dev/docs/extensions/citext.md)
>
> Case-insensitive text type

> [card] [Fuzzystrmatch](https://thenile.dev/docs/extensions/fuzzystrmatch.md)
>
> Functions for fuzzy string matching

> [card] [Pgvectorscale](https://thenile.dev/docs/extensions/pgvectorscale.md)
>
> DiskANN index support for pgvector

> [card] [Pg\_bigm](https://thenile.dev/docs/extensions/pg_bigm.md)
>
> Full-text search using bigrams

> [card] [Pg\_similarity](https://thenile.dev/docs/extensions/pg_similarity.md)
>
> Text similarity measures in PostgreSQL

> [card] [Pg\_trgm](https://thenile.dev/docs/extensions/pg_trgm.md)
>
> Similarity search in PostgreSQL using trigrams

> [card] [Prefix](https://thenile.dev/docs/extensions/prefix.md)
>
> Prefix search functionality

## Statistical and Analytical

> [card] [Cube](https://thenile.dev/docs/extensions/cube.md)
>
> Data type for multi-dimensional cubes

> [card] [Financial](https://thenile.dev/docs/extensions/financial.md)
>
> Specialized function for computing the Irregular Internal Rate of Return
> (XIRR)

> [card] [Hll](https://thenile.dev/docs/extensions/hll.md)
>
> HyperLogLog++ algorithm for estimating the number of unique elements in a
> set

> [card] [Intagg](https://thenile.dev/docs/extensions/intagg.md)
>
> Integer aggregator and enumerator functions

> [card] [Intarray](https://thenile.dev/docs/extensions/intarray.md)
>
> Functions and operators for integer arrays

> [card] [Quantile](https://thenile.dev/docs/extensions/quantile.md)
>
> Efficient quantile and percentile calculations

> [card] [Random](https://thenile.dev/docs/extensions/random.md)
>
> Random data generator extension with wide range of data types

> [card] [Tablefunc](https://thenile.dev/docs/extensions/tablefunc.md)
>
> Cross tabulation and pivot operations

> [card] [Xicor](https://thenile.dev/docs/extensions/xicor.md)
>
> Incremental correlation calculations in PostgreSQL

## Geospatial

> [card] [Earthdistance](https://thenile.dev/docs/extensions/earthdistance.md)
>
> Functions for calculating great-circle distances between points on Earth.

> [card] [H3](https://thenile.dev/docs/extensions/h3.md)
>
> Spatial indexing system developed by Uber

> [card] [H3\_PostGIS](https://thenile.dev/docs/extensions/h3_postgis.md)
>
> Extends H3 functionality with PostGIS integration

> [card] [Pgrouting](https://thenile.dev/docs/extensions/pgrouting.md)
>
> Geospatial routing extension for PostgreSQL

> [card] [Postgis\_raster](https://thenile.dev/docs/extensions/postgis_raster.md)
>
> Raster Data Support for PostGIS

## Data Types and Storage

> [card] [Emailaddr](https://thenile.dev/docs/extensions/emailaddr.md)
>
> specialized data type for storing and validating email addresses

> [card] [Hstore](https://thenile.dev/docs/extensions/hstore.md)
>
> Store key-value pairs within a single PostgreSQL value

> [card] [Ip4r](https://thenile.dev/docs/extensions/ip4r.md)
>
> IPv4 and IPv6 types and range operations

> [card] [Isn](https://thenile.dev/docs/extensions/isn.md)
>
> International Standard Number data types

> [card] [Ltree](https://thenile.dev/docs/extensions/ltree.md)
>
> Hierarchical tree-like structures in PostgreSQL databases

> [card] [Rdkit](https://thenile.dev/docs/extensions/rdkit.md)
>
> Chemical structure types and functions

> [card] [Seg](https://thenile.dev/docs/extensions/seg.md)
>
> Line segment and floating-point interval data type

> [card] [Unit](https://thenile.dev/docs/extensions/unit.md)
>
> SI unit conversion and dimensional analysis


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.