← ClaudeAtlas

duckdb-docslisted

Look up exact DuckDB 2.0 and DuckLake manual text in the official full-text indexes. Covers index versions, the BM25 query, caching, and URL handling. Use when a signature, setting, or page needs the current manual and no task skill owns the procedure.
srimon12/duckdb-2-skills · ★ 1 · AI & Automation · score 65
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