Supported Databases
Bytebase officially supports the following major versions for each supported database engine:
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, both MySQL and Oracle modes
- CockroachDB - 24.1 and above, PostgreSQL compatible syntax supported only
- Spanner
NoSQL
- MongoDB - 4.0 and above
- Redis - 6.0 and above
- DocumentDB
- DynamoDB
Data Warehouse
- Snowflake
- BigQuery
- Redshift
- Hive
- ClickHouse - 21.0 and above
- Databricks
- StarRocks
Others
- Elasticsearch
- 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
| Feature | UI Workflow | GitOps Workflow | Changelist | Batch Change | SQL Lint | Data Rollback* |
|---|---|---|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| PostgreSQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Oracle | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| SQL Server | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| MongoDB | ✔️ | ✔️ | ✔️ | ✔️ | ||
| Redis | ✔️ | ✔️ | ✔️ | ✔️ | ||
| TiDB | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| ClickHouse | ✔️ | ✔️ | ✔️ | ✔️ | ||
| Snowflake | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| Redshift | ✔️ | ✔️ | ✔️ | ✔️ | ||
| Spanner | ✔️ | ✔️ | ✔️ | ✔️ | ||
| MariaDB | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| OceanBase | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| RisingWave | ✔️ | ✔️ | ✔️ | ✔️ | ||
| CockroachDB | ✔️ | ✔️ | ✔️ | ✔️ |
* Data Rollback supports UPDATE and DELETE statements.
SQL Editor
| Feature | Sheet Management | Query Mode | Admin Mode | Batch Mode | AI Assistant |
|---|---|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| PostgreSQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Oracle | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| SQL Server | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| MongoDB | ✔️ | ✔️ * | ✔️ | ✔️ | ✔️ |
| Redis | ✔️ | ✔️ * | ✔️ | ✔️ | ✔️ |
| TiDB | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| ClickHouse | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Snowflake | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Redshift | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Spanner | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| MariaDB | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| OceanBase | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| RisingWave | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| CockroachDB | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
* 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
| Feature | RBAC | Audit Log | External Secret Manager | Query and Export Control | Data Masking |
|---|---|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| PostgreSQL | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Oracle | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| SQL Server | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| MongoDB | ✔️ | ✔️ | ✔️ | ✔️ | |
| Redis | ✔️ | ✔️ | ✔️ | ✔️ | |
| TiDB | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| ClickHouse | ✔️ | ✔️ | ✔️ | ✔️ | |
| Snowflake | ✔️ | ✔️ | ✔️ | ✔️ | |
| Redshift | ✔️ | ✔️ | ✔️ | ✔️ | |
| Spanner | ✔️ | ✔️ | ✔️ | ✔️ | |
| MariaDB | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| OceanBase | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| RisingWave | ✔️ | ✔️ | ✔️ | ✔️ | |
| CockroachDB | ✔️ | ✔️ | ✔️ | ✔️ |
Anomaly Detection
| Feature | Connection Failure | Drift Detection | Slow Query |
|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ |
| PostgreSQL | ✔️ | ✔️ | ✔️ |
| Oracle | ✔️ | ✔️ | |
| SQL Server | ✔️ | ✔️ | |
| MongoDB | ✔️ | ||
| Redis | ✔️ | ||
| TiDB | ✔️ | ✔️ | |
| ClickHouse | ✔️ | ✔️ | |
| Snowflake | ✔️ | ✔️ | |
| Redshift | ✔️ | ✔️ | |
| Spanner | ✔️ | ✔️ | |
| MariaDB | ✔️ | ✔️ | |
| OceanBase | ✔️ | ✔️ | |
| RisingWave | ✔️ | ✔️ | |
| CockroachDB | ✔️ | ✔️ |
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.
| Feature | Schema Synchronization | Schema Editor | Online Schema Change |
|---|---|---|---|
| MySQL | ✔️ | ✔️ | ✔️ |
| PostgreSQL | ✔️ | ✔️ | |
| Oracle | ✔️ | ||
| SQL Server | |||
| MongoDB | |||
| Redis | |||
| TiDB | ✔️ | ✔️ | |
| ClickHouse | |||
| Snowflake | |||
| Redshift | |||
| Spanner | |||
| MariaDB | |||
| OceanBase | |||
| RisingWave | |||
| CockroachDB |
