> ## Documentation Index
> Fetch the complete documentation index at: https://docs.bytebase.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Supported Databases

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.2 and above  |
|                    | Redis                                  | 6.0 and above  |
|                    | Cassandra                              | 3.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](/change-database/change-workflow/#ui-workflow) | [GitOps Workflow](/change-database/change-workflow/#gitops-workflow) | [Batch Change](/change-database/batch-change) | [SQL Lint](/sql-review/review-policy) | [Data Rollback\*](/change-database/rollback-data-changes) |   |
| :----------------- | :----------------------------------------------------------- | :------------------------------------------------------------------- | :-------------------------------------------- | :------------------------------------ | :-------------------------------------------------------- | - |
| **RDMBS**          |                                                              |                                                                      |                                               |                                       |                                                           |   |
| MySQL              | ✔️                                                           | ✔️                                                                   | ✔️                                            | ✔️                                    | ✔️                                                        |   |
| PostgreSQL         | ✔️                                                           | ✔️                                                                   | ✔️                                            | ✔️                                    | ✔️                                                        |   |
| Oracle             | ✔️                                                           | ✔️                                                                   | ✔️                                            | ✔️                                    | ✔️                                                        |   |
| SQL Server         | ✔️                                                           | ✔️                                                                   | ✔️                                            | ✔️                                    | ✔️                                                        |   |
| MariaDB            | ✔️                                                           | ✔️                                                                   | ✔️                                            | ✔️                                    |                                                           |   |
| TiDB               | ✔️                                                           | ✔️                                                                   | ✔️                                            | ✔️                                    |                                                           |   |
| OceanBase          | ✔️                                                           | ✔️                                                                   | ✔️                                            | ✔️                                    |                                                           |   |
| CockroachDB        | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| Spanner            | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| **NoSQL**          |                                                              |                                                                      |                                               |                                       |                                                           |   |
| MongoDB            | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| Redis              | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| Cassandra          | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| DocumentDB         | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| DynamoDB           | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| Cosmos DB          | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| **Data Warehouse** |                                                              |                                                                      |                                               |                                       |                                                           |   |
| Snowflake          | ✔️                                                           | ✔️                                                                   | ✔️                                            | ✔️                                    |                                                           |   |
| BigQuery           | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| Redshift           | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| Hive               | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| ClickHouse         | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| Databricks         | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| StarRocks          | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |
| **Others**         |                                                              |                                                                      |                                               |                                       |                                                           |   |
| Elasticsearch      | ✔️                                                           | ✔️                                                                   | ✔️                                            |                                       |                                                           |   |

<Note>Data Rollback supports `UPDATE` and `DELETE` statements.</Note>

### SQL Editor

| Feature            | [Sheet Management](/sql-editor/manage-sql-scripts) | [Query Mode](/sql-editor/run-queries) | [Admin Mode](/sql-editor/admin-mode) | [Batch Mode](/sql-editor/run-queries/#batch-mode) | [AI Assistant](/sql-editor/ai-assistant) |
| :----------------- | :------------------------------------------------- | :------------------------------------ | :----------------------------------- | :------------------------------------------------ | :--------------------------------------- |
| **RDBMS**          |                                                    |                                       |                                      |                                                   |                                          |
| MySQL              | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| PostgreSQL         | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| Oracle             | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| SQL Server         | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| MariaDB            | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| TiDB               | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| OceanBase          | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| CockroachDB        | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| Spanner            | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| **NoSQL**          |                                                    |                                       |                                      |                                                   |                                          |
| MongoDB            | ✔️                                                 | ✔️ \*                                 | ✔️                                   | ✔️                                                | ✔️                                       |
| Redis              | ✔️                                                 | ✔️ \*                                 | ✔️                                   | ✔️                                                | ✔️                                       |
| Cassandra          | ✔️                                                 | ✔️ \*                                 | ✔️                                   | ✔️                                                | ✔️                                       |
| DocumentDB         | ✔️                                                 | ✔️ \*                                 | ✔️                                   | ✔️                                                | ✔️                                       |
| DynamoDB           | ✔️                                                 | ✔️ \*                                 | ✔️                                   | ✔️                                                | ✔️                                       |
| Cosmos DB          | ✔️                                                 | ✔️ \*                                 | ✔️                                   | ✔️                                                | ✔️                                       |
| **Data Warehouse** |                                                    |                                       |                                      |                                                   |                                          |
| Snowflake          | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| BigQuery           | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| Redshift           | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| Hive               | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| ClickHouse         | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| Databricks         | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| StarRocks          | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |
| **Others**         |                                                    |                                       |                                      |                                                   |                                          |
| Elasticsearch      | ✔️                                                 | ✔️                                    | ✔️                                   | ✔️                                                | ✔️                                       |

<Note>
  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](/get-started/instance/#read-only-connection).
</Note>

### Data Security & Compliance

| Feature            | [RBAC](/administration/roles) | [Audit](/security/audit-log) | [Secret Manager](/get-started/instance/#use-secret-manager) | [Query Control](/security/database-permission/overview/) | [Data Masking](/security/data-masking/overview) |
| :----------------- | :---------------------------- | :--------------------------- | :---------------------------------------------------------- | :------------------------------------------------------- | :---------------------------------------------- |
| **RDBMS**          |                               |                              |                                                             |                                                          |                                                 |
| MySQL              | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| PostgreSQL         | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| Oracle             | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| SQL Server         | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| MariaDB            | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| TiDB               | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| OceanBase          | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| CockroachDB        | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       |                                                 |
| Spanner            | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       |                                                 |
| **NoSQL**          |                               |                              |                                                             |                                                          |                                                 |
| MongoDB            | ✔️                            | ✔️                           | ✔️                                                          |                                                          | ✔️                                              |
| Redis              | ✔️                            | ✔️                           | ✔️                                                          |                                                          |                                                 |
| Cassandra          | ✔️                            | ✔️                           | ✔️                                                          |                                                          | ✔️                                              |
| DocumentDB         | ✔️                            | ✔️                           | ✔️                                                          |                                                          |                                                 |
| DynamoDB           | ✔️                            | ✔️                           | ✔️                                                          |                                                          |                                                 |
| Cosmos DB          | ✔️                            | ✔️                           | ✔️                                                          |                                                          | ✔️                                              |
| **Data Warehouse** |                               |                              |                                                             |                                                          |                                                 |
| Snowflake          | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| BigQuery           | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       | ✔️                                              |
| Redshift           | ✔️                            | ✔️                           | ✔️                                                          |                                                          |                                                 |
| Hive               | ✔️                            | ✔️                           | ✔️                                                          |                                                          |                                                 |
| ClickHouse         | ✔️                            | ✔️                           | ✔️                                                          | ✔️                                                       |                                                 |
| Databricks         | ✔️                            | ✔️                           | ✔️                                                          |                                                          |                                                 |
| StarRocks          | ✔️                            | ✔️                           | ✔️                                                          |                                                          |                                                 |
| **Others**         |                               |                              |                                                             |                                                          |                                                 |
| Elasticsearch      | ✔️                            | ✔️                           | ✔️                                                          |                                                          | ✔️                                              |

### Schema Management

<Note>
  Schema management is only applicable to RDBMS. If you are looking for a feature not supported in
  your database, please [contact us](/faq/#how-to-reach-us).
</Note>

| Feature    | [Schema Synchronization](/change-database/synchronize-schema) | [Schema Editor](/change-database/schema-editor) | [Online Schema Change](/change-database/online-schema-migration-for-mysql) |
| :--------- | :------------------------------------------------------------ | :---------------------------------------------- | :------------------------------------------------------------------------- |
| **RDBMS**  |                                                               |                                                 |                                                                            |
| MySQL      | ✔️                                                            | ✔️                                              | ✔️                                                                         |
| PostgreSQL | ✔️                                                            | ✔️                                              |                                                                            |
| Oracle     | ✔️                                                            |                                                 |                                                                            |
| SQL Server | ✔️                                                            |                                                 |                                                                            |
| MariaDB    |                                                               |                                                 | ✔️                                                                         |
| TiDB       | ✔️                                                            | ✔️                                              |                                                                            |