PostgreSQL Tools Directory

PostgreSQL extensions and software for search, queues, vectors, caching, analytics, and more. Find the right tool for your use case.

Showing 84 of 84 tools

PGMQ

extension

Need a simple, durable message queue?

A lightweight message queue built on Postgres with at-least-once delivery and visibility timeout

Replaces: Redis SQS RabbitMQ

pgflow

software

Need multi-step workflows with retries?

Workflow orchestration engine for Supabase built on pgmq with automatic retries and parallelism

Replaces: Temporal Inngest n8n

Graphile Worker

software

Need reliable background job processing?

High-performance job queue for Node.js using PostgreSQL SKIP LOCKED

Replaces: Sidekiq Bull Celery

pg-boss

software

Need job scheduling with retries?

Job queue for Node.js built on PostgreSQL with exponential backoff and scheduling

Replaces: Agenda Bull

pg_cron

extension

Need scheduled database maintenance or jobs?

Run periodic jobs inside PostgreSQL using cron syntax

pg_timetable

software

Need complex job workflows?

Advanced job scheduler with chaining, conditions, and remote execution

River

software

Need background jobs in Go?

Fast, reliable background jobs for Go using Postgres SKIP LOCKED

Replaces: Sidekiq Celery

Oban

software

Need background jobs in Elixir?

Robust job processing for Elixir using Postgres

Replaces: Sidekiq Celery

ParadeDB

software

Need Elasticsearch-grade full-text search?

Postgres-native search and analytics with BM25 scoring

Replaces: Elasticsearch Solr

PGroonga

extension

Need multilingual full-text search?

Full-text search extension supporting all languages with fast index updates

Replaces: Elasticsearch

pg_search

extension

Need modern full-text ranking?

Postgres extension for BM25 full-text search from ParadeDB

Replaces: Elasticsearch

ZomboDB

extension

Need to query Elasticsearch from SQL?

Bridge between Postgres and Elasticsearch for hybrid queries

pgvector

extension

Need vector embeddings for AI/RAG?

Open-source vector similarity search for Postgres

Replaces: Pinecone Milvus Qdrant Weaviate

pgvectorscale

extension

Need high-performance vector search at scale?

Faster vector search with StreamingDiskANN index from Timescale

Replaces: Pinecone

Lantern

extension

Need fast approximate nearest neighbor search?

Vector database extension with HNSW indexing

Replaces: Pinecone Milvus

pgai

extension

Need to run AI pipelines in the database?

AI workflows directly in Postgres - embeddings, LLM calls, RAG

PostgresML

extension

Need to run ML models in the database?

ML and AI workflows directly in Postgres with GPU acceleration

Replaces: External ML services

TimescaleDB

extension

Need to store and query time-series data?

Time-series database built on PostgreSQL with automatic partitioning

Replaces: InfluxDB Prometheus QuestDB

pg_partman

extension

Need to manage time-based partitions?

Automatic table partitioning management

ReadySet

software

Need to cache query results automatically?

SQL caching engine that sits between your app and Postgres

Replaces: Redis Memcached

pg_ivm

extension

Need materialized views that update incrementally?

Incrementally maintained materialized views

FerretDB

software

Need MongoDB compatibility with Postgres storage?

MongoDB wire protocol compatible layer on top of Postgres

Replaces: MongoDB

Pongo

software

Need a document-oriented interface?

MongoDB-like API for Postgres using JSONB

Replaces: MongoDB

Dox

software

Need simple document storage?

Document database API for PostgreSQL

DocumentDB

software

Need MongoDB API with Postgres reliability?

MongoDB-compatible document database built on PostgreSQL

Replaces: MongoDB

Marten

software

Need document storage for .NET apps?

.NET document database and event store on PostgreSQL

Replaces: MongoDB RavenDB

Apache AGE

extension

Need graph queries and relationships?

Graph database extension with openCypher query support

Replaces: Neo4j Neptune

Gel (formerly EdgeDB)

software

Need a modern query language for complex data?

Graph-relational database built on Postgres with declarative schema and EdgeQL

Replaces: Neo4j

PostGIS

extension

Need location-based queries and maps?

Geographic objects and spatial queries for PostgreSQL

Replaces: MongoDB geospatial Elasticsearch geo

pgRouting

extension

Need shortest path or routing algorithms?

Routing and graph analysis extension for PostGIS

h3-pg

extension

Need efficient geospatial indexing?

H3 hexagonal hierarchical spatial index for Postgres

pg_analytics

extension

Need fast analytics on large datasets?

Accelerated analytics with columnar storage and vectorized execution

Replaces: ClickHouse Snowflake

Hydra

software

Need OLAP performance with Postgres compatibility?

Column-oriented Postgres for analytics workloads

Replaces: ClickHouse

Citus

extension

Need horizontal scaling for analytics?

Distributed Postgres for multi-tenant and real-time analytics

Replaces: Distributed databases

duckdb_fdw

extension

Need to query analytical files from Postgres?

Query DuckDB from Postgres via foreign data wrapper

pg_lake

extension

Need to access data lake files from SQL?

Query Iceberg tables and data lakes directly from Postgres

Replaces: Iceberg clients Data lake tools

Evidence

software

Need BI dashboards from SQL?

Build reports and dashboards with SQL and markdown

Replaces: Tableau Looker

Metabase

software

Need self-service analytics for your team?

Open source business intelligence and analytics

Replaces: Tableau Looker

WalEx

software

Need real-time database events in Elixir?

Elixir library for listening to Postgres write-ahead log changes via logical replication

Debezium

software

Need real-time data synchronization?

Stream database changes to Kafka and other systems

Replaces: Custom CDC solutions

PeerDB

software

Need to sync Postgres to Snowflake/BigQuery?

Fast Postgres replication to data warehouses

pglogical

extension

Need to replicate specific tables?

Logical replication for selective table sync

wal2json

extension

Need CDC events as JSON?

JSON output plugin for logical decoding

ElectricSQL

software

Need offline sync and local-first architecture?

Local-first sync for Postgres with real-time replication

PostgREST

software

Need a REST API without backend code?

Instant RESTful API from your PostgreSQL schema

Hasura

software

Need GraphQL without writing resolvers?

Instant GraphQL and REST APIs on Postgres

PostGraphile

software

Need flexible GraphQL with smart comments?

Highly customizable GraphQL API from Postgres schema

pg_graphql

extension

Need GraphQL queries directly in SQL?

Native GraphQL support inside PostgreSQL

Supabase

software

Need a complete backend platform?

Open source Firebase alternative with Postgres, Auth, and APIs

SQLPage

software

Need a web UI without backend code?

Build web applications entirely in SQL with built-in components

Omnigres

extension

Need to run your entire app in Postgres?

Turn Postgres into a complete application platform with web server

pgsql-http

extension

Need to call webhooks from triggers?

Make HTTP requests from PostgreSQL functions

pg_net

extension

Need non-blocking HTTP calls?

Async HTTP requests from Postgres with response handling

NocoDB

software

Need a spreadsheet UI for your database?

Open source Airtable alternative on Postgres

Replaces: Airtable

Baserow

software

Need a collaborative database interface?

Open source no-code database platform

Replaces: Airtable

Supabase Wrappers

extension

Need to query external APIs as tables?

Foreign data wrappers for Stripe, Firebase, Airtable, and 20+ services

GraphJin

software

Need auto-generated APIs from your schema?

Instant GraphQL and REST APIs with AI assistant support

pgjwt

extension

Need to handle JWTs in the database?

PostgreSQL extension for JWT generation and verification

pgcrypto

extension

Need encryption at the database level?

Cryptographic functions for PostgreSQL

Supabase Vault

extension

Need to store secrets securely?

Secrets management extension for Postgres

supa_audit

extension

Need to track who changed what?

Generic audit logging for Postgres tables

pgAudit

extension

Need SOC2/HIPAA audit trails?

Detailed session and object audit logging for compliance

pgMemento

extension

Need to see historical data states?

Complete audit trail with data versioning and time travel queries

Bemi

software

Need comprehensive audit trails for compliance?

Automatic audit logging with high reliability using CDC and WAL

Temporal Tables

extension

Need SQL:2011 temporal table support?

System-versioned temporal tables with automatic history tracking

pgroll

software

Need safe schema changes in production?

Zero-downtime schema migrations with automatic rollback

Atlas

software

Need infrastructure-as-code for your schema?

Database schema as code with declarative migrations

Sqitch

software

Need version-controlled database changes?

Database change management with dependency tracking

Bytebase

software

Need team collaboration on database changes?

Database DevOps with CI/CD and access control

pg-schema-diff

software

Need zero-downtime schema migrations?

Compute schema diffs and generate safe migration SQL

PgBouncer

software

Need to handle more connections?

Lightweight connection pooler for PostgreSQL

Supavisor

software

Need scalable multi-tenant connection pooling?

Cloud-native connection pooler written in Elixir

PgCat

software

Need read replicas and load balancing?

Connection pooler with query load balancing and sharding

Spock

extension

Need active-active replication?

Multi-master replication with conflict resolution

PGHero

software

Need to identify slow queries?

Performance dashboard for Postgres with index suggestions

HypoPG

extension

Need to evaluate index impact before creating?

Test indexes without creating them

Dexter

software

Need help choosing indexes?

Automatic index recommendations based on query analysis

index_advisor

extension

Need help finding missing indexes?

Automatic index recommendations based on query analysis

pg_hint_plan

extension

Need to override the query planner?

Control query execution plans with SQL hints

pgTAP

extension

Need to test database functions and schemas?

Unit testing framework for PostgreSQL with TAP output

PGLite

software

Need offline-first or local-first apps?

Run Postgres in the browser via WebAssembly

pgxman

software

Need easy extension installation?

npm-style package manager for Postgres extensions

dbdev

software

Need to share and install TLE packages?

Package manager for Postgres trusted language extensions

CloudNativePG

software

Need to run Postgres on Kubernetes?

Kubernetes operator for running PostgreSQL clusters

Missing something?

Add a tool by opening a pull request.

Contribute via PR