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 |
| 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 | ✔️ | ✔️ | ✔️ | | | |
| DocumentDB | ✔️ | ✔️ | ✔️ | | | |
| DynamoDB | ✔️ | ✔️ | ✔️ | | | |
| Cosmos DB | ✔️ | ✔️ | ✔️ | | | |
| Data Warehouse | | | | | | |
| Snowflake | ✔️ | ✔️ | ✔️ | ✔️ | | |
| BigQuery | ✔️ | ✔️ | ✔️ | | | |
| Redshift | ✔️ | ✔️ | ✔️ | | | |
| Hive | ✔️ | ✔️ | ✔️ | | | |
| ClickHouse | ✔️ | ✔️ | ✔️ | | | |
| Databricks | ✔️ | ✔️ | ✔️ | | | |
| StarRocks | ✔️ | ✔️ | ✔️ | | | |
| Others | | | | | | |
| Elasticsearch | ✔️ | ✔️ | ✔️ | | | |
Data Rollback supports UPDATE and DELETE statements.
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 | ✔️ | ✔️ * | ✔️ | ✔️ | ✔️ |
| DocumentDB | ✔️ | ✔️ * | ✔️ | ✔️ | ✔️ |
| DynamoDB | ✔️ | ✔️ * | ✔️ | ✔️ | ✔️ |
| Cosmos DB | ✔️ | ✔️ * | ✔️ | ✔️ | ✔️ |
| Data Warehouse | | | | | |
| Snowflake | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| BigQuery | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Redshift | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Hive | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| ClickHouse | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Databricks | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| StarRocks | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| Others | | | | | |
| Elasticsearch | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
Normally, Bytebase will block non-readonly statements in Query Mode. This is not supported NoSQL
Databases. You can work around this by configuring a readonly
connection. 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 | ✔️ | ✔️ | ✔️ | | | |
| DocumentDB | ✔️ | ✔️ | ✔️ | | | |
| DynamoDB | ✔️ | ✔️ | ✔️ | | | |
| Cosmos DB | ✔️ | ✔️ | ✔️ | | ✔️ | |
| Data Warehouse | | | | | | |
| Snowflake | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ |
| BigQuery | ✔️ | ✔️ | ✔️ | ✔️ | ✔️ | |
| Redshift | ✔️ | ✔️ | ✔️ | | | ✔️ |
| Hive | ✔️ | ✔️ | ✔️ | | | |
| ClickHouse | ✔️ | ✔️ | ✔️ | ✔️ | | ✔️ |
| Databricks | ✔️ | ✔️ | ✔️ | | | |
| StarRocks | ✔️ | ✔️ | ✔️ | | | |
| Others | | | | | | |
| Elasticsearch | ✔️ | ✔️ | ✔️ | | | |
Schema Management
Schema management is only applicable to RDBMS. If you are looking for a feature not supported in
your database, please contact us. 
