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

Feature	MySQL	PostgreSQL	TiDB	ClickHouse	Snowflake	MongoDB	Spanner
UI Change Workflow	✔️	✔️	✔️	✔️	✔️	✔️	✔️
GitOps Change Workflow	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Tenant Database Management	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Migration History	✔️	✔️	✔️	✔️	✔️	✔️	✔️
SQL Review Rules	✔️	✔️	✔️
Schema Synchronization	✔️	✔️
Schema Editor	✔️
Online Schema Change	✔️

SQL Editor

Feature	MySQL	PostgreSQL	TiDB	ClickHouse	Snowflake	MongoDB	Spanner
Read-only Mode	✔️	✔️	✔️	✔️	✔️		✔️
Admin Mode	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Sheet Management	✔️	✔️	✔️	✔️	✔️	✔️	✔️

Security

Feature	MySQL	PostgreSQL	TiDB	ClickHouse	Snowflake	MongoDB	Spanner
RBAC	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Database Access Control	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Audit Log	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Data Anonymization	✔️

Disaster Recovery

Feature	MySQL	PostgreSQL	TiDB	ClickHouse	Snowflake	MongoDB	Spanner
Local Backup and Restore	✔️	✔️	✔️	✔️	✔️
Cloud Backup	✔️	✔️	✔️	✔️	✔️
Point-in-time Recovery (PITR)	✔️

Anomaly Detection

Feature	MySQL	PostgreSQL	TiDB	ClickHouse	Snowflake	MongoDB	Spanner
Database Connection Failure	✔️	✔️	✔️	✔️	✔️	✔️	✔️
Drift Detection	✔️	✔️	✔️	✔️	✔️		✔️
Backup Policy Violation	✔️	✔️	✔️	✔️	✔️
Backup Missing	✔️	✔️	✔️	✔️	✔️