Supported Databases - Bytebase Docs (original) (raw)

Bytebase officially supports the following major versions for each supported database engine. Bytebase usually works fine with older database versions, we just won’t support features specific to those older versions. We may add other open source databases in the future.

Supported Database Versions

Category	Database	Version
RDBMS	MySQL, Aurora MySQL	5.7 and above
PostgreSQL, Aurora PostgreSQL, AlloyDB	12.0 and above
Oracle	11g and above
Microsoft SQL Server	2019 and above
MariaDB	10.7 and above
TiDB	5.0 and above
OceanBase	3.x and above
CockroachDB	24.1 and above
Spanner	All versions
NoSQL	MongoDB	4.0 and above
Redis	6.0 and above
Cassandra	3.0 and above
DocumentDB	All versions
DynamoDB	All versions
Cosmos DB	All versions
Data Warehouse	Snowflake	All versions
BigQuery	All versions
Redshift	All versions
Hive	All versions
ClickHouse	21.0 and above
Databricks	All versions
StarRocks	All versions
Others	Elasticsearch	All versions

Feature Matrix

Change Workflow

Feature	UI Workflow	GitOps Workflow	Batch Change	SQL Lint	Data Rollback*
RDMBS
MySQL	✔️	✔️	✔️	✔️	✔️
PostgreSQL	✔️	✔️	✔️	✔️	✔️
Oracle	✔️	✔️	✔️	✔️	✔️
SQL Server	✔️	✔️	✔️	✔️	✔️
MariaDB	✔️	✔️	✔️	✔️
TiDB	✔️	✔️	✔️	✔️
OceanBase	✔️	✔️	✔️	✔️
CockroachDB	✔️	✔️	✔️
Spanner	✔️	✔️	✔️
NoSQL
MongoDB	✔️	✔️	✔️
Redis	✔️	✔️	✔️
Cassandra	✔️	✔️	✔️
DocumentDB	✔️	✔️	✔️
DynamoDB	✔️	✔️	✔️
Cosmos DB	✔️	✔️	✔️
Data Warehouse
Snowflake	✔️	✔️	✔️	✔️
BigQuery	✔️	✔️	✔️
Redshift	✔️	✔️	✔️
Hive	✔️	✔️	✔️
ClickHouse	✔️	✔️	✔️
Databricks	✔️	✔️	✔️
StarRocks	✔️	✔️	✔️
Others
Elasticsearch	✔️	✔️	✔️

SQL Editor

Feature	Sheet Management	Query Mode	Admin Mode	Batch Mode	AI Assistant
RDBMS
MySQL	✔️	✔️	✔️	✔️	✔️
PostgreSQL	✔️	✔️	✔️	✔️	✔️
Oracle	✔️	✔️	✔️	✔️	✔️
SQL Server	✔️	✔️	✔️	✔️	✔️
MariaDB	✔️	✔️	✔️	✔️	✔️
TiDB	✔️	✔️	✔️	✔️	✔️
OceanBase	✔️	✔️	✔️	✔️	✔️
CockroachDB	✔️	✔️	✔️	✔️	✔️
Spanner	✔️	✔️	✔️	✔️	✔️
NoSQL
MongoDB	✔️	✔️ *	✔️	✔️	✔️
Redis	✔️	✔️ *	✔️	✔️	✔️
Cassandra	✔️	✔️ *	✔️	✔️	✔️
DocumentDB	✔️	✔️ *	✔️	✔️	✔️
DynamoDB	✔️	✔️ *	✔️	✔️	✔️
Cosmos DB	✔️	✔️ *	✔️	✔️	✔️
Data Warehouse
Snowflake	✔️	✔️	✔️	✔️	✔️
BigQuery	✔️	✔️	✔️	✔️	✔️
Redshift	✔️	✔️	✔️	✔️	✔️
Hive	✔️	✔️	✔️	✔️	✔️
ClickHouse	✔️	✔️	✔️	✔️	✔️
Databricks	✔️	✔️	✔️	✔️	✔️
StarRocks	✔️	✔️	✔️	✔️	✔️
Others
Elasticsearch	✔️	✔️	✔️	✔️	✔️

Data Security & Compliance

Feature	RBAC	Audit	Secret Manager	Query Control	Data Masking	Detect Drift
RDBMS
MySQL	✔️	✔️	✔️	✔️	✔️	✔️
PostgreSQL	✔️	✔️	✔️	✔️	✔️	✔️
Oracle	✔️	✔️	✔️	✔️	✔️	✔️
SQL Server	✔️	✔️	✔️	✔️	✔️	✔️
MariaDB	✔️	✔️	✔️	✔️	✔️	✔️
TiDB	✔️	✔️	✔️	✔️	✔️	✔️
OceanBase	✔️	✔️	✔️	✔️	✔️
CockroachDB	✔️	✔️	✔️	✔️
Spanner	✔️	✔️	✔️	✔️
NoSQL
MongoDB	✔️	✔️	✔️
Redis	✔️	✔️	✔️
Cassandra	✔️	✔️	✔️	✔️
DocumentDB	✔️	✔️	✔️
DynamoDB	✔️	✔️	✔️
Cosmos DB	✔️	✔️	✔️	✔️
Data Warehouse
Snowflake	✔️	✔️	✔️	✔️	✔️	✔️
BigQuery	✔️	✔️	✔️	✔️	✔️
Redshift	✔️	✔️	✔️	✔️
Hive	✔️	✔️	✔️
ClickHouse	✔️	✔️	✔️	✔️	✔️
Databricks	✔️	✔️	✔️
StarRocks	✔️	✔️	✔️
Others
Elasticsearch	✔️	✔️	✔️

Schema Management

Feature	Schema Synchronization	Schema Editor	Online Schema Change
RDBMS
MySQL	✔️	✔️	✔️
PostgreSQL	✔️	✔️
Oracle	✔️
SQL Server	✔️
MariaDB	✔️
TiDB	✔️	✔️