Postgres extension explorer

Tokenize data in Postgres using the OpenAI tiktoken library

Scalable vector similarity search for RAG and semantic search

Store vector embeddings and perform vector similarity search in Postgres

Adds columnstore tables and DuckDB execution for fast analytics in Postgres.

Implements a HyperLogLog data structure as a native data type for efficient and tunable distinct value counting

Enables Postgres as a time-series database for efficient storage and retrieval of time-series data

Implements a trigger that stores the current user's name into a text field, useful for tracking who modified a particular row within a table

Implements a trigger that automatically updates a timestamp column to the current timestamp whenever a row is modified

Provides a function that shows row locking information for a specified table, useful in concurrency and deadlock debugging

Provides a trigger function to notify listeners of changes to a table, allowing applications to respond to changes in the database

A single-line address parser that takes an input address and normalizes it based on a set of rules

Provides data for standardizing US addresses, for use with the address_standardizer extension

Provides data masking and anonymization capabilities for protecting personally identifiable information (PII) and sensitive data in Postgres databases

Provides a case-insensitive character string type that internally calls lower when comparing values in Postgres

Implements the cube data type for representing multidimensional cubes in Postgres

Provides cube-based and point-based approaches to calculating great circle distances on the surface of the Earth

Implements an hstore data type for storing and manipulating sets of key-value pairs within a single Postgres value

Provides an integer aggregator and enumerator for Postgres

Offers functions and operators for manipulating and searching arrays of integers within Postgres

Implements data types for international product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), and ISSN (serials)

Provides data types for representing labels of data stored in a hierarchical tree-like structure and facilities for searching through label trees

Adds GraphQL support to Postgres, allowing you to query your database via GraphQL

Enables the generation of short, unique hash ids from integers, useful for obfuscating internal ids

Provides support for JSON schema validation on json and jsonb data types

Enables creating valid UUID Version 7 values in Postgres, enabling globally unique identifiers with temporal ordering

A full-featured extension for generating and working with ULID (Universally Unique Lexicographically Sortable Identifiers)

Implements the seg data type for storage and manipulation of line segments or floating-point ranges, useful for geometric and scientific applications

A Postgres data type for the Semantic Version format with support for btree and hash indexing

Contains functions that return tables (multiple rows), including crosstab, which can pivot row data into columns dynamically

A text search dictionary that removes accents from characters, simplifying text search in Postgres

Implements a data type for SI units, plus byte, for storage, manipulation, and calculation of scientific units

Provides functions to generate universally unique identifiers (UUIDs) in Postgres, supporting various UUID standards

A Postgres logical decoding plugin that converts Write-Ahead Log (WAL) changes into JSON objects

Enables XPath queries and XSLT functionality directly within Postgres, enabling XML data processing

Automatically updates a timestamp column to the current timestamp whenever a row is modified in Postgres

Provides a function that shows row locking information for a specified table, which can aid in concurrency and deadlock debugging

A unit testing framework for Postgres, enabling sophisticated testing of database queries and functions

Provides a linter and debugger for PL/pgSQL code, helping identify errors and optimize PL/pgSQL functions

Implements a data type for representing multidimensional cubes in Postgres

Provides cube-based and point-based approaches to calculating great circle distances on the surface of the Earth

Integrates Uber's H3 geospatial indexing system that combines the benefits of a hexagonal grid with S2's hierarchical subdivisions

A PostGIS extension for H3, enabling advanced spatial analysis and indexing

Extends PostGIS/Postgres databases, providing geospatial routing and other network analysis functionality

Extends Postgres to allow GIS (Geographic Information Systems) objects to be stored in the database, enabling spatial queries directly in SQL

Adds support for raster data to PostGIS, enabling advanced geospatial analysis on raster images

Provides support for advanced 3D geometries in PostGIS, based on the SFCGAL library

Enables geocoding and reverse geocoding capabilities in PostGIS using TIGER/Line data

Extends PostGIS with support for topological data types and functions, facilitating the analysis of spatial relationships

Provides an index access method for Postgres based on Bloom filters

Provides GIN operator classes that implement B-tree equivalent behavior

Provides GiST index operator classes that implement B-tree equivalent behavior

Provides a range index type and functions for efficiently storing and querying IPv4 and IPv6 ranges and addresses in Postgres

A partition manager extension that enables creating and managing time-based and number-based table partition sets in Postgres

Allows manual preloading of relation data into the Postgres buffer cache, reducing access times for frequently queried tables

Lets you remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes

Implements Roaring Bitmaps in Postgres for efficient storage and manipulation of bit sets

Provides an access method to work with a RUM index, designed to speed up full-text searches

Provides functions and views designed to gather Neon-specific metrics

Tracks planning and execution statistics for all SQL statements executed, aiding in performance analysis and tuning

Offers functions to show tuple-level statistics for tables, helping identify bloat and efficiency opportunities

Provides a table sampling method that selects a fixed number of table rows randomly

Offers a table sampling method based on system time, enabling consistent sample data retrieval over time

Provides a trigger function to notify listeners of changes to a table, allowing applications to respond to changes in the database

A partition manager extension that enables creating and managing time-based and number-based table partition sets in Postgres

Enables writing functions in CoffeeScript, a Javascript dialect with a syntax similar to Ruby

Enables writing functions in LiveScript, a Javascript dialect that serves as a more powerful successor to CoffeeScript

Deprecated on Neon. Was a Postgres procedural language powered by V8 for JavaScript callable from SQL; use plpgsql or app-side logic instead

The default procedural language for Postgres, enabling the creation of complex functions and triggers

Provides the ability to create hypothetical (virtual) indexes in Postgres for performance testing

Allows developers to influence query plans with hints in SQL comments, improving performance and control over query execution

Recommends indexes, extended statistics, and prepared statements based on your actual query workload

Implements the cube data type for representing multidimensional cubes in Postgres

Integrates the RDKit cheminformatics toolkit with Postgres, enabling chemical informatics operations directly in the database

Implements the seg data type for storage and manipulation of line segments or floating-point intervals, useful for representing laboratory measurements

Implements a data type for SI units, plus byte, for storage, manipulation, and calculation of scientific units

Provides a case-insensitive character string type that internally calls lower when comparing values in Postgres

Provides a text search dictionary template for indexing integer data in Postgres

Provides several functions to determine similarities and distance between strings in Postgres

BM25 keyword and full-text search for Postgres, compatible with tsvector

Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, and index operator classes for fast string similarity search

A prefix range module that supports efficient queries on text columns with prefix-based searching and matching capabilities

A text search dictionary that removes accents from characters, simplifying text search in Postgres

Provides data masking and anonymization capabilities for protecting personally identifiable information (PII) and sensitive data in Postgres databases

Handle authenticated sessions through JWTs for use with RLS policies

Offers cryptographic functions, allowing for encryption and hashing of data within Postgres

Implements JSON Web Tokens (JWT) in Postgres, allowing for secure token creation and verification

Provides an autoinc() function that stores the next value of a sequence into an integer field

Provides the ability to create hypothetical (virtual) indexes in Postgres for performance testing

Automatically inserts the username of the person executing an insert operation into a specified table in Postgres

Provides support for managing large objects (LOBs) in Postgres, including a data type lo and a trigger lo_manage

Provides a function for monitoring how Neon's Autoscaling feature allocates compute resources in response to workload

Lets you schedule and manage periodic jobs directly in your Postgres database

A unit testing framework for Postgres, enabling sophisticated testing of database queries and functions

Provides functions for maintaining foreign key constraints

Provides functions for accessing and manipulating data in remote databases from within Postgres

Access data in remote Postgres databases as local tables