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 is a comprehensive database infrastructure orchestration platform designed to automate the full lifecycle of high-availability PostgreSQL clusters. It functions as an infrastructure-as-code framework that manages cluster coordination, node provisioning, and service discovery through idempotent playbooks. By integrating distributed consensus mechanisms, the platform ensures automated failover and consistent state enforcement across diverse environments, including bare metal and virtualized infrastructure. The platform distinguishes itself through a robust suite of operational capabiliti

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 is a PostgreSQL time series aggregator and date grouping tool. It provides a set of SQL functions to group and aggregate temporal records into discrete buckets, such as days, weeks, or months, to calculate sums and averages for reports. The project focuses on ensuring continuous timelines through time series gap filling, which inserts default values for periods where no data exists. It also includes a temporal data formatter that converts grouped date-time keys into localized strings or custom formatting patterns. The tool covers broad temporal data operations, including time range

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

This project is a database extension that enables horizontal scaling and distributed data partitioning across multiple PostgreSQL nodes. It functions as a middleware solution that distributes large database tables across a cluster to increase total storage capacity and improve write performance for growing datasets. The system employs hash-based partitioning to distribute table records across physical nodes and uses a central metadata catalog to track shard locations. It provides transparent query routing, which directs standard SQL commands from a coordinator node to the appropriate worker n