superset_database_create
Create a new database connection in Apache Superset with a name and SQLAlchemy URI, enabling SQL Lab exposure, CTAS, CVAS, DML, and async queries.
Instructions
Create a new database connection.
IMPORTANT: Superset validates database availability on creation. The URI must be reachable from the Superset server (not the client's localhost).
Args: database_name: Human-readable connection name. sqlalchemy_uri: SQLAlchemy connection URI string. Examples: - PostgreSQL: postgresql://user:pass@host:5432/dbname - MySQL: mysql://user:pass@host:3306/dbname - SQLite: sqlite:///path/to/db.sqlite expose_in_sqllab: Whether to show in SQL Lab (default True). allow_ctas: Allow CREATE TABLE AS SELECT. allow_cvas: Allow CREATE VIEW AS SELECT. allow_dml: Allow INSERT/UPDATE/DELETE. allow_run_async: Allow asynchronous query execution. extra: JSON string with additional settings (engine_params, metadata_params).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| extra | No | ||
| allow_dml | No | ||
| allow_ctas | No | ||
| allow_cvas | No | ||
| database_name | Yes | ||
| sqlalchemy_uri | Yes | ||
| allow_run_async | No | ||
| expose_in_sqllab | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |