SQL 🛢️

These examples show how to use marimo's built-in support for SQL, which is powered by duckdb, a fast in-process analytical database.

• querying_dataframes.py shows hows to query Pandas or Polars dataframes
• paremetrizing_sql_queries.py shows hows to parametrize queries with Python values
• read_csv.py shows hows to read CSV data into duckdb
• read_json.py shows hows to read JSON data into duckdb
• read_parquet.py shows hows to read parquet data into duckdb
• connect_to_persistent_db.py shows hows to connect to a duckdb persistent database
• connect_to_sqlite.py shows hows to connect to a SQLite database
• connect_to_postgres.py shows hows to connect to a PostgreSQL database
• connect_to_motherduck.py shows hows to connect to motherduck
• histograms.py shows hows to plot histograms of a column's values
• misc/ contains illustrative examples

[!TIP] For a broad overview of using SQL in marimo, run marimo tutorial sql at the command-line.

Consult the duckdb documentation for a comprehensive guide on duckdb.

Running examples

The requirements of each notebook are serialized in them as a top-level comment. Here are the steps to open an example notebook:

1. Install uv
2. Open an example with uvx marimo edit --sandbox <notebook-url>

[!TIP] The --sandbox flag opens the notebook in an isolated virtual environment, automatically installing the notebook's dependencies 📦

You can also open notebooks without uv, in which case you'll need to manually install marimo first. Then run marimo edit <notebook-url>; however, you'll also need to install the requirements yourself.