duckdb-lakehouselisted
Install: claude install-skill srimon12/duckdb-2-skills
# Lakehouse catalogs
For raw Parquet or CSV on object storage without a catalog, hand off to `duckdb-files`. This skill governs table formats and catalogs: DuckLake, Iceberg, Delta Lake, and Unity Catalog.
Run SQL with `duckdb`. Extensions (`ducklake`, `iceberg`, `delta`, `unity_catalog`) autoload on first use when installation is permitted; otherwise execute `INSTALL AND LOAD <extension>;`.
## Identify the path first
Before selecting an extension, identify the path format by inspecting directory signals. If no signal matches, list the directory and halt. Never glob data files when a catalog is authoritative.
| Signal | Format | First move |
| --- | --- | --- |
| `_delta_log/` | Delta | Run `delta_scan` or `ATTACH ... (TYPE delta)` |
| `metadata/version-hint.text` and `metadata/*.metadata.json` | Iceberg | Run `iceberg_scan` or attach a REST catalog |
| `ducklake:` URI or `ducklake_*` metadata tables | DuckLake | Run `ATTACH 'ducklake:...'` |
| Parquet or CSV files only | Plain files | Hand off to `duckdb-files` |
## Choose the format
| Format | Concurrent writers | Catalog | Time travel | DuckDB write support | Best fit |
| --- | --- | --- | --- | --- | --- |
| Native `.duckdb` | Single process | None | No | Full DDL and DML | Single-process analytics, embedded app state |
| DuckLake | Multi-writer (catalog DB) | DuckDB file, SQLite, or PostgreSQL | Snapshot ID or timestamp | DDL, DML, `MERGE`, ACID transactions | DuckDB-native lakehouse, multi-writer ACID |
| Iceberg