skills.rest
mathisdrn
mathisdrnCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

duckdb-docs

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

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve? Finding accurate DuckDB or DuckLake documentation requires manually browsing docs sites; this Skill retrieves relevant documentation chunks directly via full-text search against a locally cached index. ## Core Features & Use Cases - Full-Text Documentation Search: Runs BM25-ranked queries against DuckDB docs, blog posts, and DuckLake docs using the DuckDB fts extension. - Local Cache Management: Downloads and caches the docs-search index locally, refreshing it automatically when older than two days. - Version-Aware Filtering: Filters results by documentation version (lts, current, blog, stable, preview) based on the question context. - Use Case: Ask "how do I find the most frequent value in a column" and receive ranked DuckDB documentation chunks with URLs, sections, and a synthesized answer. ## Quick Start Ask the assistant to search DuckDB documentation for how to use a specific SQL function or feature.

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 fts extension to run BM25 queries against the docs-search index hosted at duckdb.org/data/docs-search.duckdb. The match_bm25 function ranks documentation chunks by relevance to your search terms.

What is the DuckDB docs-search index and how is it cached?▼

The docs-search index is a DuckDB database containing documentation chunks with titles, URLs, and text. It is copied to $HOME/.duckdb/docs/ and refreshed automatically when the local cache is older than two days.

Can I search DuckLake documentation separately from DuckDB docs?▼

Yes, DuckLake has its own search index hosted at ducklake.select/data/docs-search.duckdb with stable and preview versions. Use it when the query mentions DuckLake, catalogs, or DuckLake-specific features.

Why does the DuckDB docs search return no results?▼

Empty results usually mean the query terms are too specific or the version filter excludes relevant pages. Broaden the query by dropping less specific terms, or remove the version filter to search across all versions.

What DuckDB extensions are required for documentation search?▼

The httpfs extension is required to fetch the remote index over HTTPS, and the fts extension provides the match_bm25 full-text search function. Install both with INSTALL httpfs and INSTALL fts.

Related Skills

Explore More Data & Analytics Skills→
nq-rdlnq-rdl

install-duckdb

Install or update DuckDB extensions and the CLI in automation pipelines.

Official
Intermediate
nq-rdlnq-rdl

duckdb-docs

Search cached DuckDB and DuckLake documentation using a local full-text index.

Official
Intermediate
nq-rdlnq-rdl

query

Convert natural-language requests into executable DuckDB SQL queries.

Official
Intermediate
Snowflake-LabsSnowflake-Labs
12

deploy-route-optimization-demo

Deploy the complete route optimization demo in Snowflake Cortex.

Official
Advanced