Introduction /

Supported Databases

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

  • MySQL - 5.7 and 8.0
  • PostgreSQL - 12.0, 13.0, 14.0
  • TiDB - 5.0
  • ClickHouse - 21.0
  • Snowflake
  • MongoDB - 4.0, 5.0, 6.0
  • Spanner (Beta, use at your own risk)

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 Management

FeatureMySQLPostgreSQLTiDBClickHouseSnowflakeMongoDBSpanner
UI Change Workflow✔️✔️✔️✔️✔️✔️✔️
GitOps Change Workflow✔️✔️✔️✔️✔️✔️✔️
Tenant Database Management✔️✔️✔️✔️✔️✔️✔️
Migration History✔️✔️✔️✔️✔️✔️✔️
SQL Review Rules✔️✔️✔️
Schema Synchronization✔️✔️
Schema Editor✔️
Online Schema Change✔️

SQL Editor

FeatureMySQLPostgreSQLTiDBClickHouseSnowflakeMongoDBSpanner
Read-only Mode✔️✔️✔️✔️✔️✔️
Admin Mode✔️✔️✔️✔️✔️✔️✔️
Sheet Management✔️✔️✔️✔️✔️✔️✔️

Security

FeatureMySQLPostgreSQLTiDBClickHouseSnowflakeMongoDBSpanner
RBAC✔️✔️✔️✔️✔️✔️✔️
Database Access Control✔️✔️✔️✔️✔️✔️✔️
Audit Log✔️✔️✔️✔️✔️✔️✔️
Data Anonymization✔️

Disaster Recovery

FeatureMySQLPostgreSQLTiDBClickHouseSnowflakeMongoDBSpanner
Local Backup and Restore✔️✔️✔️✔️✔️
Cloud Backup✔️✔️✔️✔️✔️
Point-in-time Recovery (PITR)✔️

Anomaly Detection

FeatureMySQLPostgreSQLTiDBClickHouseSnowflakeMongoDBSpanner
Database Connection Failure✔️✔️✔️✔️✔️✔️✔️
Drift Detection✔️✔️✔️✔️✔️✔️
Backup Policy Violation✔️✔️✔️✔️✔️
Backup Missing✔️✔️✔️✔️✔️