# lake-query

> Claude/Codex skill by [@oleanderhq](https://omgskills.com/library/oleanderhq/index.md) · 4 stars · Updated 2026-08-10

Runs lake SQL through oleander's query router: query\_run for reads, query\_submit for writes, spark\_sql\_submit for named Spark jobs. Use when querying oleander lake tables, exploring data, writing query results to a table, or handling engine routing and billing errors.

## Install

```sh
git clone https://github.com/OleanderHQ/claude-plugin /tmp/claude-plugin && ln -s /tmp/claude-plugin/skills/lake-query ~/.claude/skills/lake-query
```

## From README

Lake Query oleander routes the query. It parses the SQL, estimates how much data the referenced tables hold, and picks the engine and machine size to match. Pick the tool by whether the query changes data — not by how big it is. | Tool | Use for | | --- | --- | | queryrun | Reads. Rows come back on the call. | | querysubmit | Anything that changes data, and reads too large to return interactively. | | sparksqlsubmit | Spark jobs needing a durable job name or explicit machine types. | Leave engine as auto unless the user asked for a specific one. Every response carries enginedecision; use its reasons when telling the user why a query ran the way it did. Reads — queryrun queryrun is read-only and enforces it: INSERT, UPDATE, DELETE, MERGE, CREATE, ALTER, DROP, and TRUNCATE are rejected before the request goes out. That is what makes its readOnlyHint true, so clients can skip the confirmation prompt.

## Links

- HTML page: https://omgskills.com/library/oleanderhq/claude-plugin/skills/lake-query/
- GitHub: https://github.com/OleanderHQ/claude-plugin
- Author: [@oleanderhq](https://omgskills.com/library/oleanderhq/index.md)

## More from this repo

- [lake-catalog](https://omgskills.com/library/oleanderhq/claude-plugin/skills/lake-catalog/index.md) — Engine-agnostic oleander lake catalog conventions: catalog.namespace.table naming, hierarchy, and catalog-qualified...
   - [@oleanderhq](https://omgskills.com/library/oleanderhq/index.md) · 4 stars
- [polars-submit](https://omgskills.com/library/oleanderhq/claude-plugin/skills/polars-submit/index.md) — Runs Polars queries or scripts on oleander via the CLI, in local or distributed mode, and saves results to the lake...
   - [@oleanderhq](https://omgskills.com/library/oleanderhq/index.md) · 4 stars
- [spark-best-practices](https://omgskills.com/library/oleanderhq/claude-plugin/skills/spark-best-practices/index.md) — General Apache Spark best practices for scalable, maintainable DataFrame jobs: avoid driver materialization, reduce...
   - [@oleanderhq](https://omgskills.com/library/oleanderhq/index.md) · 4 stars