Links
AddShip AI features in minutes. Pezzo enables you to build, test, monitor and instantly ship AI all in one platform, while constantly optimizing for cost and performance.
🕹️ Open-source, developer-first LLMOps platform designed to streamline prompt design, version management, instant delivery, collaboration, troubleshooting, observability and more.
pflag is a drop-in replacement for Go's flag package, implementing POSIX/GNU-style --flags.
pflag is compatible with the GNU extensions to the POSIX recommendations for command-line options. For a more precise description, see the "Command-line flag syntax" section below.
World's Most Trusted Open Source Firewall.
The pfSense project is a free network firewall distribution, based on the FreeBSD operating system with a custom kernel and including third party free software packages for additional functionality. pfSense software, with the help of the package system, is able to provide the same functionality or more of common commercial firewalls, without any of the artificial limitations. It has successfully replaced every big name commercial firewall you can imagine in numerous installations around the world, including Check Point, Cisco PIX, Cisco ASA, Juniper, Sonicwall, Netgear, Watchguard, Astaro, and more.
pfSense is a free, open source customized distribution of FreeBSD tailored for use as a firewall and router. In addition to being a powerful, flexible firewalling and routing platform, it includes a long list of related features and a package system allowing further expandability without adding bloat and potential security vulnerabilities to the base distribution. pfSense is a popular project with more than 1 million downloads since its inception, and proven in countless installations ranging from small home networks protecting a PC and an Xbox to large corporations, universities and other organizations protecting thousands of network devices.
pgactive is a PostgreSQL replication extension for creating an active-active database.
Postgres performance at any scale. PostgreSQL Tuning
Deliver consistent database performance and availability through intelligent tuning advisors and continuous database profiling.
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.
PostgreSQL Auditing Extension.
The PostgreSQL Audit Extension (or pgaudit) provides detailed session and/or object audit logging via the standard logging facility provided by PostgreSQL. The goal of PostgreSQL Audit to provide the tools needed to produce audit logs required to pass certain government, financial, or ISO certification audits.
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.
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.
PostgreSQL log analyzer.
pgBadger is a PostgreSQL log analyzer built for speed with fully detailed reports and professional rendering.
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:
Nextgen PostgreSQL Pooler.
PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.
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:
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:
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.
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:
An AI-powered environment for monitoring, managing, and troubleshooting PostgreSQL systems.
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.
Easy to deploy, open source, postgresql function that provides a prioritized list of actions to take to improve stability and performance.
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.
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.
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.
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.
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.
Git-like version control CLI backed by PostgreSQL with pg-xpatch delta compression.
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:
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:
A ledger implementation in 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.
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.
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.
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:
Embed an SQLite database in your PostgreSQL table. AKA multitenancy has been solved.
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!
PostgreSQL Model Context Protocol (PG-MCP) Server.
A Model Context Protocol (MCP) server for PostgreSQL databases with enhanced capabilities for AI agents.
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:
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.
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:
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 Postgres Package Manager.
Modular Postgres development with reusable packages, deterministic migrations, recursive dependency resolution, tag-aware versioning, and turnkey module-first workspaces.
Related contents:
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.
Zero-bloat Postgres queue. One SQL file to install, pg_cron to tick.
For teams who want a durable event stream inside Postgres. The model is closer to Kafka (log) than to ActiveMQ or RabbitMQ (task message queue). Shared event log, independent per-consumer cursors, zero bloat under sustained load. Pure SQL and PL/pgSQL, any Postgres 14+ — managed or self-hosted, no sidecar daemon. The rest of this README walks the history, comparison, and install paths that back up the claim.
Personal ngrok alternative. Expose local ports to the internet with automatic HTTPS, an interactive TUI dashboard, and HTTP request inspection -- all through your own VPS.
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.
PostgreSQL zero-downtime migrations made easy.
pgroll is an open source command-line tool that offers safe and reversible schema migrations for PostgreSQL by serving multiple schema versions simultaneously. It takes care of the complex migration operations to ensure that client applications continue working while the database schema is being updated. This includes ensuring changes are applied without locking the database, and that both old and new schema versions work simultaneously (even when breaking changes are being made!). This removes risks related to schema migrations, and greatly simplifies client application rollout, also allowing for instant rollbacks.
postgres, rewritten in rust.
Postgres rewritten in Rust, now passing 100% of the Postgres regression tests.
Related contents:
Build Postgres Extensions with Rust!
pgrx is a framework for developing PostgreSQL extensions in Rust and strives to be as idiomatic and safe as possible.
Related contents:
The lazygit for PostgreSQL. A vim-style terminal UI for browsing, querying, and editing your database without leaving the keyboard.
A vim-style TUI PostgreSQL client built like lazygit — fast keyboard navigation, modal panes, and a focused workflow for browsing and querying your database from the terminal.
Terraform-style, declarative schema migration for Postgres.
pgschema is a CLI tool that brings terraform-style declarative schema migration workflow to Postgres.
Intelligent Query Result Caching for PostgreSQL
Leverage vector embeddings to cache and retrieve query results based on semantic similarity.
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:
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.
HTTP client for PostgreSQL, retrieve a web page from inside the database.
A PostgreSQL protocol adapter for SQLite databases. This project allows PostgreSQL clients to connect to and query SQLite databases using the PostgreSQL wire protocol.
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:
Real-time data synchronization from PostgreSQL, MySQL, and MariaDB to Elasticsearch and OpenSearch—continuously and transactionally.
PGSync is a lightweight middleware that captures changes from your relational database and writes structured, denormalized documents to your search cluster.
Define your document schema once in JSON, and PGSync handles change capture, ordering, and delivery automatically—no custom ETL code required.