hotdata-marimo
Marimo widgets for Hotdata — run SQL, browse your schema, and work with managed databases in reactive notebooks.
Install
pip install hotdata-marimo
Authentication
Set HOTDATA_API_KEY in your environment. Optionally set HOTDATA_WORKSPACE to pin a specific workspace (the first available workspace is used if unset).
Quickstart
Because Marimo reruns cells reactively, construct a widget in one cell and read its .ui or .result in the next.
# Cell 1
import hotdata_marimo as hm
client = hm.from_env()
editor = hm.sql_editor(client, default_sql="SELECT 1 AS ok")
return editor.ui
# Cell 2
return hm.query_result(editor.result)
Click Run on Hotdata after editing SQL. The editor caches the last successful result so downstream cells don't re-query on every refresh.
Workspace selection
If you have multiple workspaces or HOTDATA_WORKSPACE is unset, add an interactive picker. ws.client updates when the selection changes:
ws = hm.workspace_selector_from_env()
client = ws.client
return ws.ui
Native Marimo SQL cells
Register the Hotdata engine once and Hotdata will appear as a selectable engine in the SQL connection picker:
# Setup cell
import marimo as mo
import hotdata_marimo as hm
hm.register_hotdata_sql_engine()
client = hm.from_env()
# Any SQL cell
_df = mo.sql("SELECT * FROM orders LIMIT 10", engine=client)
Browse your schema
The table browser lets you pick a connection, search for a table, and inspect its columns — with a starter query ready to copy:
browser = hm.table_browser(client)
return browser.ui
Use browser.selected_table in downstream cells to reference the chosen table.
Managed databases
View existing managed databases and load new parquet files from a single tabbed panel:
writer = hm.managed_database_writer(client)
return writer.tab_ui
Or show just the read-only panel:
return hm.databases_panel(client)
All widgets
| Widget | Code | What you get |
|---|---|---|
| SQL editor | hm.sql_editor(client) |
.ui to show the editor, .result to read rows |
| Query result | hm.query_result(result) |
Renders a QueryResult as a table |
| Table browser | hm.table_browser(client) |
Browse connections, tables, and column metadata |
| Managed databases | hm.databases_panel(client) |
Read-only list of managed databases |
| Database writer | hm.managed_database_writer(client) |
Create databases and load parquet files |
| Workspace picker | hm.workspace_selector_from_env() |
Dropdown to switch workspaces |
| Connection picker | hm.connection_picker(client) |
Dropdown of connections in the workspace |
| Connection status | hm.connection_status(client) |
Health callout for the API and workspace |
| Connections panel | hm.connections_panel(client) |
Status + list of connections |
| Recent results | hm.recent_results(client) |
Browse past query results |
| Run history | hm.run_history(client) |
Recent query runs |
All widgets are also available as mo.ui.hotdata_* aliases (e.g. mo.ui.hotdata_sql_editor) for discovery via Marimo's autocomplete.
Demo notebook
uv run marimo edit examples/demo.py --no-token
The demo combines workspace selection, schema browsing, managed databases, query history, and a native SQL cell in a single tabbed interface.
Development
uv sync --locked
uv run pytest
Metadata
Release files for hotdata-marimo 0.1.4
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| hotdata_marimo-0.1.4.tar.gz | 178.1 kB | With provenance | Details for hotdata_marimo-0.1.4.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| hotdata_marimo-0.1.4-py3-none-any.whl | Python 3 | none | any | Details for hotdata_marimo-0.1.4-py3-none-any.whl |
Total release size: 194.8 kB
Release files / hotdata_marimo-0.1.4.tar.gz
| Download URL | hotdata_marimo-0.1.4.tar.gz |
|---|---|
| Size | 178.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
450a5bd41f454959d7297e75ec9ac4e4122adbe0382c140f9f371736b8ca7207
|
|
BLAKE2b-256 checksum How to use checksums |
9e4227e6b6d3ad0e3a42c7024115bafca6cdb27c4697704d1af58db5a98296a6
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Jun 27, 2026.
Transparency logRelease files / hotdata_marimo-0.1.4-py3-none-any.whl
| Download URL | hotdata_marimo-0.1.4-py3-none-any.whl |
|---|---|
| Size | 16.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
c5df8b002b5683fd95238fc69e4ef96bf2e24b3d6834347ec7c66838be10955b
|
|
BLAKE2b-256 checksum How to use checksums |
f79c8387c289c005343f50d85427ae6ba169c1025905996961c14836ba114410
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Jun 27, 2026.
Transparency logSecurity for hotdata-marimo 0.1.4
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
Full provenance
Both files in this release have been uploaded with provenance metadata.
Attestation for hotdata_marimo-0.1.4.tar.gz
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Jun 27, 2026.
Transparency logA note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.