# Configure the list of available databases

When configuring your Datalore On-Premises instance, you can customize the list of database connectors available to users. This allows you to enforce your organization’s environment-specific requirements or security policies to align with your environment requirements or security policies.

By modifying the list, you control what connectors are visible in the UI and what database connections users are allowed to [configure using connection strings](connect-to-a-database-using-url.html).

> **Warning:**
> If a database ID is added to both lists, the database is excluded from the list of available database connections.

Procedure: Allow databases

To allow only specific database types to be available when [creating a connection](database-integration.html), list the corresponding database IDs in the configuration file.

Docker deployment:

In `docker-compose.yaml`, add the IDs from the [supported database list](#supported-databases) as a comma-separated list to `environment.DATABASES_FILTER_INCLUDE` as in the following example:

```YAML
environment:
  ...
  DATABASES_FILTER_INCLUDE: "postgresql, clickhouse, mariadb"
```

Kubernetes deployment:

In `datalore.values.yaml`, add the IDs from the [supported database list](#supported-databases) as a comma-separated list to `dataloreEnv.DATABASES_FILTER_INCLUDE` as in the following example:

```YAML
dataloreEnv:
  ...
  DATABASES_FILTER_INCLUDE: "postgresql, clickhouse, mariadb"
```

If the list is empty, all default database types will be available.

> **Note:**
> The configuration format changed from `databases.filter.include` to `DATABASES_FILTER_INCLUDE` in Datalore 2026.1. Configurations created for earlier versions require updates.

Procedure: Hide databases

To hide specific database types when [creating a connection](database-integration.html), list the corresponding database IDs in the configuration file.

Docker deployment:

In `docker-compose.yaml`, add the IDs from the [supported database list](#supported-databases) as a comma-separated list to `environment.DATABASES_FILTER_EXCLUDE` as in the following example:

```YAML
environment:
  ...
  DATABASES_FILTER_EXCLUDE: "elasticsearch, oracle"
```

Kubernetes deployment:

In `datalore.values.yaml`, add the IDs from the [supported database list](#supported-databases) as a comma-separated list to `dataloreEnv.DATABASES_FILTER_EXCLUDE` as in the following example:

```YAML
dataloreEnv:
  ...
  DATABASES_FILTER_EXCLUDE: "elasticsearch, oracle"
```

> **Note:**
> The configuration format changed from `databases.filter.exclude` to `DATABASES_FILTER_EXCLUDE` in Datalore 2026.1. Configurations created for earlier versions require updates.

If the list is empty, all default database types will be available.

## Supported databases

| Database name | Database ID |
| --- | --- |
| ![Athena](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/athena.svg) Athena | `athena` |
| ![Spanner](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/spanner.svg) Google Cloud Spanner | `cloudspanner` |
| ![Elastic](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/elastic.svg)  Elasticsearch | `elasticsearch` |
| ![Firebird](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/firebird.svg) Firebird | `firebird` |
| ![H2](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/h2.svg) SAP Hana | `hana` |
| ![Informix](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/informix.svg) Informix | `informix` |
| ![Intersystem](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/intersystem.svg) InterSystems IRIS | `intersystemsiris` |
| ![Openedge](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/openedge.svg) OpenEdge | `openedge` |
| ![Phoenix](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/phoenix.svg) Apache Phoenix | `phoenix.thick` |
| ![Phoenix](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/phoenix.svg) Apache Phoenix Thin | `phoenix.thin` |
| ![Presto](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/presto.svg) Presto | `presto` |
| ![Tarantool](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/tarantool.svg) Tarantool | `tarantool` |
| ![Teradata](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/teradata.svg) Teradata | `teradata` |
| ![Tibero](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/tibero.svg) Tibero | `tibero` |
| ![Trino](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/trino.svg) Trino | `trino` |
| ![Mimer sql](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/mimer-sql.svg) Mimer SQL | `mimiersql` |
| ![Ignite](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/ignite.svg) Apache Ignite | `ignite` |
| ![Bigquery](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/bigquery.svg) Google BigQuery | `bigquery` |
| ![Clickhouse](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/clickhouse.svg) ClickHouse | `clickhouse` |
| ![Db2](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/db2.svg) IBM Db2 | `db2.11` |
| ![Db2](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/db2.svg) IBM Db2 for 9.X, 10.X | `db2` |
| ![Db2](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/db2.svg) IBM Db2 (JTOpen) | `db2.jtopen` |
| ![Derby](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/derby.svg) Apache Derby (Remote) | `derby.remote` |
| ![Exasol](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/exasol.svg) Exasol | `exasol` |
| ![H2](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/h2.svg) H2 | `h2.unified` |
| ![Hive](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/hive.svg) Apache Hive | `hive` |
| ![Mariadb](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/mariadb.svg) MariaDB | `mariadb` |
| ![Sql server](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/sql-server.svg) Microsoft SQL Server | `sqlserver.ms` |
| ![Sql server](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/sql-server.svg) Microsoft SQL Server (jTds) | `sqlserver.jtds` |
| ![Azure](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/azure.svg) Azure SQL Database | `azure.ms` |
| ![Sql server](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/sql-server.svg) Microsoft SQL Server LocalDB | `sqlserver.localdb.jtds` |
| ![Azure](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/azure.svg) Azure Synapse Analytics | `synapse.ms` |
| ![Mysql](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/mysql.svg) MySQL | `mysql.8` |
| ![Singlestore](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/singlestore.svg) SingleStore | `memsql` |
| ![Tidb](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/tidb.svg) TiDB | `tidb` |
| ![Mysql](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/mysql.svg) Amazon Aurora MySQL | `mysql_aurora` |
| ![Oracle](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/oracle.svg) Oracle | `oracle.19` |
| ![Oracle](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/oracle.svg) Oracle for 9.X, 10.X, 11.1 | `oracle` |
| ![Postgres](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/postgres.svg) PostgreSQL | `postgresql` |
| ![Yugabyte](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/yugabyte.svg) YugabyteDB | `yugabyte` |
| ![Cockroach db](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/cockroach-db.svg) CockroachDB | `cockroach` |
| ![Greenplum](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/greenplum.svg) Greenplum | `greenplum` |
| ![Redshift](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/redshift.svg) Amazon Redshift | `redshift` |
| ![Snowflake](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/snowflake.svg) Snowflake | `snowflake` |
| ![Spark](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/spark.svg) Apache Spark | `spark` |
| ![Sybase](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/sybase.svg) Sybase (jTds) | `sybase.jtds` |
| ![Sybase](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/sybase.svg) Sybase | `sybase.ase` |
| ![Vertica](https://resources.jetbrains.com.cn/help/img/datalore/2026.3/vertica.svg) Vertica | `vertica` |