#1
PostgreSQL is an object-relational database management system supporting SQL features such as transactions, foreign keys and triggers.
- GitHub stars
- 23k
- Last commit
- yesterday
- Self-hosted
- Yes
postgresql.org
PostgreSQL is a feature-rich object-relational database management system covering a large part of the SQL standard. Its feature set includes transactions, foreign keys, subqueries, triggers, and user-defined types and functions, and the distribution also contains C language bindings. This GitHub repository is only a mirror of the official git repository, written in C, and the metadata lists the license as Other.
The project does not use GitHub pull requests; contributors submit patches through the process described on the PostgreSQL wiki. Copyright and license terms are in the COPYRIGHT file, general documentation for each version is published on the project site, and build instructions explain how to compile the server from source. The latest releases of the software and related software are available from the PostgreSQL website. Many hosting providers offer managed PostgreSQL, but the project itself is software you install and operate.
Key features
- Object-relational database with SQL support
- Transactions and foreign keys
- Subqueries and triggers
- User-defined types and functions
- C language bindings
- Documentation for building from source
Pricing: Free and open source; the repository lists the license as Other, so see the COPYRIGHT file for terms.
#2
An open-source, MySQL-compatible distributed SQL database with horizontal scaling, ACID transactions, Raft-based high availability and support for analytics and vector search.
- GitHub stars
- 41k
- Last commit
- today
- Latest release
- v7.5.8
- Licence
- Apache-2.0
- Self-hosted
- Yes
- Hosted version
- Available
tidb.io
TiDB is a cloud-native, open-source distributed SQL database from PingCAP. The name's Ti stands for titanium, and it is built for high availability, strong consistency and the ability to scale out as data and traffic grow, while staying compatible with MySQL so existing applications and tools can connect with little change.
Distributed transactions use a two-phase commit protocol to keep ACID guarantees even across nodes, through network partitions or node failures. It scales horizontally by adding nodes or vertically by adding resources, without downtime, and its architecture separates compute from storage so each can be adjusted independently. Built-in Raft consensus keeps multiple replicas in sync and handles automated failover. Topics also mention HTAP workloads, analytics and native vector search.
TiDB is written in Go under the Apache-2.0 license. It can be deployed on your own infrastructure or consumed as a managed cloud service, and it suits teams that have outgrown a single MySQL server and want horizontal scale without sharding by hand.
Key features
- MySQL-compatible distributed SQL
- Distributed ACID transactions
- Horizontal and vertical scaling without downtime
- Separated compute and storage layers
- Raft-based replication and automated failover
- Analytics and vector search support
Pricing: TiDB Community is free and Cloud Starter has a monthly free quota. Cloud Premium starts from $1800 per month and Dedicated from $0.22 per hour; Self-Managed is priced on request.
#3
CockroachDB is a cloud-native distributed SQL database built on a strongly consistent key-value store that scales horizontally and survives machine and datacenter failures.
- GitHub stars
- 33k
- Last commit
- 2 days ago
- Self-hosted
- Yes
- Hosted version
- Available
cockroachlabs.com
CockroachDB is a distributed SQL database for building, scaling and managing data-intensive modern applications. It is layered on a transactional, strongly consistent key-value store and offers a familiar SQL API for defining, changing and querying data, with ACID transactions across the cluster.
It scales horizontally by adding nodes and is designed to keep running through failed disks, machines, racks and even whole datacenters, with little added latency and no manual recovery. Control over where data is placed is part of the pitch, which matters for locality and compliance. Documentation covers installation, development, deployment and administration, client drivers, and a comparison with other databases, and the design is explained in a public architecture document.
CockroachDB is written in Go. Its license is listed as 'Other' on GitHub, so review the current license terms before using it commercially. You can run your own cluster or let Cockroach Labs run it as the managed CockroachDB Cloud service. It suits teams that need resilient, multi-region relational storage without sharding by hand.
Key features
- Distributed SQL with ACID transactions
- Horizontal scaling by adding nodes
- Survives machine, rack and datacenter failures
- Control over data placement
- Built on a strongly consistent key-value store
- Managed cloud service available
Pricing: Billing is per vCPU-hour: Standard is $0.092 and Mission Critical $0.162 on AWS us-east-1. New cloud organizations get a 30-day trial with $400 in credit; rates vary by region and cloud.
#4
A PostgreSQL extension that adds time-series storage, hypertables and a columnstore for fast, real-time analytics on event data.
- GitHub stars
- 24k
- Last commit
- today
- Latest release
- 2.32.0
- Self-hosted
- Yes
- Hosted version
- Available
tigerdata.com
TimescaleDB is a PostgreSQL extension that turns Postgres into a database for time-series and event data, aimed at real-time analytics. Because it lives inside PostgreSQL, you keep SQL, existing tools and the broader Postgres ecosystem while gaining storage and query features designed for data that arrives continuously with timestamps.
The quick start walks through running it locally with a one-line install script or Docker, creating a hypertable with the columnstore enabled, inserting data directly into the columnstore and running analytical queries. It suggests Docker, around 8 GB of RAM and a psql or other PostgreSQL client, and warns that the install script is meant for local development and testing, not production. Topics list uses such as IoT, financial analysis and historian data.
The code is written in C, and its license is listed as 'Other' on GitHub because some features sit under Timescale's own license rather than a standard open-source one, so check which apply to you. The company, now branded TigerData, also runs a hosted cloud service. It suits teams who want time-series features without leaving PostgreSQL.
Key features
- PostgreSQL extension for time-series data
- Hypertables with columnstore
- Fast analytical queries on event data
- Full SQL and Postgres tooling compatibility
- Docker and one-line local install
- Managed cloud service from the vendor
Pricing: The open-source TimescaleDB is free to self-host. Tiger Cloud compute starts at $30 per month on Performance and $36 on Scale, plus storage, billed hourly with a 30-day free trial; Enterprise is by contact.
#5
MariaDB Server is an open-source relational database that began as a fork of MySQL, with vector search, pluggable storage engines and Galera clustering.
- GitHub stars
- 8.6k
- Last commit
- today
- Latest release
- mariadb-13.0.2
- Licence
- GPL-2.0
- Self-hosted
- Yes
mariadb.org
MariaDB Server is an open-source relational database built by a global community with the MariaDB Foundation and MariaDB plc. It started out as a MySQL fork driven by the people who created MySQL, keeps a high degree of MySQL compatibility, and is described as a straightforward migration target for existing MySQL deployments.
Since then it has gained its own capabilities. A native VECTOR data type with approximate nearest-neighbour HNSW indexing has been available since version 11.8. Pluggable storage engines include InnoDB, Aria and MyRocks, plus ColumnStore (analytics), Spider (sharding) and S3 (archiving). Replication options include async, semi-sync and parallel modes using global transaction IDs, and Galera provides synchronous multi-primary clustering. On the SQL side it offers common table expressions, window functions, temporal tables with system versioning, sequences and a range of JSON functions.
It also offers an Oracle SQL mode with PL/SQL-style routines, GIS data types and full-text indexing, and security features such as role-based access control, pluggable authentication, data-at-rest encryption and TLS. MariaDB is written in C++ and licensed under GPL-2.0, and you run it on your own servers or in the cloud.
Key features
- Native vector search with HNSW indexing
- Pluggable storage engines including InnoDB
- Galera synchronous multi-primary clustering
- Temporal tables and window functions
- MySQL and Oracle compatibility modes
- Spatial and full-text indexing
- Role-based access and data-at-rest encryption
Pricing: Free and open source under the GPL-2.0 licence.
#6
Vitess is a cloud-native database system that adds sharding, connection pooling and schema management on top of MySQL.
- GitHub stars
- 21k
- Last commit
- yesterday
- Latest release
- v24.0.5
- Licence
- Apache-2.0
- Self-hosted
- Yes
vitess.io
Vitess is a MySQL-compatible, cloud-native database system. Its built-in sharding lets a database grow without adding sharding logic to the application, and the sharding schemes are described as transparent to the application.
For performance it rewrites queries, caches and pools connections, so the number of concurrent client connections can scale far beyond traditional MySQL. It detects and repairs primary failures automatically, and data migrations and resharding are done with near-zero downtime.
Schema changes happen in the background without disrupting running workloads, and materialized views and messaging work across shards. Vitess is a graduated project of the Cloud Native Computing Foundation, with quickstarts for Kubernetes and local installs.
Key features
- Built-in sharding
- Query rewriting, caching and connection pooling
- Automatic detection and repair of primary failures
- Live resharding with minimal read-only downtime
- Background schema changes
- Materialized views and messaging across shards
#7
Source repository of the MySQL relational database server, covering the open-source Community edition and the clustered MySQL Cluster variant.
- GitHub stars
- 13k
- Last commit
- 16 days ago
- Self-hosted
- Yes
- Hosted version
- Available
mysql.com
MySQL is a widely used open-source relational database. This repository contains the MySQL Server source code along with MySQL Cluster, which the description presents as a real-time, open-source transactional database. Applications talk to it using SQL, and it is a common choice for web applications and embedded products.
The MySQL website describes several offerings built around the server: the Community Edition, with a published governance model and early access builds; MySQL Enterprise Edition for advanced features, management tools and technical support; MySQL HeatWave, a cloud service that combines transactions with analytics and machine learning; and MySQL Cluster CGE. A program for OEM and ISV vendors covers embedding the database in other products.
The server is written in C++ and distributed under licenses detailed in the repository. Organizations can run the Community Edition on their own infrastructure, buy a commercial edition from Oracle, which owns the project, or use a managed cloud offering. Documentation, downloads and a developer zone are available on mysql.com.
Key features
- Open-source relational database server
- SQL query interface
- MySQL Cluster for transactional workloads
- Community and Enterprise editions
- HeatWave managed cloud option
- Documentation and developer resources
Pricing: Community Edition is open source; Enterprise Edition and the HeatWave cloud service are commercial offerings.
#8
A PostgreSQL extension that turns Postgres into a distributed database by sharding tables across a cluster of nodes for scale-out performance.
- GitHub stars
- 13k
- Last commit
- 3 days ago
- Latest release
- v14.3.0
- Licence
- AGPL-3.0
- Self-hosted
- Yes
citusdata.com
Citus is an extension that transforms PostgreSQL into a distributed database so it can keep performing as data and traffic grow. Instead of replacing Postgres, it adds capabilities to it, and because it is an extension it works with recent PostgreSQL versions and the tools and extensions people already use.
Distributed tables are sharded across a cluster of nodes to pool CPU, memory, storage and I/O, while reference tables are replicated to every node for joins and foreign keys. A distributed query engine routes work to the right shards and runs SELECT, DML and other statements in parallel, columnar storage compresses data and speeds up scans, and queries can be sent to any node. More worker nodes can be added and shards rebalanced as data grows.
Typical uses include multi-tenant applications, real-time analytics, high-throughput transactional workloads and time-series or IoT data. Citus is written in C, licensed under AGPL-3.0 and described by its authors as fully open source, and it can start as a single node and scale out later. The project links a SIGMOD paper describing how it works.
Key features
- Distributed tables sharded across nodes
- Reference tables replicated to all nodes
- Distributed query engine with parallel execution
- Columnar storage with compression
- Query from any node in the cluster
- Shard rebalancing when adding workers
Pricing: The Citus extension is free and open source. The managed Azure Cosmos DB for PostgreSQL service starts at about $0.27 per hour, with reserved capacity pricing available.
#9
A distributed relational database developed by Ant Group, MySQL-compatible and built on Paxos, supporting transactional, analytical and vector workloads.
- GitHub stars
- 10k
- Last commit
- yesterday
- Latest release
- v4.6.0_CE_BP1
- Licence
- Apache-2.0
- Self-hosted
- Yes
en.oceanbase.com
OceanBase is a distributed relational database developed by Ant Group. It runs on a cluster of commodity servers and uses the Paxos protocol and a distributed architecture to provide high availability and scalability, without depending on a specific hardware architecture.
It is compatible with MySQL, which eases migration from MySQL databases, and supports hybrid transactional and analytical processing, so one engine can serve both OLTP and OLAP workloads. The project now describes itself as a unified, multi-model database for the AI era, with topics that include vector search and full-text search. Cloud-native operation is supported through a Kubernetes operator.
You can try it by deploying a stand-alone instance with an all-in-one package on Linux, starting a Docker container from images on Docker Hub, quay.io or ghcr.io, or running it on Kubernetes with ob-operator. OceanBase is written in C++ and licensed under Apache-2.0, with a developer guide for compiling the observer yourself.
Key features
- Distributed architecture on Paxos
- Compatible with MySQL applications
- Hybrid transactional and analytical processing
- Vector and full-text search
- Docker and Kubernetes deployment
- All-in-one stand-alone installer
Pricing: Free and open source under the Apache-2.0 licence.
#10
A PostgreSQL-compatible, cloud-native distributed SQL database for transactional workloads that need scale, fault tolerance or multi-region deployment.
- GitHub stars
- 11k
- Last commit
- today
- Latest release
- v2026.1.3.0
- Self-hosted
- Yes
yugabyte.com
YugabyteDB is a distributed SQL database that is compatible with PostgreSQL. It combines the relational features of traditional databases with the scale-out design of NoSQL systems, and is intended for cloud-native OLTP applications that need correct data and at least one of scalability, tolerance to failures or global distribution.
Its SQL layer, YSQL, reuses the PostgreSQL query layer and so supports most PostgreSQL features, including data types, stored procedures, triggers and extensions. Its transaction model follows the design of Google Spanner, using Raft consensus for replication and hybrid logical clocks for distributed ACID transactions, with snapshot, serializable and read committed isolation. Reads are strongly consistent by default and can be tuned to read from followers and replicas.
The database can be configured to withstand failures at the level of a disk, rack, node, zone, region or whole cloud, recovering on its own, and the topics mention multi-region, multi-cloud and Kubernetes deployments. The project is written mainly in C and C++, the repository lists its license as Other, and documentation covers architecture, roadmap and how to build applications.
Key features
- PostgreSQL-compatible SQL layer
- Distributed ACID transactions
- Replication using Raft consensus
- Snapshot, serializable and read committed isolation
- Automatic failover and repair
- Multi-region and multi-cloud deployments
- Kubernetes deployment support
Pricing: The open-source database is free. The managed Aeon service starts at $125 (Standard) or $167 (Professional) per vCPU per month plus storage and transfer, with a free trial; Enterprise is quoted.
Amazon Aurora alternatives: questions
- What is the best open-source alternative to Amazon Aurora?
- PostgreSQL is the top-ranked open-source alternative to Amazon Aurora on Enlisted: PostgreSQL is an object-relational database management system supporting SQL features such as transactions, foreign keys and triggers. Other strong options are TiDB, CockroachDB, TimescaleDB and MariaDB.
- What are the best commercial alternatives to Amazon Aurora?
- Amazon RDS, Google Cloud Spanner, Azure Cosmos DB, Microsoft SQL Server and Oracle Database are among the hosted, closed-source alternatives to Amazon Aurora listed on Enlisted, which lists 26 in total. Compare their pricing and features on each tool page.
- Are these Amazon Aurora alternatives free?
- All 12 are open source, so the code is free to use under its licence, and all of them can be self-hosted on your own server or computer. 5 also offer a paid or managed cloud version if you'd rather not host it yourself.
- How is this list of Amazon Aurora alternatives ranked?
- By a score built from GitHub stars, star growth over the last 30 days and how recently the code changed. 11 of these projects shipped code in the last 30 days. Data is refreshed daily, and nobody can pay to move up.