Skip to main content

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)

Marimo SQL cell with Hotdata selected in the database connections picker

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)

Source distribution for hotdata-marimo 0.1.4
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)

Table of built distributions (wheels) for hotdata-marimo 0.1.4
File Interpreter ABI Platform Actions
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 log

Release 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 log

Security 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.

Select from 2 files

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 log

A 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.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page