PostgreSQL Database Tools
For a relational database management system for developers, the strongest matches are cockroachdb/cockroach (CockroachDB is a distributed SQL database that provides ACID), erikgrinaker/toydb (ToyDB is an open-source distributed SQL database that provides) and postgres/postgres (PostgreSQL is the reference open-source relational database, providing ACID). pingcap/tidb and timescale/timescaledb round out the shortlist. Each is ranked by relevance to your query, popularity and recent activity.
Open-source utilities for managing, monitoring, optimizing, and interacting with PostgreSQL database clusters and schemas.
PostgreSQL Database Tools
Find the best repos with AI.We'll search the best matching repositories with AI.
- cockroachdb/cockroach
cockroachdb/cockroach
32,207View on GitHubCockroach is a distributed SQL database designed to scale horizontally across multiple nodes while maintaining strict ACID compliance and global data consistency. It functions as a relational database engine that automatically partitions data into ranges, rebalancing them across a cluster to accommodate growing storage and throughput requirements. By utilizing a distributed consensus protocol, the system ensures that all nodes agree on the order of operations, providing fault tolerance and continuous availability even in the event of hardware failures. The system distinguishes itself through
CockroachDB is a distributed SQL database that provides ACID transactions, MVCC, indexing, integrity constraints, replication, and point-in-time recovery, making it a strong relational database comparable to PostgreSQL for this search.
GoACID Transaction SemanticsMulti-Version Concurrency ControlsRelational Database Compatibility - erikgrinaker/toydb
erikgrinaker/toydb
7,251View on GitHubToyDB is a distributed SQL database that provides a system for storing and querying data across multiple nodes. It focuses on maintaining strong consistency and fault tolerance through the implementation of a distributed consensus algorithm. The project distinguishes itself by supporting historical data versioning, enabling time-travel queries to retrieve the state of the database from a specific point in the past. It utilizes multi-version concurrency control to manage ACID transactions and ensure data integrity during concurrent operations. The system covers relational data modeling with t
ToyDB is an open-source distributed SQL database that provides ACID transactions, MVCC concurrency, time-travel queries for point-in-time recovery, and replication via distributed consensus, fitting the relational database management system category, though it is an experimental project rather than a production-grade equivalent of PostgreSQL.
RustData ReplicationMulti-Version Concurrency ControlMulti-Version Concurrency Control - postgres/postgres
postgres/postgres
20,076View on GitHubPostgreSQL is an object-relational database management system designed for the persistent storage and retrieval of structured information. It functions as an ACID-compliant database server, utilizing standard query language protocols to maintain data consistency and reliability across large-scale application datasets. The system distinguishes itself through an extensible architecture that allows for the definition of custom data types, operators, and indexing methods. It employs multi-version concurrency control to enable simultaneous read and write operations without blocking, supported by a
PostgreSQL is the reference open-source relational database, providing ACID transactions, MVCC, SQL, indexing, data integrity constraints, write-ahead logging for point-in-time recovery, replication, and extensible custom types and operators—matching every required feature.
CData Integrity ConstraintsMulti-Version Concurrency ControlsACID Transactional Cores - pingcap/tidb
pingcap/tidb
40,166View on GitHubTiDB is a horizontally scalable, distributed SQL database designed to provide consistent transactional storage and high-performance analytical processing within a single unified architecture. It utilizes a decoupled compute-storage design and a distributed key-value storage layer to ensure horizontal scalability and efficient range-based queries. By employing a consensus-based replication algorithm, the system maintains high availability and automatic failover across multiple nodes and geographical regions. The platform distinguishes itself through its hybrid transactional and analytical proc
TiDB is a horizontally scalable distributed SQL database that supports SQL, ACID transactions, MVCC, indexing, and replication—covering the core RDBMS features you need—but it is MySQL-compatible rather than PostgreSQL, which may be a mismatch if you specifically require PostgreSQL compatibility.
GoData ReplicationDatabase Replication - timescale/timescaledb
timescale/timescaledb
21,876View on GitHubTimescaleDB 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
TimescaleDB is a PostgreSQL extension that inherits PostgreSQL's full SQL, ACID, MVCC, indexing, constraints, replication, and point-in-time recovery, so it functions as a relational database management system—but its core identity is a time-series specialization, making it a narrower fit than a general-purpose RDBMS.
CAutomatic Time PartitioningHypertable PartitioningTime-Series Extensions
