postgresql
Sharded Postgres by PlanetScale.
Neki is sharded Postgres by PlanetScale. Every shard is real Postgres. Neki adds the router, sidecars, and control plane to scale it past a single machine, to hundreds of millions of QPS and petabytes of data, without downtime.
Related contents:
Execute chDB queries in Postgres.
This library provides PostgreSQL extensions for executing chDB queries in Postgres, and for copying data from external sources into a PostgreSQL table.
Related contents:
the cloud native distributed SQL database for mission-critical applications. AI-Ready, Distributed, Postgres-Compatible Database. Distributed PostgreSQL for Modern Apps
YugabyteDB is a PostgreSQL-compatible, high-performance, cloud-native, distributed SQL database. It combines the benefits of traditional relational databases with the scalability of NoSQL systems, making it suitable for applications that require both transactional consistency and the ability to handle large amounts of data. It is best suited for cloud-native OLTP (that is, real-time, business-critical) applications that need absolute data correctness and require at least one of the following: scalability, high tolerance to failures, or globally-distributed deployments.
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:
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.
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.
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.
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.
An unfaithful port of Linq to Sql to Typescript.
A type-safe query builder for TypeScript. Queries are expressed as inline arrow functions, parsed into an expression tree, and compiled into SQL for PostgreSQL or SQLite. The API is similar to DotNet's LINQ-based frameworks.
Open-source, native Postgres GUI for macOS. Ask questions in English; review the SQL before it runs.
Postgres GUI using the LLM already on your Mac. Free, open-source native macOS database GUI using Apple's on-device Foundation Model for text-to-sql.
AI Text2SQL Tool for Easy Database Management.
🔥🔥🔥 AI-driven database tool and SQL client, The hottest GUI client, supporting MySQL, Oracle, PostgreSQL, DB2, SQL Server, DB2, SQLite, H2, ClickHouse, and more.
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.
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.
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.
postgres, rewritten in rust.
Postgres rewritten in Rust, now passing 100% of the Postgres regression tests.
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.
Talk to your databases. database client for developers.
A fast, beautiful client for PostgreSQL, SQLite, Redis & ClickHouse. Browse data, run SQL, visualize schemas — or just describe what you need and let AI write the query.
Visual SQL Logic Mapper.
actuallyEXPLAIN is a visualizer that helps you understand logical intent in complex PostgreSQL queries in a diagram and dictionarized form.
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:
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.
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.
Easy to deploy, open source, postgresql function that provides a prioritized list of actions to take to improve stability and performance.
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.
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.
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.
A PostgreSQL protocol adapter for SQLite databases. This project allows PostgreSQL clients to connect to and query SQLite databases using the PostgreSQL wire protocol.
An AI-powered environment for monitoring, managing, and troubleshooting PostgreSQL systems.
Cross-platform client for PostgreSQL databases.
Pgweb is a web-based database explorer for PostgreSQL, written in Go, and works on Mac, Linux and Windows machines. Distributed as a simple binary with zero dependencies. Very easy to use and packs just the right amount of features.
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.
A desktop application for managing PostgreSQL databases — backups, restores, scheduling, encryption, data browsing, and more.
Related contents:
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.
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.
Related contents:
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.