Supported Databases

Bytebase officially supports the following major versions for each supported database engine:

  • MySQL, Aurora MySQL - 5.7 and above
  • PostgreSQL, Aurora PostgreSQL, AlloyDB - 12.0 and above
  • TiDB - 5.0 and above
  • ClickHouse - 21.0 and above
  • Snowflake
  • Redshift
  • MongoDB - 4.0 and above
  • Spanner
  • Redis - 6.0 and above
  • Oracle - 11g and above
  • Microsoft SQL Server - 2019 and above
  • MariaDB - 10.7 and above
  • OceanBase - 3.x and above, both MySQL and Oracle modes
  • RisingWave - 1.x and above

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.

Feature Matrix

Change Workflow

FeatureUI WorkflowGitOps WorkflowChangelistBatch ChangeSQL LintData Rollback*
MySQL✔️✔️✔️✔️✔️✔️
PostgreSQL✔️✔️✔️✔️✔️
TiDB✔️✔️✔️✔️✔️✔️
ClickHouse✔️✔️✔️✔️
Snowflake✔️✔️✔️✔️✔️
Redshift✔️✔️✔️✔️
MongoDB✔️✔️✔️✔️
Spanner✔️✔️✔️✔️
Redis✔️✔️✔️✔️
Oracle✔️✔️✔️✔️✔️
SQL Server✔️✔️✔️✔️✔️
MariaDB✔️✔️✔️✔️✔️
OceanBase✔️✔️✔️✔️✔️
RisingWave✔️✔️✔️✔️

* Data Rollback supports UPDATE and DELETE statements.

Advanced Schema Management

Bytebase is trailblazing the schema management landscape. Each database engine requires non-trivial investment. If you are looking for a feature not supported in your database, please contact us.

FeatureBranchingSchema SynchronizationState-based MigrationSchema EditorOnline Schema Change
MySQL✔️✔️✔️✔️✔️
PostgreSQL✔️✔️✔️
TiDB✔️✔️✔️
ClickHouse
Snowflake
Redshift
MongoDB
Spanner
Redis
Oracle✔️
SQL Server
MariaDB
OceanBase
RisingWave

SQL Editor

FeatureSheet ManagementQuery ModeAdmin ModeBatch QueryChatSQL
MySQL✔️✔️✔️✔️✔️
PostgreSQL✔️✔️✔️✔️✔️
TiDB✔️✔️✔️✔️✔️
ClickHouse✔️✔️✔️✔️✔️
Snowflake✔️✔️✔️✔️✔️
Redshift✔️✔️✔️✔️✔️
MongoDB✔️✔️ *✔️✔️✔️
Spanner✔️✔️✔️✔️✔️
Redis✔️✔️ *✔️✔️✔️
Oracle✔️✔️✔️✔️✔️
SQL Server✔️✔️✔️✔️✔️
MariaDB✔️✔️✔️✔️✔️
OceanBase✔️✔️✔️✔️✔️
RisingWave✔️✔️✔️✔️✔️

* Normally, Bytebase will block non-readonly statements in Query Mode. This is not supported in MongoDB and Redis. You can work around this by configuring a readonly connection.

Data Security & Compliance

FeatureRBACAudit LogExternal Secret ManagerQuery and Export ControlData Masking
MySQL✔️✔️✔️✔️✔️
PostgreSQL✔️✔️✔️✔️✔️
TiDB✔️✔️✔️✔️✔️
ClickHouse✔️✔️✔️✔️
Snowflake✔️✔️✔️✔️
Redshift✔️✔️✔️✔️
MongoDB✔️✔️✔️✔️
Spanner✔️✔️✔️✔️
Redis✔️✔️✔️✔️
Oracle✔️✔️✔️✔️✔️
SQL Server✔️✔️✔️✔️✔️
MariaDB✔️✔️✔️✔️✔️
OceanBase✔️✔️✔️✔️✔️
RisingWave✔️✔️✔️✔️

Anomaly Detection

FeatureConnection FailureDrift DetectionSlow Query
MySQL✔️✔️✔️
PostgreSQL✔️✔️✔️
TiDB✔️✔️
ClickHouse✔️✔️
Snowflake✔️✔️
Redshift✔️✔️
MongoDB✔️
Spanner✔️✔️
Redis✔️
Oracle✔️✔️
SQL Server✔️✔️
MariaDB✔️✔️
OceanBase✔️✔️
RisingWave✔️✔️
Edit this page on GitHub

Subscribe to Newsletter

By subscribing, you agree with Bytebase's Terms of Service and Privacy Policy.