Install
openclaw skills install @xiaoqianran/xiaoqianran-duckLocal analytical data tool powered by DuckDB. Supports importing and querying CSV, TSV, JSON, Parquet, Excel and direct Hugging Face datasets via hf:// protocol with token support. Includes CLI, Node helper, preview server, and Rust backend for Tauri/Electron/Qt apps.
openclaw skills install @xiaoqianran/xiaoqianran-duckLocal analytical data tool powered by DuckDB.
A desktop-first data explorer that combines:
data.duckdbhf:// (no need to download everything first) + token login for gated datasets# Node
npm install xiaoqianran-duck
# CLI
npx xiaoqianran-duck import data.csv
npx xiaoqianran-duck hf hf://datasets/user/ds/data.parquet mytable
npx xiaoqianran-duck query "SELECT * FROM mytable LIMIT 10"
See full README.md and examples/.
hf:// protocoldata.duckdbexport HF_TOKEN=hf_your_token
# or put in .env next to data.duckdb
In code:
const helper = new DuckDBHelper('data.duckdb');
await helper.setHFTtoken(process.env.HF_TOKEN);
await helper.importFromHF('hf://datasets/user/private-ds/data.parquet');
duck import sales.csv
duck import data.parquet my_sales
duck import report.xlsx
In JS:
const DuckDBHelper = require('xiaoqianran-duck');
const helper = new DuckDBHelper('./data.duckdb');
await helper.importFile('./data.csv');
await helper.importFile('./big.parquet', 'big_data');
duck hf hf://datasets/datasets-examples/doc-formats-parquet-1/data/train-00000-of-00001.parquet
Supports @~parquet suffix for optimized Parquet views on HF.
duck query "SELECT city, COUNT(*) as cnt FROM mytable GROUP BY city"
duck query "SELECT * FROM 'data.csv' LIMIT 5" # direct file query
duck tables
duck describe mytable
duck export mytable backup.parquet
node examples/preview-server.js
# Open http://localhost:3000
# Browse tables and run queries in browser
See rust-backend/src/main.rs for DuckDB-rs example with HF and local import.
Compile with cargo build (uses bundled DuckDB).
Frontend (Tauri/Electron/Qt) → DuckDB (data.duckdb) → Files (local + hf://)
MIT
See README.md for full details and code.