Extensions & Plugins

UUID generation functions (gen_random_uuid, uuid_generate_v4).

Cryptographic functions: hashing, encryption, random data.

Track planning and execution statistics for all SQL statements.

Vector similarity search for AI embeddings. Supports L2, cosine and inner product distance.

Spatial and geographic objects and functions for PostgreSQL.

Cron-based job scheduler running inside PostgreSQL.

JSON Web Token generation and verification functions in SQL.

JSON Schema validation for JSONB columns as constraints.

Hypertables and continuous aggregates for time-series data at scale.

PL/pgSQL procedural language (built-in, always enabled).

HTTP client for PostgreSQL — make HTTP requests from SQL.

Detailed session and object audit logging for compliance.