postgresql
🐘 👥 Manage PostgreSQL roles and privileges from YAML or LDAP
Postgres is able to check password of an existing role using the LDAP protocol out of the box. ldap2pg automates the creation, update and removal of PostgreSQL roles and users from an entreprise directory.
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.
Fast SQL for time-series
QuestDB is an open-source time-series database for high throughput ingestion and fast SQL queries with operational simplicity. It supports schema-agnostic ingestion using the InfluxDB line protocol, PostgreSQL wire protocol, and a REST API for bulk imports and exports.
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.
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.
Tools for MySQL to PostgreSQL migration.
mysql_migrator is a plugin for db_migrator that uses mysql_fdw to migrate an MySQL or MariaDB database to PostgreSQL.
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:
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 opinionated framework for easily creating typesafe data layers. End-to-end typesafe data fetching for frontend teams at scale.
Effortless database administration tool.
Onedump is a database administration tool that streamlines backup and restore tasks across multiple databases and storage destinations.
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:
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:
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é.
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.
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.
Easy-to-run demo of a CDC pipeline using Debezium (Kafka Connect), PostgreSQL, Redpanda, and ClickHouse.
Open source UI for Postgres databases.
Mathesar is a straightforward open source tool that provides a spreadsheet-like interface to a PostgreSQL database. Our web-based interface helps you and your collaborators work with data more independently and comfortably – no technical skills needed.
You can use Mathesar to build data models, enter data, and even build reports. You host your own Mathesar installation, which gives you ownership, privacy, and control of your data.
FerretDB is an open-source proxy, converting the MongoDB 6.0+ wire protocol queries to SQL - using PostgreSQL as a database engine.
Modern, Native Tool for Database Management. Modern, native, and friendly GUI tool for relational databases: MySQL, PostgreSQL, SQLite & more
pgactive is a PostgreSQL replication extension for creating an active-active database.
Your Data Pipeline, Simplified. GlareDB: An analytics DBMS for distributed data.
Data exists everywhere: your laptop, Postgres, Snowflake and as files in S3. It exists in various formats such as Parquet, CSV and JSON. Regardless, there will always be multiple steps spanning several destinations to get the insights you need.
GlareDB is designed to query your data wherever it lives using SQL that you already know.
PostgreSQL Foreign Data Wrapper for Oracle.
oracle_fdw is a PostgreSQL extension that provides a Foreign Data Wrapper for easy and efficient access to Oracle databases, including pushdown of WHERE conditions and required columns as well as comprehensive EXPLAIN support.
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.
🐘 Effortless PostgreSQL backups with a user-friendly web interface! 🌐💾
db_migrator is a PostgreSQL extension that provides functions for migrating databases from other data sources to PostgreSQL. This requires a foreign data wrapper for the data source you want to migrate.
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:
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.
PostgreSQL database anonymization and synthetic data generation tool . Open Source Data Anonymization Software Empowering a Test Data Management Approach
Greenmask provides a secure toolset to transform your database while maintaining integrity, creating a staging environment that mirrors production data and ensures efficient testing without compromising information.
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.
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.
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.
PostgREST is a standalone web server that turns your PostgreSQL database directly into a RESTful API. The structural constraints and permissions in the database determine the API endpoints and operations.
PostgreSQL Model Context Protocol (PG-MCP) Server.
A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.
Sync for modern apps. The standard sync layer for local-first apps. Build reactive, realtime, local-first apps directly on Postgres.
ElectricSQL is a local-first software platform that makes it easy to develop high-quality, modern apps with instant reactivity, realtime multi-user collaboration and conflict-free offline support.
Local-first is a new development paradigm where your app code talks directly to an embedded local database and data syncs in the background via active-active database replication. Because the app code talks directly to a local database, apps feel instant. Because data syncs in the background via active-active replication it naturally supports multi-user collaboration and conflict-free offline.
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.
A collection of language tools and a Language Server Protocol (LSP) implementation for Postgres, focusing on developer experience and reliable SQL tooling.
Related contents:
A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB & Elastic Search with Chat interface.
Build faster, test better with production-like data in a snap!
Snaplet is an all-in-one developer tool that gives developers realistic, production-like data that they can code against. Snaplet uses generative ai to give you realistic, production-like data for your Postgres database so you can code, debug, and test with ease.
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.
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.
A lightweight next-gen data explorer - Postgres, MySQL, SQLite, MongoDB, Redis, MariaDB, Elastic Search, and Clickhouse with Chat interface
🐦🔥 Modernize your database by moving to PostgreSQL.
Related contents:
React based CMF / blogging engine using Redux, Postgres, Node, and more...
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.
🗄 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:
Infra for RAG apps that work in prod. You know Postgres. Now you know machine learning.
Index, filter & rank vectors. Create embeddings. Generate real-time, fact-based outputs.
Korvus is a search SDK that unifies the entire RAG pipeline in a single database query. Built on top of Postgres with bindings for Python, JavaScript and Rust, Korvus delivers high-performance, customizable search capabilities with minimal infrastructure concerns.
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:
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.
Pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client.
Pgpool-II saves connections to the PostgreSQL servers, and reuse them whenever a new connection with the same properties (i.e. username, database, protocol version) comes in. It reduces connection overhead, and improves system's overall throughput.
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.
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:
HTTP client for PostgreSQL, retrieve a web page from inside the database.
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.
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.
Version control for your database
Robust schema evolution across all your environments. With ease, pleasure, and plain SQL.