# openduck-distributed-duckdb

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

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode · 424 installs · ★ 88
- Author: reason-machines
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/trending-skills/tree/HEAD/skills/openduck-distributed-duckdb/SKILL.md
- Updated: 2026-10-09
- HTML: https://affpapa.org/en/nevibecode/skills/openduck-distributed-duckdb

## What it 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.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/trending-skills --skill openduck-distributed-duckdb -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/openduck-distributed-duckdb/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/openduck-distributed-duckdb/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/trending-skills --skill openduck-distributed-duckdb -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/openduck-distributed-duckdb/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/trending-skills --skill openduck-distributed-duckdb -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/openduck-distributed-duckdb/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/trending-skills openduck-distributed-duckdb
```

2. **Manually: put the files in place**
- File: `.github/skills/openduck-distributed-duckdb/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/trending-skills --skill openduck-distributed-duckdb -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/trending-skills --path skills/openduck-distributed-duckdb
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/openduck-distributed-duckdb/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/trending-skills --skill openduck-distributed-duckdb -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/reason-machines/trending-skills/tree/HEAD/skills/openduck-distributed-duckdb/SKILL.md

## When to use it
- 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
- 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

## Similar
- [xlsx](https://affpapa.org/en/nevibecode/skills/xlsx.md) — skill · 187223 installs
- [google-agents-cli-observability](https://affpapa.org/en/nevibecode/skills/google-agents-cli-observability.md) — skill · 511300 installs
- [caveman-evidence-review](https://affpapa.org/en/nevibecode/skills/caveman-evidence-review.md) — skill · 104500 installs
- [migration](https://affpapa.org/en/nevibecode/skills/migration.md) — skill · 103900 installs
- [performance-optimization](https://affpapa.org/en/nevibecode/skills/performance-optimization.md) — skill · 65200 installs
- [supabase](https://affpapa.org/en/nevibecode/skills/supabase.md) — skill · 8 installs

From the same set: [reason-machines/trending-skills](https://affpapa.org/en/nevibecode/by/reason-machines/trending-skills.md) — 199 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md