Postgres for Everything (e/postgres)
Keep It Simple Stupid, just use postgres. epostgres.com
The goal of this repository is to demonstrate how to use Postgres for Everything.
It's inspired by this article
from the Amazing CTO as well as
this GitHub gist
from @cpursley.
It seems like every week I hear of a new tool on top of Postgres or another way
it can being used, so I wanted a place where I can keep track of everything. If
you have other examples, submit a PR.
If you have a specific code snippet, tool or project that you'll like to showcase
as an example, put up a PR with a link! Make sure to use the new pull request template.
- PGLite: WASM Postgres build packaged into a TypeScript library (< 10MB) that can run in the browser, Node.js, Bun and Deno. It's lightweight, reactive and sync live.
- pgmicro: An in-process reimplementation of PostgreSQL, backed by a SQLite-compatible storage engine.
- tembo-io/pgmq
- SKIP LOCKED
- riverqueue/river
- sequinstream/sequin: Sequin is a tool for change data capture (CDC) in Postgres. Sequin makes it easy to stream Postgres rows and changes to streaming platforms and queues (e.g. Kafka and SQS). You can backfill existing rows and stream new changes in real-time.
- janbjorge/pgqueuer: PgQueuer is a Python library leveraging PostgreSQL for efficient job queuing.
- timgit/pg-boss: pg-boss is a job queue built in Node.js
- smartpricing/queen: PostgreSQL-backed message queue with unlimited independent FIFO partitions, Kafka-style consumer groups, and exactly-once delivery. Also available as a native PostgreSQL extension.
- NikolayS/pgque: Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
Access Control & Authorization
- pgvector/pgvector
- tensorchord/VectorChord: PostgreSQL extension designed for scalable, high-performance, and disk-efficient vector similarity search. It serves as the successor to the pgvecto.rs project.
- timescale/pgai: PostgreSQL extension to allow RAG, semantic search and other AI application development from within postgres. Based on pgvector.
- timescale/pgvectorscale: DiskANN vector index implementation complementary to pgvector.
- plpgsql_bm25rrf.sql: Hybrid search (BM25+pgvector) with Reciprocal Rank Fusion implemented in PL/pgSQL
- Apache Age: Graph Database for PostgreSQL to provide graph data processing and analytics capability to all relational databases.
GraphQL and Alternative Query Languages
- PostGraphile: Extensible high-performance automatic GraphQL API for PostgresSQL
- supabase/pg_graphql: PostgreSQL extension that enables querying the database with GraphQL using a single SQL function
- dosco/graphjin: GraphJin automatically converts GraphQL into SQL queries
- kaspermarstal/plprql: PostgreSQL extension to write functions using PRQL (Pipelined Relational Query Language)
- StatsMgr: Efficient and organized management of statistics across WAL, SLRU, checkpointing, & more. Currently supports dynamic initialization, shared memory utilization, and SQL interfaces.
- pgMonitor: A monitoring solution that visualizes metrics using Prometheus, Grafana, SQL Exporter, and the pgMonitor extension.
- regresql: A tool implement a regression testing facility for SQL queries with support for the PostgreSQL database system.
User Interfaces & Dashboards
- Baserow
- NocoDB
- AppSmith
- mathesar-foundation/mathesar: Intuitive spreadsheet-like interface that lets users of all technical skill levels view, edit, query, and collaborate on Postgres data directly—self hosted, with native Postgres access control.
- dbcli/pgcli: Postgres client that does auto-completion and syntax highlighting.
- sosedoff/pgweb: Simple web-based and cross platform PostgreSQL database explorer.
- Maxteabag/sqlit: A user friendly TUI (e.g. like lazysql) for any SQL databases including PostgreSQL.
- dr-jts/pg_svg: Collection of PostgreSQL functions to create SVG graphics intended to convert PostGIS geometries into styled SVG documents
- Evidence
- Metabase
- Hopara: Platform for real-time data visualization intended for Manufacturing, IoT, Life Science and Data Lakes.
- posit-dev/ggsql: A SQL extension for declarative data visualisation based on the Grammar of Graphics.
- supabase/postgres-language-server: A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.
Data Privacy & Security (or Data Masking)
- pgledger: A double entry ledger implementation in PostgreSQL
gem-hunter