> ## 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 Don't see an extension you need? Let us know by creating a GitHub issue. ## Featured Extensions Perform vector similarity search and build AI-powered features Add support for geographic objects, allowing you to run location queries in SQL Encryption functions and hashing algorithms UUID generation functions ## Search and Indexing Probabilistic index that can be useful for columns with many distinct values GIN index support for B-tree indexable data types. GiST index support for B-tree indexable data types. Case-insensitive text type Functions for fuzzy string matching DiskANN index support for pgvector Full-text search using bigrams Text similarity measures in PostgreSQL Similarity search in PostgreSQL using trigrams Prefix search functionality ## Statistical and Analytical Data type for multi-dimensional cubes Specialized function for computing the Irregular Internal Rate of Return (XIRR) HyperLogLog++ algorithm for estimating the number of unique elements in a set Integer aggregator and enumerator functions Functions and operators for integer arrays Efficient quantile and percentile calculations Random data generator extension with wide range of data types Cross tabulation and pivot operations Incremental correlation calculations in PostgreSQL ## Geospatial Functions for calculating great-circle distances between points on Earth. Spatial indexing system developed by Uber Extends H3 functionality with PostGIS integration Geospatial routing extension for PostgreSQL Raster Data Support for PostGIS ## Data Types and Storage specialized data type for storing and validating email addresses Store key-value pairs within a single PostgreSQL value IPv4 and IPv6 types and range operations International Standard Number data types Hierarchical tree-like structures in PostgreSQL databases Chemical structure types and functions Line segment and floating-point interval data type SI unit conversion and dimensional analysis