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 74 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

74

With Documentation

74/ 74

Multiple Drivers

26

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	ConnectionDriversErrors
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	Connection
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	Connection
Databricks Interactive Cluster Apache Hive is a data warehouse infrastructure built on Hadoop.	Apache ProjectsQuery EnginesOpen Source	140/201	10 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelCost Est.Impersonation	Connection
base	Other Databases	109/201	19 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadCost Est.	ConnectionErrors
Aurora PostgreSQL (Data API) 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 PostgreSQLAurora PostgreSQL (Data API) 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
Greenplum VMware Greenplum is a massively parallel processing (MPP) database built on Post...	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
StarRocks StarRocks is a high-performance analytical database for real-time analytics.	Analytical DatabasesOpen Source	89/201	9 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery CancelImpersonation	ConnectionDriversErrors
CelerDataStarRocks compatible CelerData is a fully-managed cloud analytics service built on StarRocks. It prov...	Analytical DatabasesCloud Data WarehousesHosted Open Source	89/201	9 grains	JOINsSubqueriesDynamic SchemaCatalogSSH	Connection
Google BigQuery Google BigQuery is a serverless, highly scalable data warehouse.	Cloud - GoogleAnalytical DatabasesProprietary	83/201	13 grains	JOINsSubqueriesCatalogFile UploadCost Est.	ConnectionAuthErrors
Apache Doris Apache Doris is a high-performance real-time analytical database.	Apache ProjectsAnalytical DatabasesOpen Source	79/201	9 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery Cancel	ConnectionErrors
Snowflake Snowflake is a cloud-native data warehouse.	Cloud Data WarehousesAnalytical DatabasesProprietary	72/201	12 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile UploadQuery Cancel	ConnectionAuthErrors
Databricks Databricks is a unified analytics platform built on Apache Spark, providing data...	Cloud Data WarehousesAnalytical DatabasesHosted Open Source	70/201	10 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile Upload	ConnectionDrivers
Databricks (legacy)	Cloud Data Warehouses	70/201	10 grains	JOINsSubqueriesDynamic SchemaCatalogSSHFile Upload	Connection

• 87 databases
• 1
• 2
• 3
• 4
• 5
• 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.