postgresql
A TypeScript ORM for Majestic Monoliths and PostgreSQL.
Related contents:
🗄 CLI tool for backup your databases, files to cloud storages in schedully.
GoBackup is a backup tool design for application servers, to backup your databases, files to cloud storages (FTP, SCP, S3, GCS, Aliyun OSS ...) in schedully.
Related contents:
Easy-to-run demo of a CDC pipeline using Debezium (Kafka Connect), PostgreSQL, Redpanda, and ClickHouse.
pglinter is a PostgreSQL extension that analyzes your database for potential issues, performance problems, and best practice violations. Written in Rust using pgrx, it provides deep integration with PostgreSQL for efficient database analysis.
Effortless database administration tool.
Onedump is a database administration tool that streamlines backup and restore tasks across multiple databases and storage destinations.
Database Backup Management Tool. Backup your databases with ease.
Automated scheduling, monitoring, and recovery for PostgreSQL, MySQL, and MongoDB. A self-hosted database backup management tool. Schedule automated backups, monitor status, and manage multiple databases from one place.
Logical multi-master PostgreSQL replication.
Postgres is the endgame database. Gel supercharges it with a modern data model, graph queries, Auth & AI solutions, and much more.
Gel is a new kind of database that takes the best parts of relational databases, graph databases, and ORMs. We call it a graph-relational database.
Related contents:
🐦🔥 Modernize your database by moving to PostgreSQL.
Related contents:
Real-Time Event Streaming Platform. Streaming CDC, stream processing, low-latency serving, and Iceberg management.
RisingWave is a real-time event streaming platform designed to offer the simplest and most cost-effective way to process, analyze, and manage real-time event data — with built-in support for the Apache Iceberg™ open table format. It provides both a Postgres-compatible SQL interface and a DataFrame-style Python interface.
RisingWave can ingest millions of events per second, continuously join and analyze live streams with historical data, serve ad-hoc queries at low latency, and persist fresh, consistent results to Apache Iceberg™ or any other downstream system.
Related contents:
Validate database backup files before migration to prevent costly failures.
BackupGuardian is a comprehensive tool for validating database backup files through deep structural analysis and integrity checking. Get confidence in your migrations before they matter.
Terraform without the state file bottleneck.
Stategraph replaces the flat state file with a database-backed graph. Independent changes can run in parallel, and the state becomes queryable and auditable. No code changes.
Related contents:
Terraform-style, declarative schema migration for Postgres.
pgschema is a CLI tool that brings terraform-style declarative schema migration workflow to Postgres.
DuckDB-powered Postgres for high performance apps & analytics. :
pg_duckdb integrates DuckDB's columnar-vectorized analytics engine into PostgreSQL, enabling high-performance analytics and data-intensive applications.
Related contents:
A PostgreSQL SQL syntax beautifier that can work as a console program or as a CGI.
This SQL formatter/beautifier supports keywords from SQL-92, SQL-99, SQL-2003, SQL-2008, SQL-2011 and PostgreSQL specifics keywords. Works with any other databases too.
Take the fear out of schema changes. Zero-downtime, reversible, schema changes for PostgreSQL.
Update your PostgreSQL schema without downtime or complex rollbacks. pgroll automates data backfills and simultaneously supports old and new schemas as you roll out your application.
pgEdge is the open source Enterprise Postgres company.
pgEdge delivers PostgreSQL solutions for maximum high availability, ultra-low latency, zero downtime maintenance, and data residency across deployment options and cloud regions. Single instances can be scaled up to active-active (multi-master) distributed deployments in a matter of minutes, giving you the freedom and flexibility to shift your data needs for your business instantly.
Related contents:
A Model Context Protocol server that provides read-only access to PostgreSQL databases. This server enables LLMs to inspect database schemas and execute read-only queries.
Related contents:
The fastest PostgreSQL JS driver written in TypeScript.
A PostgreSQL driver for Node.js written in TypeScript. It fully implements Pipeline Mode. Pgline delivers exceptionally high performance in concurrent queries. It offers faster speed and lower database CPU usage.
A horizontally scalable Postgres architecture that supports multi-tenant, highly-available and globally distributed deployments, all while staying true to standard Postgres.
Multigres is a project to build an adaptation of Vitess for Postgres.
Related contents:
the world’s fastest and most scalable cloud databases.
PlanetScale brings you the fastest databases available in the cloud. Both our Postgres and Vitess databases deliver exceptional speed and reliability, with Vitess adding ultra scalability through horizontal sharding.
Related contents:
Multi-DBMS SQL Benchmarking Framework via JDBC.
BenchBase (formerly OLTPBench) is a Multi-DBMS SQL Benchmarking Framework via JDBC.
Related contents:
Open-Source SaaS Starter.
🔥 GEO-powered SaaS starter built with Firecrawl for brand monitoring, auth, and billing.
Get your SaaS running in minutes with authentication, billing, AI chat, and brand monitoring. Zero-config setup with Next.js 15, TypeScript, and PostgreSQL.
Related contents:
pgactive is a PostgreSQL replication extension for creating an active-active database.
PostgreSQL replication with DDL changes.
pgstream is an open source CDC command-line tool and library that offers Postgres replication support with DDL changes to any provided target.
Related contents:
Javascript Language Plugin for PostreSQL.
PLJS is a trusted JavaScript Language Extension for PostgreSQL.
It is compact, lightweight, and fast.
AI-powered Postgres Client. cursor for data ⚡️ - explore your postgresql db in seconds.
Neon: Serverless Postgres. We separated storage and compute to offer autoscaling, code-like database branching, and scale to zero.
Neon is a serverless Postgres platform designed to help you build reliable and scalable applications faster. We separate compute and storage to offer modern developer features such as autoscaling, branching, instant restore, and more.
Related contents:
Client reports for your team and clients.
Open-source web platform used to create live reporting dashboards from APIs, MongoDB, Firestore, MySQL, PostgreSQL, and more 📈📊
Scale PostgreSQL horizontally. Postgres scales with PgDog. Horizontal scaling for PostgreSQL with automatic sharding.
PgDog is the missing routing layer for PostgreSQL. It moves data between nodes and directs query traffic, transparently to the application.
PgDog is a transaction pooler and logical replication manager that can shard PostgreSQL. Written in Rust, PgDog is fast, secure and can manage hundreds of databases and hundreds of thousands of connections.
Related contents:
A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB, Elastic Search, and Clickhouse with Chat interface
The last bastion
Secure access to your internal SSH, HTTPS, MySQL and Postgres servers with SSO and RBAC.
Related contents:
PostgreSQL Model Context Protocol (PG-MCP) Server.
A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.
A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.
Related contents:
Fastest way to Replicate your Database data in Data Lake. OLake makes data replication faster by parallelizing full loads, leveraging change streams for real-time sync, and pulling data in a database-native format for efficient ingestion.
Fastest open-source tool for replicating Databases to Apache Iceberg or Data Lakehouse. ⚡ Efficient, quick and scalable data ingestion for real-time analytics. Supporting Postgres, MongoDB and MySQL
Related contents:
The fastest Postgres change data capture.
Stream data from Postgres directly to Kafka, Redis, and more. Replace complex tools like Debezium and consolidate workflows.
Related contents:
A ledger implementation in PostgreSQL.
Related contents:
1000x Faster Analytics in Postgres. Postgres-native Data Warehouse.
pg_mooncake is a Postgres extension that adds columnar storage and vectorized execution (DuckDB) for fast analytics within Postgres. Postgres + pg_mooncake ranks among the top 10 fastest in ClickBench.
Postgre SQL Operator for Kubernetes. Run PostgreSQL. The Kubernetes way.
CloudNativePG is the Kubernetes operator that covers the full lifecycle of a highly available PostgreSQL database cluster with a primary/standby architecture, using native streaming replication.
Related contents:
Fast, Simple and a cost effective tool to replicate data from Postgres to Data Warehouses, Queues and Storage.
PeerDB is an ETL/ELT tool built for PostgreSQL. We implement multiple Postgres native and infrastructural optimizations to provide a fast, reliable and a feature-rich experience for moving data in/out of PostgreSQL.
Related contents:
SQL Indexing and Tuning e-Book for developers. Use The Index, Luke covers Oracle, MySQL, PostgreSQL, SQL Server, ...
A site explaining SQL indexing to developers—no crap about administration. SQL indexing is the most effective tuning method—yet it is often neglected during development. Use The Index, Luke explains SQL indexing from grounds up and doesn’t stop at ORM tools like Hibernate.
A PostgreSQL assistant for developers designed to help understand and optimize PostgreSQL database performance.
PgAssistant is an open-source tool designed to help developers understand and optimize their PostgreSQL database performance. It provides insights into database behavior, identifies schema-related issues, and assists in correcting them. Additionally, PgAssistant makes it easy to manage a library of specific SQL queries useful for your project through a simple JSON file.
DocumentDB offers a native implementation of document-oriented NoSQL database, enabling seamless CRUD operations on BSON data types within a PostgreSQL framework. Powering vCore-based Azure Cosmos DB for MongoDB.
Related contents:
Visualizing and understanding PostgreSQL EXPLAIN plans made easy.
A VueJS component to show a graphical vizualization of a PostgreSQL execution plan.
review Postgres query plans quickly.
A simple yet powerful tool to help you speed up queries. pgMustard speeds up your journey from knowing which query is a problem to working out what can be done about it.
A native MacOS Postgres client.
Searchlight is a native macOS, open-source PostgreSQL client designed to be simple, lightweight, and developer-friendly. It offers a clean and intuitive interface for managing databases and running queries without the complexity of full-scale database management tools. Searchlight focuses on delivering a smooth and efficient experience for developers who need quick and easy access to their PostgreSQL databases.
Ultra-Lightweight Durable Execution in TypeScript. DBOS Transact: A Lightweight Durable Execution Library Built on Postgres.
Durable execution means persisting the execution state of your program while it runs, so if it is ever interrupted or crashes, it automatically resumes from where it left off. Durable execution helps solve many common problems:
Incremental Data Processing in PostgreSQL.
pg_incremental is a simple extension that helps you do fast, reliable, incremental batch processing in PostgreSQL.
When storing an append-only stream of event data in PostgreSQL (e.g. IoT, time series), a common challenge is to process only the new data. For instance, you might want to create one or more summary tables containing pre-aggregated data, and insert or update aggregates as new data arrives. However, you cannot really know the data that is still being inserted by concurrent transactions, and immediately aggregating data when inserting (e.g. via triggers) is certain to create a concurrency bottleneck. You also want to make sure that all new events are processed successfully exactly once, even when queries fail.
SQL language server written in Go.
sqls aims to provide advanced intelligence for you to edit sql in your own editor.
Build Reliable Backends 10x Faster, Scale to Millions with 1 Click.
DBOS is a serverless platform for building highly reliable applications. What takes days to build on AWS takes minutes on DBOS.
Related contents:
How to reduce complexity and move faster? Just Postgres for everything.
The goal of this repository is to demonstrate how to use Postgres for Everything.
Powerful Database Client.
Outerbase Studio is a fully-featured, lightweight GUI client for managing Turso, LibSQL, Cloudflare D1, rqlite, MySQL, and PostgreSQL. It runs entirely in your browser, so there's no need to download anything.
The world's most advanced open source database.
Related contents:
- What I Wish Someone Told Me About Postgres @ ChallahScript.
- Logical replication in Postgres: Basics @ EDB.
- Database sharding case study: PostgreSQL @ The Polymathic Engineer.
- I Tried Every Open Source Database and Found Only One That is Actually Useful @ Hacker Noon.
- How direct TLS can speed up your connections @ Marc Bowes.
- PostgreSQL pour remplacer Redis @ Rodolphe Bréard :fr:.
- One more reason to choose Postgres over MySQL @ tanin.
- From 99.9% to 99.99%: Building PostgreSQL Resilience into Your Product Architecture @ Stormatics.
- Handling unique indexes on large data in PostgreSQL @ Volodymyr Potiichuk.
- Postgres Internals Deep Dive: Process Architecture @ EDB Postgres.
- PostgreSQL maintenance without superuser @ boringSQL.
- Postgres’ Original Project Goals: The Creators Totally Nailed It @ Chunchy Data.
- Redis is fast - I'll cache in Postgres @ Dizzy zone.
- PostgreSQL MVCC Explained (Simply!) @ SauravDhakal's Substack.
- Postgres Partitioning Best Practices: Sofia's Story @ Karen Jex.
- Tuning AIO in PostgreSQL 18 @ Tomas Vondra.
- Advanced PostgreSQL Indexing: Multi-Key Queries and Performance Optimization @ Frontend Masters.
- The best worst hack that saved our bacon @ Jefferson Heard.
- Going down the rabbit hole of Postgres 18 features @ xata.
- JIT: so you want to be faster than an interpreter on modern CPUs… @ Pinaraf's website.
- Postgres 18: OLD and NEW Rows in the RETURNING Clause @ crunchy data.
- Benchmarking Postgres 17 vs 18 @ PlanetScale.
- Is Postgres Read Heavy or Write Heavy? (And Why You Should You Care) @ crunchy data.
- Pipelining in psql (PostgreSQL 18) @ PostgreSQL Notes - Daniel Vérité.
An Object-Document Mapper (ODM) for Doctrine ORM leveraging new JSON types of modern RDBMS.
PoWA is a PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graphs to help monitor and tune your PostgreSQL servers.