Awesome GitHub RepositoriesPostgreSQL Extensions

Drizzle ORM is a TypeScript-native database toolkit providing type-safe SQL query building, schema management, and automated migrations across PostgreSQL, MySQL, SQLite, and SingleStore.

TimescaleDB is an open-source PostgreSQL extension that adds native time-series capabilities to the database. At its core, it transforms standard PostgreSQL tables into hypertables—automatically partitioned by time intervals—so data is stored in fixed-size chunks without manual sharding. The extension includes a library of over 200 built-in SQL functions purpose-built for time-series workloads, such as time bucketing, gap filling, percentile estimation, and time-weighted averages. What distinguishes TimescaleDB from generic PostgreSQL is its set of integrated time-series features that work th

Citus is a PostgreSQL extension that transforms a standard database into a distributed system. It functions as a sharding framework and distributed SQL engine, enabling horizontal scaling by partitioning tables across a cluster of nodes. By utilizing a coordinator-worker topology, the system manages metadata and routes queries to the appropriate nodes, allowing for parallel execution of complex operations across distributed data shards. The platform distinguishes itself through its specialized support for multi-tenant architectures and real-time analytical processing. It enables tenant-based

Garnet is a multi-threaded in-memory database and distributed key-value store. It functions as a high-performance remote cache store that implements the RESP wire protocol to maintain compatibility with existing Redis clients and libraries. The project is distinguished by a shared-memory architecture that enables parallel request processing across multiple cores for sub-millisecond latency. It features a tiered storage system that automatically offloads colder data from system memory to SSD or cloud storage layers, and includes a specialized vector search database for high-dimensional similar

Patroni is a high availability manager and cluster orchestrator for PostgreSQL. It functions as an automatic failover controller and replication manager that ensures continuous database availability by automating leader election and promoting standby nodes during failures. The system maintains a consistent cluster state by acting as a distributed consensus coordinator. It synchronizes configuration and manages leader elections through integration with distributed configuration stores such as etcd, ZooKeeper, or Consul. Its broader capabilities include managing both synchronous and asynchrono

PostgresApp is a native macOS application that provides a graphical interface for installing and managing PostgreSQL database servers locally. It serves as a local server manager, allowing users to start, stop, and configure database server states without using the command line. The application supports running multiple different versions of the database server simultaneously on a single machine, enabling multi-version compatibility testing and migrations through isolated environments. It also includes a bundle of pre-installed extensions for geospatial processing and vector search, removing

A very fast implementation of tldr in Rust.

H3 is an open-source library that provides a hierarchical hexagonal grid system for geospatial indexing. It projects the Earth onto an icosahedron and tiles each face with hexagons to minimize distortion, then encodes each hexagon as a 64-bit integer that stores its resolution and position in the hierarchy. This integer encoding enables fast bitwise operations for grid navigation and spatial analysis. The library offers a comprehensive set of grid topology algorithms for computing neighbor relationships, distances, and paths between cells directly on the hexagonal grid without geographic coor

Pigsty 是一个全面的数据库基础设施编排平台，旨在自动化高可用 PostgreSQL 集群的全生命周期。它作为一个基础设施即代码（IaC）框架，通过幂等 Playbook 管理集群协调、节点配置与服务发现。通过集成分布式共识机制，该平台确保了在包括裸机与虚拟化基础设施在内的多样化环境中，自动化故障转移与一致的状态强制执行。 该平台通过一套超越标准数据库管理的强大运营能力脱颖而出。它具备内置的观测流水线，将指标、日志与追踪聚合到集中式仪表盘中，用于实时性能监控与诊断分析。此外，它还提供了一个模拟专有线路协议与 SQL 语法的迁移框架，允许将遗留企业数据库工作负载集成到现代关系型环境中。 该系统涵盖了广泛的功能面，包括带有写时复制（CoW）克隆以实现快速部署的高级存储管理，以及协调关系型引擎与缓存及对象存储服务的多数据库编排。它还整合了安全加固、自动化备份与恢复，以及通过分层代理进行的流量路由，以将客户端连接与底层集群拓扑解耦。 该项目以自包含的包镜像模型分发，能够在安全或离线环境中实现一致的部署与依赖管理。

pgx 是一个用于使用 Rust 语言开发高性能 PostgreSQL 扩展的框架和工具套件。它提供了一个底层 API 包装器，用于与内部数据库内存上下文、日志系统和核心执行 API 进行交互，从而能够直接在数据库引擎内实现自定义的数据库功能和逻辑。 该项目的特色在于其专用的构建工具和命令行接口，用于管理从环境初始化到二进制打包的扩展开发生命周期。它包含一个类型映射器，可将语言结构转换为数据库复合类型，并自动生成相应的 SQL 模式定义。 该框架涵盖了广泛的功能面，包括用户定义函数映射、二进制协议集成，以及多版本目标支持，以确保跨不同数据库版本的兼容性。它还提供了专门的内存管理包装器来处理指针并防止数据库环境中的内存泄漏。

pgrx is a framework for building and packaging custom PostgreSQL extensions using Rust. It serves as a foreign function interface bridge that maps Rust types and functions to the internal server programming interface of the database. The project provides a specialized toolchain for cross-compilation across different operating systems and target architectures using custom sysroots. It includes a schema generator that automatically translates high-level language structures into SQL definitions and binary protocol mappings. The framework manages memory safety by wrapping database memory context

Pigsty is a full-stack orchestration suite for deploying, monitoring, and managing high-availability PostgreSQL clusters and their supporting infrastructure. It functions as a cluster management platform and high-availability suite that automates failover, manages virtual IPs, and ensures data consistency through distributed consensus. The project distinguishes itself by providing a comprehensive database infrastructure-as-code framework and a dedicated observability stack. It incorporates a backup and recovery manager supporting point-in-time recovery via S3-compatible object storage, alongs

Apache AGE is a graph database extension for PostgreSQL that adds openCypher graph query capabilities directly within the relational database environment. It functions as a loadable extension that translates Cypher graph traversal queries into SQL expressions, enabling users to run pattern matching and path analysis alongside standard SQL operations within a single database instance. The extension stores labeled, directed property graphs as isolated schemas with internal relational tables for vertices, edges, and labels, preventing cross-graph interference. It supports hybrid query execution

Groupdate 是一个 PostgreSQL 时间序列聚合和日期分组工具。它提供了一组 SQL 函数，用于将时间记录分组并聚合到离散的桶中（如天、周或月），以计算报告的总和和平均值。 该项目专注于通过时间序列间隙填充来确保连续的时间线，该功能为不存在数据的期间插入默认值。它还包括一个时间数据格式化程序，将分组的日期时间键转换为本地化字符串或自定义格式模式。 该工具涵盖了广泛的时间数据操作，包括时间范围过滤和日历组件的提取（例如按星期几对数据进行分组）。它进一步支持时区感知计算，以使分组与本地日历天对齐。

pg_cron is a PostgreSQL job scheduler and background task manager that executes periodic SQL commands directly within the database engine. It functions as an automation tool using standard cron syntax to trigger recurring administrative and data tasks on a defined timetable. The extension provides the capability to manage and trigger scheduled SQL operations across multiple target databases from a single instance. It includes a logging system that acts as an execution auditor, tracking the start time, end time, and success status of every job run. The project covers database maintenance auto

Setuptools is a Python package build tool and distribution framework used to bundle code into distributable archives. It functions as a project metadata manager, allowing for the declarative definition of project identity, versioning, and dependencies. The toolkit distinguishes itself by providing an extension compiler for C and C++ source files and a plugin architecture that uses entry points to enable runtime discovery of functionality. It also supports development environment tooling, such as editable installs that link source code directly to the environment to allow immediate changes wit

pgvecto.rs is a database extension that integrates high-dimensional vector search capabilities directly into PostgreSQL. It functions as a specialized engine for storing and retrieving embeddings, allowing relational databases to perform similarity searches alongside traditional structured data queries. The extension distinguishes itself through hardware-aware execution strategies that maximize performance. It performs runtime analysis of the host machine to utilize specific processor instruction sets for accelerated mathematical operations. To manage memory efficiently, it employs quantizati

该项目是一个数据库扩展，支持跨多个 PostgreSQL 节点的水平扩展和分布式数据分区。它作为一个中间件解决方案，将大型数据库表分布在集群中，以增加总存储容量并提高不断增长的数据集的写入性能。 该系统采用基于哈希的分区将表记录分布在物理节点上，并使用中央元数据目录来跟踪分片位置。它提供透明的查询路由，将标准 SQL 命令从协调节点引导至适当的工作节点，而无需修改现有的应用逻辑。 该框架包含通过分片复制和自动一致性修复过程来维护数据冗余和集群完整性的工具。它还支持高吞吐量数据摄入，利用并发处理将海量数据集导入分布式表中。