duckdb-docslisted
Install: claude install-skill srimon12/duckdb-2-skills
# Docs search
Before guessing a signature, setting, or syntax rule, query the hosted documentation index. Use this skill only when no dedicated task skill owns the procedure. Answer strictly from retrieved chunks and cite the exact page. To build an FTS index on user tables, read `duckdb-search`.
## Index versions
| Index | URL | Versions |
| --- | --- | --- |
| DuckDB | `https://duckdb.org/data/docs-search.duckdb` | `2.0`, `blog` |
| DuckLake | `https://ducklake.select/data/docs-search.duckdb` | `stable` |
The DuckDB index provides only `2.0` and `blog` slices; it contains no `lts`, `current`, or `stable` slice. Filter by `version = '2.0'` by default. Include `blog` only when searching for release notes or design motivation. For DuckLake queries, filter by `version = 'stable'` (covers the 1.1 manual).
The `docs_chunks` table has seven columns: `chunk_id`, `page_title`, `section`, `breadcrumb`, `url`, `version`, and `text`. The `url` column stores a relative path (e.g. `/docs/2.0/...`), not an absolute URL.
## Cache
Store the database at `$HOME/.duckdb/docs/duckdb-docs.duckdb` or `ducklake-docs.duckdb`. When the cache file is missing or older than two days, refresh it:
```bash
mkdir -p "$HOME/.duckdb/docs"
cache="$HOME/.duckdb/docs/duckdb-docs.duckdb" # ducklake-docs.duckdb for DuckLake
tmp="$cache.tmp"
duckdb -c "
INSTALL httpfs; LOAD httpfs;
INSTALL fts; LOAD fts;
ATTACH 'https://duckdb.org/data/docs-search.duckdb' AS remote (READ_ONLY);
ATTACH '$tmp' AS tmp;
COPY