skills.rest
duckdb
duckdbOFFICIAL
Explore all skills by this author →
Website𝕏@duckdbGitHub

duckdb-docs

Search DuckDB and DuckLake documentation using full-text BM25 search against cached indexes.

591|35|Updated Mar 10, 2026
Search Tags:#full-text search#duckdb#documentation search#ducklake#bm25#fts#sql reference
One-click install
npx skills add https://github.com/duckdb/duckdb-skills --skill duckdb-docs-duckdb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: duckdb-docs
Source: https://github.com/duckdb/duckdb-skills/tree/main/skills/duckdb-docs
Command: npx skills add https://github.com/duckdb/duckdb-skills --skill duckdb-docs-duckdb

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Finding accurate DuckDB or DuckLake documentation requires manually browsing docs sites, and answers may not match the version you are running. This Skill retrieves relevant documentation chunks directly via full-text search so you get version-aware answers without leaving your session. ## Core Features & Use Cases - Full-Text Documentation Search: Runs BM25-ranked queries against hosted DuckDB and DuckLake search indexes covering docs pages and blog posts. - Version-Aware Filtering: Filters results by version (lts, current, blog for DuckDB; stable, preview for DuckLake) so answers match the features you actually use. - Local Index Caching: Downloads the search index to a local DuckDB file and reuses it for up to two days, enabling fast repeated lookups. - Use Case: You need to know how window functions work in DuckDB. Ask a natural language question and receive the top-ranked documentation chunks with URLs, sections, and a synthesized answer. ## Quick Start Ask the duckdb-docs skill how to read a CSV file with custom delimiters in DuckDB.

Frequently Asked Questions about duckdb-docs

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I search DuckDB documentation from the command line?▼

Use the duckdb CLI with the fts extension to run BM25 match queries against the docs search index hosted at duckdb.org. The index can be downloaded locally and queried with fts_main_docs_chunks.match_bm25 for ranked results.

How to search DuckLake documentation separately from DuckDB docs?▼

DuckLake has its own search index hosted at ducklake.select with stable and preview versions. Attach that index instead of the DuckDB one and filter by version to search DuckLake-specific features like catalogs.

Does DuckDB docs search work offline?▼

Yes, after the initial download the search index is cached as a local DuckDB file in the home directory. Cached files up to two days old are reused, so repeated searches run entirely offline against the local copy.

Why does DuckDB full-text search return no results?▼

Empty results usually mean the query terms are too specific or the version filter excludes matching pages. Broaden the query by dropping the least specific term, try a single keyword, or remove the version filter to search across all versions.

What DuckDB extensions are required for documentation search?▼

The httpfs and fts extensions are required. httpfs fetches the remote index over HTTPS, and fts provides the BM25 match function used to rank documentation chunks against the search query.

Related Skills

Explore More Data & Analytics Skills→
mathisdrnmathisdrn
9

duckdb-docs

Searches DuckDB and DuckLake documentation using BM25 full-text search against a locally cached index.

Community
Intermediate
nq-rdlnq-rdl

attach-db

Attach a DuckDB database file to shared state for query workflows.

Official
Advanced
duckdbduckdb
527

attach-db

Attach DuckDB databases and explore schemas for interactive SQL querying.

Official
Intermediate
chrishuffman5chrishuffman5

duckdb-docs

Search locally cached DuckDB and DuckLake documentation with full-text queries.

Community
Intermediate