postgresql
🐘 Effortless PostgreSQL backups with a user-friendly web interface! 🌐💾
Create business apps like assembling blocks. Build website&app with low code, make automated flow, create AI Agent easily.
Low-code platform allows you to build business apps, enables you to quickly create internal tools such as dashboard, crud app, admin panel, crm, cms, etc. Supports PostgreSQL, MySQL, Supabase, GraphQL, MongoDB, MSSQL, Rest API, Hugging Face, Redis, etc. Automate workflows with schedule or webhook. Open source Retool.
pgFouine is a PostgreSQL log analyzer used to generate detailed reports from a PostgreSQL log file. pgFouine can help you to determine which queries you should optimize to speed up your PostgreSQL based application.
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.
Reliable PostgreSQL Backup & Restore.
pgBackRest aims to be a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms that are optimized for database-specific requirements.
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.
SQL language server written in Go.
sqls aims to provide advanced intelligence for you to edit sql in your own editor.
Like Mongo But on Postgres And With Strong Consistency. Flexibility or Consistency? Why not both!
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:
The Open Source Firebase Alternative.
Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.
Related contents:
Embeddable Postgres. Run a full Postgres database locally in WASM with reactivity and live sync. Lightweight WASM Postgres with real-time, reactive bindings.
PGlite is a WASM Postgres build packaged into a TypeScript client library that enables you to run Postgres in the browser, Node.js, Bun and Deno, with no need to install any other dependencies. It is only 3mb gzipped and has support for many Postgres extensions, including pgvector.
Related contents:
Visualizing and understanding PostgreSQL EXPLAIN plans made easy.
A VueJS component to show a graphical vizualization of a PostgreSQL execution plan.
Watch SQL traffic in real-time with a TUI. Real-time SQL traffic viewer — proxy daemon + TUI / Web client.
sql-tap sits between your application and your database (PostgreSQL, MySQL, or TiDB), capturing every query and displaying it in an interactive terminal UI. Inspect queries, view transactions, and run EXPLAIN — all without changing your application code.
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 📈📊
In-browser Postgres sandbox with AI assistance.
With postgres.new, you can instantly spin up an unlimited number of Postgres databases that run directly in your browser (and soon, deploy them to S3).
Un parcours théorique complet pour découvrir, comprendre et approfondir PostgreSQL 18, des fondamentaux à la production.
Git-like version control CLI backed by PostgreSQL with pg-xpatch delta compression.
Related contents:
Stream, transform, and route PostgreSQL data in real-time. The easiest way to move and transform data between PostgreSQL databases using Logical Replication.
pg_flo leverages PostgreSQL's logical replication system to capture and stream data changes. It uses NATS as a message broker to decouple reading from the WAL through the replicator and worker processes, providing flexibility and scalability. Transformations and filtrations are applied before the data reaches the destination.
An updated sample database for PostgreSQL, building off of the Pagila database.
Postgres-Airtable Fusion.
Super fast, Real-time, Professional, Developer-friendly, No-code database. Teable is a Super fast, Real-time, Professional, Developer friendly, No-code database built on Postgres. It uses a simple, spreadsheet-like interface to create complex enterprise-level database applications. Unlock efficient app development with no-code, free from the hurdles of data security and scalability.
Intelligent Query Result Caching for PostgreSQL
Leverage vector embeddings to cache and retrieve query results based on semantic similarity.
Write SQL. Ship confidence. SQL-first tooling for PostgreSQL Type-safe PostgreSQL client code generator.
pGenie validates SQL, manages indexes, and generates type-safe client SDKs — all derived from the migrations and queries in plain SQL.
Postgres performance at any scale. PostgreSQL Tuning
Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling.
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.
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.
Idempotent schema management for MySQL, PostgreSQL, SQLite, and SQL Server.
sqldef is a CLI tool for diffing two SQL schemas. You can use it to manage the migration of RDBMSs using regular SQL DDLs.
Supported databases: MySQL, MariaDB, TiDB, PostgreSQL, SQL Server, and SQLite3.
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.
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:
Scalable, Low-latency and Hybrid-enabled Vector Search in Postgres. Revolutionize Vector Search, not Database.
PGVecto.rs is a Postgres extension that enables scalable vector search, allowing you to build powerful similarity-based applications on top of your Postgres database.
MariaDB, MySQL, MSSQL, PostgreSQL and SQLite made easy.
HeidiSQL is free software, and has the aim to be easy to learn. "Heidi" lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide.
Elephantshark helps monitor, understand and troubleshoot Postgres network traffic: Postgres clients, drivers and ORMs talking to Postgres servers, proxies and poolers (also: standby servers talking to their primaries and subscriber servers talking to their publishers).
Elephantshark sits between the two parties in a PostgreSQL-protocol exchange, forwarding messages in both directions while parsing and logging them.
Related contents:
Persistent Memory for AI Agents. Your AI has amnesia.
Stash makes your AI remember you. Every session. Forever. No more explaining yourself from scratch.
persistent memory layer for AI agents. Episodes, facts, and working context stored in Postgres. MCP server included. Self-hosted, single binary, no cloud required.
Open-source database client for PostgreSQL, MySQL/MariaDB and SQLite with SQL notebooks, visual EXPLAIN, AI and MCP built in. Hackable with plugins.
Tabularis is an open-source desktop SQL workspace for PostgreSQL, MySQL/MariaDB, and SQLite, with a built-in MCP server so Claude, Cursor, and Windsurf can read your schema and run queries through the same app you already use.
Open-source graph database superpowers for your existing Postgres data.
pgGraph is a PostgreSQL extension for running graph search, traversal, shortest path, and relationship queries directly against ordinary PostgreSQL tables.
Your tables stay the source of truth. pgGraph builds a derived graph index and lets you query it from SQL using functions in the graph schema.
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.
Scriptable database and system performance benchmark.
sysbench is a scriptable multi-threaded benchmark tool based on LuaJIT. It is most frequently used for database benchmarks, but can also be used to create arbitrarily complex workloads that do not involve a database server.
A lightweight, PostgreSQL-backed job queue. Handle background jobs with ease.
DataQueue allows you to utilize your existing PostgreSQL database to process background jobs. No need for additional infra or services.
A lightweight, PostgreSQL-backed job queue for Node.js/TypeScript projects. Schedule, process, and manage background jobs with ease. Perfect for web apps (Next.js, etc.) deployed to serverless platforms like Vercel, AWS Lambda, etc.
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:
Regression Testing your SQL queries.
The regresql tool implement a regression testing facility for SQL queries, and supports the PostgreSQL database system. A regression test allows to ensure known results when the code is edited.
Related contents:
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:
Mount PostgreSQL as a filesystem. Build apps with files, explore databases with ls and cat. A filesystem backed by PostgreSQL, and a filesystem interface to PostgreSQL.
Every file is a real PostgreSQL row. Directories are tables. File contents are columns. Multiple agents and humans can read and write the same files concurrently with full ACID guarantees. No sync protocols. No coordination layer. The filesystem is the API.
TigerFS turns PostgreSQL into a transactional filesystem, either as the backend for your files or as a filesystem over your data. Agents and humans share state through files instead of sync protocols, merge workflows, or custom coordination code.
Postgres Lock Explainer.
From the Postgres community for the Postgres community. An in-depth explainer of locks that prioritizes warm design, demos, and developer stories based on my experience as a support engineer specializing in Postgres.
Feature-rich ORM for modern TypeScript & JavaScript.
Sequelize is a modern TypeScript and Node.js ORM for Oracle, Postgres, MySQL, MariaDB, SQLite and SQL Server, and more. Featuring solid transaction support, relations, eager and lazy loading, read replication and more.
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.
Visual SQL Logic Mapper.
actuallyEXPLAIN is a visualizer that helps you understand logical intent in complex PostgreSQL queries in a diagram and dictionarized form.
FerretDB is an open-source proxy, converting the MongoDB 6.0+ wire protocol queries to SQL - using PostgreSQL as a database engine.
Serverless, Fault-Tolerant, Branchable Postgres.
The fully managed multi-cloud Postgres with a generous free tier. We separated storage and compute to offer autoscaling, branching, and bottomless storage.
Multi-DBMS SQL Benchmarking Framework via JDBC.
BenchBase (formerly OLTPBench) is a Multi-DBMS SQL Benchmarking Framework via JDBC.
Related contents:
Proves your PostgreSQL backups actually restore, before you find out the hard way.
Untested backups aren't backups. restoredrill proves your PostgreSQL backups actually restore. It fetches the latest backup, restores it into a throwaway Postgres container, runs checks you define, and writes a JSON report with the restore time. Or, if something else already restored a copy for you, it can just connect and run the same checks against that instead.
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.
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:
A fast, open-source Postgres terminal written in Rust. 🦀🐘 Connect and monitor all your databases from one place — with pgbot built in for deeper diagnostics.
htop for all your Postgres databases — an interactive terminal UI that monitors every database you care about in one place, powered by pgbot's read-only diagnostics.
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:
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.
pg_shmemviz captures PostgreSQL's main and dynamic shared memory segments and presents named allocations, exact structure layouts, padding, pointer targets, and raw bytes in a local browser.
The capture uses an extension. Structure metadata comes from DWARF in the exact postgres executable used for the capture.
Related contents:
Lightweight Postgres packaged as WASM into a TypeScript library for the browser, Node.js, Bun and Deno.
PGlite is a WASM Postgres build packaged into a TypeScript client library that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It is only 3.7mb gzipped.