Connecting to Databases

Superset does not ship bundled with connectivity to databases. The main step in connecting Superset to a database is to install the proper database driver(s) in your environment.

note

You'll need to install the required packages for the database you want to use as your metadata database as well as the packages needed to connect to the databases you want to access through Superset. For information about setting up Superset's metadata database, please refer to installation documentations (Docker Compose, Kubernetes)

Supported Databases

Superset supports 67 databases with varying levels of feature support. Click on any database name to see detailed documentation including connection strings, authentication methods, and configuration options.

Total Databases

67

With Documentation

67/ 67

Multiple Drivers

34

Auth Methods

4

Filter by category

Database	Categories	Score	Time Grains	Features	Documentation
Presto Presto is a distributed SQL query engine for big data.	Query EnginesOpen Source	159/201	19 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelCost Est.ImpersonationSQL Validation	ConnectionDrivers
Trino Trino is a distributed SQL query engine for big data analytics.	Query EnginesOpen Source	149/201	19 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelCost Est.Impersonation	ConnectionDrivers
Starburst GalaxyTrino compatible Starburst Galaxy is a fully-managed cloud analytics platform built on Trino. It ...	Query EnginesCloud Data WarehousesHosted Open Source	149/201	19 grains	JOINsSubqueriesDynamic SchemaCatalogSSH	Connection
Starburst EnterpriseTrino compatible Starburst Enterprise is a self-managed Trino distribution with enterprise featur...	Query EnginesHosted Open Source	149/201	19 grains	JOINsSubqueriesDynamic SchemaCatalogSSH	Connection
Apache Hive Apache Hive is a data warehouse infrastructure built on Hadoop.	Apache ProjectsQuery EnginesOpen Source	140/201	10 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelCost Est.Impersonation	ConnectionDrivers
Apache Spark SQL Apache Spark SQL is a module for structured data processing.	Apache ProjectsQuery EnginesOpen Source	140/201	10 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelCost Est.Impersonation	ConnectionDrivers
PostgreSQL PostgreSQL is an advanced open-source relational database.	Traditional RDBMSOpen Source	104/201	14 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelCost Est.SQL Validation	Connection
Amazon Aurora PostgreSQLPostgreSQL compatible Amazon Aurora PostgreSQL is a fully managed, PostgreSQL-compatible relational da...	Cloud - AWSHosted Open Source	104/201	14 grains	JOINsSubqueriesDynamic SchemaCatalogSSH	Connection
CockroachDB CockroachDB is a distributed SQL database built for cloud applications.	Traditional RDBMSOpen Source	94/201	14 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelCost Est.	Connection
RisingWave RisingWave is a distributed streaming database.	Analytical DatabasesOpen Source	94/201	14 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelCost Est.	Connection
Apache Doris Apache Doris is a high-performance real-time analytical database.	Apache ProjectsAnalytical DatabasesOpen Source	79/201	9 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery Cancel	ConnectionDrivers
Snowflake Snowflake is a cloud-native data warehouse.	Cloud Data WarehousesAnalytical DatabasesProprietary	72/201	12 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery Cancel	ConnectionAuth
StarRocks StarRocks is a high-performance analytical database for real-time analytics.	Analytical DatabasesOpen Source	69/201	9 grains	JOINsSubqueriesDynamic SchemaSSHFile UploadQuery CancelImpersonation	ConnectionDrivers
CelerDataStarRocks compatible CelerData is a fully-managed cloud analytics service built on StarRocks. It prov...	Analytical DatabasesCloud Data WarehousesHosted Open Source	69/201	9 grains	JOINsSubqueriesDynamic SchemaSSH	Connection
SingleStore SingleStore is a distributed SQL database for real-time analytics and transactio...	Analytical DatabasesProprietary	68/201	8 grains	JOINsSubqueriesDynamic SchemaSSHFile UploadQuery Cancel	ConnectionDrivers
Google Sheets Google Sheets allows querying spreadsheets as SQL tables via shillelagh.	Cloud - GoogleHosted Open Source	61/201	21 grains	JOINsSubqueriesFile UploadImpersonation	Connection
MariaDB MariaDB is a community-developed fork of MySQL.	Traditional RDBMSOpen Source	59/201	9 grains	JOINsSubqueriesDynamic SchemaSSHFile UploadQuery Cancel	ConnectionDrivers
MySQL MySQL is a popular open-source relational database.	Traditional RDBMSOpen Source	59/201	9 grains	JOINsSubqueriesDynamic SchemaSSHFile UploadQuery Cancel	ConnectionDrivers
Amazon Aurora MySQLMySQL compatible Amazon Aurora MySQL is a fully managed, MySQL-compatible relational database wit...	Cloud - AWSHosted Open Source	59/201	9 grains	JOINsSubqueriesDynamic SchemaSSH	Connection
ClickHouse ClickHouse is an open-source column-oriented database for real-time analytics us...	Analytical DatabasesOpen Source	51/201	11 grains	JOINsSubqueriesSSH	ConnectionDrivers

• 78 databases
• 1
• 2
• 3
• 4
• 20 / page

Installing Database Drivers

Superset requires a Python DB-API database driver and a SQLAlchemy dialect to be installed for each database engine you want to connect to.

Installing Drivers in Docker

For Docker deployments, create a requirements-local.txt file in the docker directory:

# Create the requirements file
touch ./docker/requirements-local.txt

# Add your driver (e.g., for PostgreSQL)
echo "psycopg2-binary" >> ./docker/requirements-local.txt

Then restart your containers. The drivers will be installed automatically.

Installing Drivers with pip

For non-Docker installations:

pip install <driver-package>

See individual database pages for the specific driver packages needed.

Connecting Through the UI

1. Go to Settings → Data: Database Connections
2. Click + DATABASE
3. Select your database type or enter a SQLAlchemy URI
4. Click Test Connection to verify
5. Click Connect to save

Contributing

To add or update database documentation, add a metadata attribute to your engine spec class in superset/db_engine_specs/. Documentation is auto-generated from these metadata attributes.

See METADATA_STATUS.md for the current status of database documentation and the README for the metadata schema.

Developer Note

This documentation was built without Flask context, so feature diagnostics (scores, time grain support, etc.) may not reflect actual database capabilities. For full diagnostics, build docs locally with:

cd docs && npm run gen-db-docs

This requires a working Superset development environment.