Supported database types

Last modified: 11 March 2025

Below is the list of natively supported database types in Datalore.

  • Apache Derby (Remote)

  • Amazon Redshift

  • Apache Hive

  • Apache Ignite

  • Apache Phoenix

  • Apache Phoenix Thin

  • Apache Spark

  • Athena

  • Aurora MySQL (AWS driver)

  • Aurora MySQL (MariaDB driver)

  • Azure SQL Database

  • Azure Synapse Analytics

  • ClickHouse

  • CockroachDB

  • Databricks

  • DuckDB

  • Elasticsearch

  • Exasol

  • Firebird

  • Google BigQuery

  • Google Cloud Spanner

  • Greenplum

  • H2

  • IBM Db2

  • IBM Db2 (JTOpen)

  • IBM Db2 for 9.X, 10.X

  • Informix

  • InterSystems IRIS

  • MariaDB

  • Microsoft SQL Server

  • Microsoft SQL Server (jTds)

  • Mimer SQL

  • MySQL

  • OpenEdge

  • Oracle

  • Oracle for 9.X, 10.X, 11.1

  • PostgreSQL

  • Presto

  • SAP Hana

  • SingleStore

  • SingleStore (MySQL driver)

  • Snowflake

  • Sybase

  • Sybase (jTds)

  • SQLite

  • Tarantool

  • Teradata

  • TiDB

  • Tibero

  • Trino

  • Vertica

  • YugabyteDB