Skip to main content
skill CX Codex

openduck-distributed-duckdb — Claude Code skill: setup and usage

Helps your agent set up OpenDuck, an open-source distributed DuckDB alternative with hybrid query routing and differential storage.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add reason-machines/trending-skills --skill openduck-distributed-duckdb -a claude-code
Open on GitHub

What openduck-distributed-duckdb does

This skill teaches your assistant how to deploy and query OpenDuck. The architecture distributes queries between a local DuckDB instance and remote workers. A Rust gateway splits the query plan, streaming tabular data through gRPC and Arrow IPC. For storage, Postgres tracks snapshots and metadata while an object store retains immutable data layers.

Compilation involves multiple toolchains. You need a stable Rust compiler, C++ build tools, and bison. The native DuckDB C++ extension compiles directly from the extensions/openduck directory via make. The repository also provides a Python package and a CLI binary to run workers and gateways.

DuckDB rejects external extensions by default. You must pass allow_unsigned_extensions = true when establishing a database connection, or the engine will refuse to load the compiled OpenDuck binary.

What it helps with

  • compile the native OpenDuck C++ extension and Rust gateway
  • execute split SQL joins between local files and remote tables
  • connect to a remote OpenDuck instance using ATTACH syntax
  • spin up combined or separated gateway and worker nodes via CLI

Example prompts for the agent

  • Help me build the openduck C++ extension and run the Rust backend
  • Write a Python script that joins a local DuckDB table with a remote OpenDuck database
  • Show me how to attach openduck:mydb using DuckDB CLI with an auth token

How to install openduck-distributed-duckdb

1Skills CLI (Vercel)

npx skills add reason-machines/trending-skills --skill openduck-distributed-duckdb -a claude-code

2Manually: put the files in place

~/.claude/skills/openduck-distributed-duckdb/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/openduck-distributed-duckdb/

Step by step, with commands for each platform: How to install skills in Claude Code: five ways

Questions about openduck-distributed-duckdb

How to install openduck-distributed-duckdb in Claude Code?

Run npx skills add reason-machines/trending-skills --skill openduck-distributed-duckdb -a claude-code in your terminal.

What does openduck-distributed-duckdb do?

It guides coding assistants in compiling OpenDuck components, running the Rust cluster, and issuing hybrid queries across local and cloud DuckDB tables.

Why is the allow_unsigned_extensions option mandatory?

DuckDB forbids unverified third-party binaries out of the box. Setting this parameter allows the client to load the custom openduck.duckdb_extension file.

Similar skills

All skills for Data and databases →

From the same set199

diagram-design-editorial A skill that turns a short description into an HTML+SVG diagram for posts and docs. Thirteen types, no Mermaid, no build step, styling matched to your site. CX Codex +1 433installs anubis-android-app-manager A skill for building and configuring Anubis, an Android app manager that freezes app groups through Shizuku depending on VPN state. CX Codex +1 427installs nothing-ever-happens-polymarket-bot This skill sets up an async Python bot for Polymarket that scans standalone non-sports markets and buys “No” below a configured price cap. CX Codex +1 426installs huashu-design-html-native Turns a plain-language request into a finished file: prototype, slide deck, animation or infographic in HTML/CSS/JS. No Figma involved. CX Codex +1 426installs cc-design-html-prototyping This skill builds HTML mockups, slide decks, and interactive prototypes. Use it to explore visual directions before implementing an interface. CX Codex +1 423installs killerpdf-portable-editor Guides agents on creating and compiling a standalone C# WPF PDF editor powered by PDFium. It helps with page splitting, drawing annotations, and single-binary packaging. CX Codex +1 422installs hy-world-2-0-3d-world-model A skill for running HY-World 2.0: it turns photos and video into 3D scenes and builds worlds from text or a single image. CX Codex +1 419installs weft-ai-language Teaches coding assistants to write Weft workflows, connect typed LLM nodes, and manage human checkpoints with Restate. CX Codex +1 418installs

Project sponsors

Companies that keep this analytics open
Gold sponsor

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor