postgresql
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.
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.
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.
PostgreSQL extension for BM25 relevance-ranked full-text search. Postgres OSS licensed.
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 database client Mac deserves. Fast, native database client for Mac
Connect to MySQL, Postgres, SQLite, Mongo, Redis, and a dozen more. Built with SwiftUI. Ships under 50 MB. Launches in under a second.
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:
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:
Git-like version control CLI backed by PostgreSQL with pg-xpatch delta compression.
Related contents:
The FLOSS PG RDS.
Enterprise-Grade Open-Source PG Distribution HA, PITR, IaC, Monitor, and 460+ PG extensions. Enterprise-Grade OSS PostgreSQL Distribution with HA, PITR, IaC, Monitor, 12 kernel forks and 460 PG extensions. Best-of-breed products integrated as a platform. Self-host Postgres like a Pro!
Related contents:
Wrappers is a Rust framework for developing PostgreSQL Foreign Data Wrappers.
Related contents:
the world's first video call over a database.
Don't use this!
Related contents:
Intelligent Query Result Caching for PostgreSQL
Leverage vector embeddings to cache and retrieve query results based on semantic similarity.
Store git objects and refs in PostgreSQL tables. Standard git push/clone work against the database through a libgit2-based backend.
Related contents:
One global database.
A globally distributed PostgreSQL proxy that puts your data closer to your users. Connection pool, query caching, multiple regions. Just swap the connection string.
Related contents:
Modern credential testing tool in pure Go.
Fast, zero-dependency credential testing tool in Go. Brute force SSH, MySQL, PostgreSQL, Redis, MongoDB, SMB, and 20+ protocols. Hydra alternative with native fingerprintx/naabu pipeline integration.
Brutus is a multi-protocol authentication testing tool designed to address a critical gap in offensive security tooling: efficient credential validation across diverse network services. While HTTP-focused tools are abundant, penetration testers and red team operators frequently encounter databases, SSH, SMB, and other network services that require purpose-built authentication testing capabilities.
An updated sample database for PostgreSQL, building off of the Pagila database.
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:
Strongly typed queries for PostgreSQL and TypeScript
pg-typesafe generates TypeScript types for PostgreSQL queries. It does so with no runtime dependencies, and zero additional verbosity.
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.
Self-hosted database backup manager for MySQL, PostgreSQL & MariaDB with scheduled backups, cross-server restore, and S3/SFTP storage support.
Related contents:
Nextgen PostgreSQL Pooler.
PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.
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.
Minimal Database MCP Server.
DBHub is a zero-dependency, token efficient MCP server implementing the Model Context Protocol server interface. This lightweight gateway allows MCP-compatible clients to connect to and explore different databases.
A purely functional expression language for No-Code tools. A simple, well-designed, portable, and safe data expression language.
Elo compiles to JavaScript, Ruby, and SQL. Built for No-Code tools where non-technical users need to manipulate data easily and safely.
Related contents:
Easily collect and report PostgreSQL metrics for scripting, automation and troubleshooting.
pgmetrics is an open-source, zero-dependency, single-binary tool that can collect 350+ metrics from a running PostgreSQL server and display it in easy-to-read text format or export it as JSON and CSV for scripting.
Related contents:
A PostgreSQL Docker container that automatically upgrades your database.
Its whole purpose in life is to automatically detect the version of PostgreSQL used in the existing PostgreSQL data directory, then automatically upgrade it (if needed) to the required version of PostgreSQL using pg_upgrade with the --link option.
🔱 A dynamic SQL query builder for MySQL, Postgres and SQLite.
SeaQuery is a query builder to help you construct dynamic SQL queries in Rust. You can construct expressions, queries and schema as abstract syntax trees using an ergonomic API. We support MySQL, Postgres and SQLite behind a common interface that aligns their behaviour where appropriate. MS SQL Server Support is available under SeaORM X.
A Postgres Package Manager.
Modular Postgres development with reusable packages, deterministic migrations, recursive dependency resolution, tag-aware versioning, and turnkey module-first workspaces.
Related contents:
A user friendly TUI for SQL databases. Written in python. Supports SQL server, Mysql, PostreSQL and SQLite, Turso and more.
The lazygit of SQL databases. Connect to Postgres, MySQL, SQL Server, SQLite, Supabase, Turso, and more from your terminal in seconds.
Related contents:
Un parcours théorique complet pour découvrir, comprendre et approfondir PostgreSQL 18, des fondamentaux à la production.
a data lakehouse for you and me. managed + real-time Iceberg.
🥮 is real-time + managed Apache Iceberg. bringing open analytical tables on object store to every team.
pg_mooncake is a ClickHouse alternative for real-time analytics built on Postgres. It turns Postgres into a real-time analytics database by adding:
Columnar storage (Apache Iceberg, via Moonlink)
Vectorized execution with DuckDB (via pg_duckdb).
Fast analytics queries require both columnar storage & vectorized execution, and previous Postgres analytics solutions only solved half the problem.
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.
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:
IVM (Incremental View Maintenance) implementation as a PostgreSQL extension
Incremental View Maintenance (IVM) is a way to make materialized views up-to-date in which only incremental changes are computed and applied on views rather than recomputing the contents from scratch as REFRESH MATERIALIZED VIEW does. IVM can update materialized views more efficiently than recomputation when only small parts of the view are changed.
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.
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.
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:
PostgreSQL backup tool
Databasus is a free, open source and self-hosted tool to backup PostgreSQL. Make backups with different storages (S3, Google Drive, FTP, etc.) and notifications about progress (Slack, Discord, Telegram, etc.). MySQL, MariaDB and MongoDB are supported too
Postgres with Iceberg and data lake access.
pg_lake integrates Iceberg and data lake files into Postgres. With the pg_lake extensions, you can use Postgres as a stand-alone lakehouse system that supports transactions and fast queries on Iceberg tables, and can directly work with raw data files in object stores like S3.
Related contents:
SQL & noSQL database manager.
Powerful and easy to use (no)SQL database client for MySQL, PostgreSQL, Oracle, SQL Server, SQLite, MongoDB, Redis, …
DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. But there are also many advanced features like schema compare, visual query designer, chart visualisation or batch export and import.
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.
Related contents:
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: