postgresql
An in-process reimplementation of PostgreSQL, backed by a SQLite-compatible storage engine.
pgmicro is built as an experimental fork of Turso — a full from-scratch rewrite of SQLite in Rust — with PostgreSQL added as a native dialect. The result is a fast, embeddable, single-file database that speaks PostgreSQL.
The opinionated framework for easily creating typesafe data layers. End-to-end typesafe data fetching for frontend teams at scale.
Migrate to PostgreSQL in a single command!
pgloader loads data into PostgreSQL and allows you to implement Continuous Migration from your current database to PostgreSQL. Read the White Paper to learn how to limit risks and control your budget, and start your PostgreSQL migration today!
The secure CMS.
Geeklog is an open source application for managing dynamic web content. It is written in PHP and supports MySQL or PostgreSQL as the database backend.
"Out of the box", it is a blog engine, or a CMS with support for comments, trackbacks, multiple syndication formats, spam protection, and all the other vital features of such a system.
PostgreSQL et son fichier de configuration de 17 Ko sur 503 lignes : rien de moins que 180 et quelques paramètres. Cela n’aide clairement pas un débutant à se lancer. Pourtant, il faut savoir que seule une grosse dizaine de paramètres sont essentiels à configurer. Le reste n’a pour cible que les cas très particuliers.
FerretDB is an open-source proxy, converting the MongoDB 6.0+ wire protocol queries to SQL - using PostgreSQL as a database engine.
The Open Source Firebase Alternative with GraphQL
Nhost is an open-source backend and development platform that enables developers to build and scale their web and mobile apps.
Related contents:
25 MB lightweight cross-platform database client for 100+ databases, including MySQL, PostgreSQL, SQLite, Redis, MongoDB, DuckDB, SQL Server, and Dameng. Built-in AI, MCP Server, CLI, desktop and Docker.
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:
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.
A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.
Related contents:
Visual SQL Logic Mapper.
actuallyEXPLAIN is a visualizer that helps you understand logical intent in complex PostgreSQL queries in a diagram and dictionarized form.
Zero-ETL data analytics with Postgres.
Simple and cost-effective cloud analytics platform automatically synced with your data sources.
BemiDB is a Postgres read replica optimized for analytics. It consists of a single binary that seamlessly connects to a Postgres database, replicates the data in a compressed columnar format, and allows you to run complex queries using its Postgres-compatible analytical query engine.
PostgreSQL log analyzer.
pgBadger is a PostgreSQL log analyzer built for speed with fully detailed reports and professional rendering.
FerretDB allows you to use MongoDB drivers seamlessly with PostgreSQL as the database backend. Use all tools, drivers, UIs, and the same query language and stay open-source.
Self-Hosted Database & File Backup Automation.
Self-hosted backup automation for databases and files, with encryption, compression, and smart retention. Self-hosted backup automation for databases and files. Supports MySQL, PostgreSQL, MongoDB, MSSQL, Redis, Valkey, MariaDB, SQLite & Firebird, plus full directory backups with incremental snapshots. Encrypts and compresses to S3, FTP, SFTP, WebDAV, SMB, Dropbox, Google Drive & more, with retention policies and web-based restores.
a database management tui for postgres.
the goal for rainfrog is to provide a lightweight, terminal-based alternative to pgadmin/dbeaver.
PostgreSQL MCP Server for Schema Intelligence. The Offline-First PostgreSQL MCP That Won't Ruin Your Production.
Capture your schema and statistics into a portable snapshot. Lint it, diff it, validate queries against it, and hand it to your AI assistant. No production credentials on developer machines.
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:
- Plongez dans le monde de CloudNativePG #4 - Les sauvegardes ! @ Dalibo :fr:.
- Making Postgres scale to zero with CNPG @ xata.
- Kubernetes Finally Solves Its Biggest Problem: Managing Databases @ The New Stack. https://medium.com/@nejdetkadir/how-i-built-my-own-home-lab-a-single-node-kubernetes-platform-34bdf6a08a26
pgtui is a Postgres TUI client that handles basic CRUD operations on databases.
There are two main windows in the app, one with the available relations in the selected database and the other with the data of those relations. You can easily scroll through both, filter relations by type or name, sort the data by columns, or filter the data via a where clause entered into a dialog box.
Related contents:
postgresql_anonymizer is an extension to mask or replace personally identifiable information (PII) or commercially sensitive data from a PostgreSQL database.
The project is aiming toward a declarative approach of anonymization. This means we’re trying to extend PostgreSQL Data Definition Language (DDL) in order to specify the anonymization strategy inside the table definition itself.
Related contents:
Isolated databases for every AI agent branch. Build, test, and migrate in parallel. Production stays untouched.
Database safety infrastructure for AFK agentic development.
SafeAgentDB is built for serious vibe coders shipping real products with a team — whether your teammates are people, AI agents, or both. Once you have many branches in flight at the same time, one shared database becomes the thing everyone breaks. SafeAgentDB gives every branch and PR a live preview URL backed by its own isolated database, so agents can run migrations, hydrate realistic data, and test real app behavior without risking production, corrupting shared development data, or stepping on each other.
Built first for Supabase + Vercel + GitHub Actions, with guidance for adapting the same infrastructure pattern to other stacks.
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.
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.
Related contents:
The most powerful vector database for building AI applications. Open-source PostgreSQL database extension for vector data and vector search operations.
Lantern is an open-source PostgreSQL database extension to store vector data, generate embeddings, and handle vector search operations.
Build APIs in 5 minutes. Build NodeJS / GO APIs in 5 minutes not weeks. A GraphQL-to-SQL converting app.
Just write simple GraphQL queries to define the data you need and GraphJin will auto-magically convert them into efficient SQL queries and fetch the data you need.
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:
Turn Claude/Codex into geospatial analytics agent.
Claude, Codex, and GitHub Copilot skill for data scientists and analysts working with geospatial data on PostGIS, BigQuery, Snowflake, and Wherobots.
PGTune calculate configuration for PostgreSQL based on the maximum performance for a given hardware configuration.
It isn't a silver bullet for the optimization settings of PostgreSQL. Many settings depend not only on the hardware configuration, but also on the size of the database, the number of clients and the complexity of queries. An optimal configuration of the database can only be made given all these parameters are taken into account.
🐦🔥 Modernize your database by moving to PostgreSQL.
Related contents:
Graph Data Processing & Analytics for Relational Database.
Apache AGE® is a PostgreSQL extension that provides graph database functionality. Graph database optimized for fast analysis and real-time data processing. It is provided as an extension to PostgreSQL.
Drop-in SQL Caching for PostgreSQL and MySQL.
Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.
Related contents:
Store git objects and refs in PostgreSQL tables. Standard git push/clone work against the database through a libgit2-based backend.
Related contents:
modern Postgres terminal written in Rust. psql-compatible, with built-in DBA diagnostics and AI assistant.
A psql-compatible terminal written in Rust with built-in DBA diagnostics and AI assistant. Single binary, no dependencies, cross-platform.
An open-source SQL-Native memory engine for AI. Open-Source Memory Engine for LLMs, AI Agents & Multi-Agent Systems.
One line of code to give any LLM persistent, queryable memory using standard SQL databases.
Memori enables any LLM to remember conversations, learn from interactions, and maintain context across sessions with a single line: memori.enable(). Memory is stored in standard SQL databases (SQLite, PostgreSQL, MySQL) that you fully own and control.
AgensGraph is a cutting-edge multi-model graph database designed for modern complex data environments. By supporting both relational and graph data models simultaneously, AgensGraph allows developers to seamlessly integrate legacy relational data with the flexible graph data model within a single database. AgensGraph is built on the robust PostgreSQL RDBMS, providing a highly reliable, fully-featured platform ready for enterprise use.
Kubegres is a Kubernetes operator allowing to deploy one or many clusters of PostgreSql instances with data replication and failover enabled out-of-the box. It brings simplicity when using PostgreSql considering how complex managing stateful-set's life-cycle and data replication could be with Kubernetes.
DX-focused control plane for Postgres dedicated to non-critical workloads. Your postgres:latest replacement 🐘
NeonD is an open-source Neon-based control plane daemon for PostgreSQL. It offers S3-based layer durability, instant branching, precise Point-in-time recovery in seconds. Runs as a single Docker container, handles multi-tenant PostgreSQL instances seamlessly.
How PostgreSQL Works, in 3D.
PGSimCity is an independent, non-commercial educational visualization of PostgreSQL internals. It is not affiliated with, sponsored, endorsed, or approved by Electronic Arts Inc. SimCity is a trademark of Electronic Arts Inc.
A TypeScript ORM for Majestic Monoliths and PostgreSQL.
Related contents:
A set of extensions to Doctrine 2 that add support for functions available in MySQL, Oracle, PostgreSQL and SQLite.
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:
Postgres for Search and Analytics.
ParadeDB is an Elasticsearch alternative built on Postgres. We're modernizing the features of Elasticsearch's product suite, starting with real-time search and analytics.
Related contents:
Fast PostgreSQL Client for Developers.
A minimal, fast SQL client desktop application with AI-powered querying. Built for developers who want to quickly peek at their data without the bloat. Supports PostgreSQL, MySQL, and Microsoft SQL Server.
Build Databases As Spreadsheets :No-Coding Required.
NocoDB allows building no-code database solutions with ease of spreadsheets. Bring your own database or choose ours! Millions of rows? Not a problem. Your Data. Your rules. You are in control.
🔥 🔥 🔥 Open Source Airtable Alternative. Turns any MySQL, PostgreSQL, SQL Server, SQLite & MariaDB into a smart spreadsheet.
in Postgres, the EXPLAIN command produces far too much information.
That's how the idea of a post-processing for EXPLAIN output was born - to make query plans more readable and problem-focused.
Related contents:
SQL language server written in Go.
sqls aims to provide advanced intelligence for you to edit sql in your own editor.
A desktop application for managing PostgreSQL databases — backups, restores, scheduling, encryption, data browsing, and more.
Related contents:
Modern, Native Tool for Database Management. Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more
Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.
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:
Knex.js is a batteries-included SQL query builder for JavaScript.
Knex.js (pronounced /kəˈnɛks/) is a "batteries included" SQL query builder for PostgreSQL, CockroachDB, MSSQL, MySQL, MariaDB, SQLite3, Better-SQLite3, Oracle, and Amazon Redshift designed to be flexible, portable, and fun to use.
The serverless database built for modern development.
Your database should be easy to use, not a source of frustration. Xata easily integrates into your developer workflow, providing the best data experience for Github, Vercel and Netlify based deployments.
Related contents:
Durable, crash-proof functions built into Postgres.
Orchestrate retries, scheduling, parallel fan-out, and conditional branching with a tiny SQL DSL. Built on Postgres + a background worker — no containers, no external services, just Postgres.
CockroachDB is a cloud-native distributed PostgreSQL-compatible SQL database designed to build, scale, and manage modern, data-intensive applications.
Related contents:
- Migrating to Postgres @ Motion Engineering Blog.
- Optimizing PgBench for CockroachDB Part 1 @ DZone.
- Optimizing PgBench for CockroachDB Part 2 @ DZone.
- Optimizing PgBench for CockroachDB Part 3 @ DZone.
- Leveraging Change Data Capture For Database Migrations At Scale @ SquareSpace Engineering.
- How CockroachDB Built Vector Indexing at Scale @ ByteByteGo Newsletter.
The world's most advanced open source database.
Related contents:
- You Just Need Postgres.
- Postgres Locks Explained.
- 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é.
- Kafka is fast -- I'll use Postgres @ TopicPartition.
- Redis is fast - I'll cache in Postgres @ Dizzy zone.
- Moving tables across PostgreSQL instances @ Anantha Kumaran.
- Absurd Workflows: Durable Execution With Just Postgres @ Armin Ronacher's Thoughts and Writings.
- Don't give Postgres too much memory @ Tomas Vondra.
- Moving tables across PostgreSQL instances @ Anantha Kumaran.
- Postgres Internals Hiding in Plain Sight @ crunchy data.
- #PostgresMarathon 2-013: Why keep your index set lean @ PostgresAI.
- [99% of Developers Don't Get PostgreSQL @ The Coding Gopher's YouTube](https://www .youtube.com/watch?v=P8rrhZTPEAQ).
- PostgreSQL DBA @ Developer Roadmaps.
- How/Why to Sweep Async Tasks Under a Postgres Table @ taylor.town.
- Instant database clones with PostgreSQL 18 @ boringSQL.
- Go ahead, self-host Postgres @ Pierce Freeman.
- PostgreSQL 18 RETURNING Enhancements: A Game Changer for Modern Applications @ pgEdge.
- The hidden cost of PostgreSQL arrays @ boringSQL.
- Life Altering Postgresql Patterns @ mccue.dev.
- Unconventional PostgreSQL Optimizations @ Haki Benita.
- I Replaced Redis with PostgreSQL (And It's Faster) @ Polliog's dev.to.
- Using PostgreSQL as a Dead Letter Queue for Event-Driven Systems @ Diljit's Corner.
- Introduction to PostgreSQL Indexes @ Dalto Curvelano.
- Introducing: Postgres Best Practices @ supabase.
- Postgres Postmaster does not scale @ recall.ai.
- Futureproofing Tines: Partitioning a 17TB table in PostgreSQL @ tines.
- Database Indexing @ AkashSDas' Medium.
- Scaling PostgreSQL to power 800 million ChatGPT users @ OpenAI.
- Unlocking High-Performance PostgreSQL: Key Memory Optimizations @ Stormatics.
- Six Signs That Postgres Tuning Won't Fix Your Performance Problems @ TigerData.
- PostgreSQL Bloat Is a Feature, Not a Bug @ Roger Welin.
- Read efficiency issues in Postgres queries @ pg mustard.
- The real cost of random I/O @ Tomas Vondra.
- Production query plans without production data @ Boring SQL.
- Rust is slowly but surely eating PostgreSQL: Deep dive into Neon, ParadeDB, PgDog and more @ Sylvain Kerkour.
- How We Optimized Top K in Postgres @ ParadeDB.
- Using Rust and Postgres for everything: patterns learned over the years @ Sylvain Kerkour.
- Ctrl-C in psql gives me the heebie-jeebies @ Neon.
- When upserts don't update but still write: Debugging Postgres performance at scale @ Datadog.
- Introduction to PostgreSQL Indexes @ explain, analyze.
- Keeping a Postgres queue healthy @ PlanetScale.
- I replaced my entire stack with Postgres... @ The Coding Gopher.
- Does Postgres Scale? @ DBOS.
- The "Just Use Postgres" Trap @ CodeOpinion's YouTube.
- How we saved ~40GB of Postgres space wasted on indexes @ Ravi Ojha's peer list.
- Vos requêtes SQL jusqu'à 10000 fois plus rapides, durablement. - Alain LESAGE (DALIBO) @ Devoxx France's YouTube :fr:.
- Handling graphs with SQL/PGQ in PostgreSQL @ Cybertec.
- When failover isn’t safe: Building high-availability PostgreSQL on Kubernetes @ Datadog Engineering.
- The only scalable delete in Postgres is DROP TABLE @ Planetscale.
- The NULL in your NOT IN @ boringSQL.
- The feedback loops behind Kubernetes @ Planetscale.
- Too many tables are bad for you @ Cybertec.
- PostgreSQL and the OOM Killer: Why We Use Strict Memory Overcommit @ ubicloud.
- How to Achieve Pruning When Querying by Non-Partitioned Columns in PostgreSQL @ Haki Benita.
- The four horsemen behind thousands of Postgres outages @ malisper.me.
- PostgreSQL as a temporal database @ xata.
- Repeatable Read vs Snapshot Isolation @ jaymcor.github.io.
- The database that refused to die: How Postgres survived its own creators @ The Register.
- The startup's Postgres survival guide @ Hatchet.
- PostgreSQL's MVCC is bad. So is everyone else's @ Boring SQL.
- The dangers of Postgres subtransactions @ Planetscale.
- Massively parallel Postgres backups @ Planetscale.
- Zero-downtime Postgres upgrades with logical replication @ Dimitri Fontaine.
PostgreSQL Model Context Protocol (PG-MCP) Server.
A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.