A high-performance SQL analytical tool for the CLI that enables instant querying and conversion of CSV, Parquet, and JSON data files.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install duckdb-cli
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install duckdb-cli using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is DuckDB CLI Specialist?
The DuckDB CLI Specialist is an essential tool in the Openclaw Skills collection designed for developers and data scientists who need to perform rapid data analysis without the overhead of a traditional database server. It leverages the power of DuckDB to execute complex SQL queries directly against local files like CSV, Parquet, and JSON, providing sub-second response times even on large datasets.
This skill transforms the command line into a powerful analytical workstation. Whether you are joining a local CSV with a Parquet file or converting nested JSON into a flat table structure, the DuckDB CLI Specialist provides a rich, interactive environment with features like auto-completion, syntax highlighting, and versatile export formats.
DuckDB CLI Specialist Use Cases
- Querying large CSV or Parquet files directly from the terminal without importing them into a database.
- Converting data between different formats such as CSV to Parquet or JSON to CSV.
- Performing quick exploratory data analysis (EDA) using standard SQL syntax on raw data logs.
- Joining disparate data sources, such as a local text file and an existing DuckDB database file.
- Automating data transformation pipelines using shell scripts and DuckDB command-line arguments.
How DuckDB CLI Specialist Works
- The user initiates a query or command using the duckdb executable followed by specific flags or SQL statements.
- DuckDB's vectorized execution engine reads the source files (CSV, Parquet, or JSON) directly into memory using optimized scanners.
- The SQL engine processes the query, applying filters, aggregations, or joins as specified in the command.
- Result sets are formatted according to the selected output mode (e.g., ASCII table, JSON, or Markdown).
- For persistent storage, the skill handles connections to .duckdb database files, managing ACID-compliant transactions locally.
DuckDB CLI Specialist Setup
To start using this skill within the Openclaw Skills ecosystem, ensure you have the DuckDB CLI installed. You can run ad-hoc queries or enter an interactive session:
# Run a direct query on a CSV file
duckdb -c "SELECT * FROM 'data.csv' LIMIT 10"
# Enter interactive mode with a persistent database
duckdb my_analysis.duckdb
Configure your environment by creating a ~/.duckdbrc file to enable features like timers and syntax highlighting.
DuckDB CLI Specialist Data Schema & Taxonomy
The skill interacts with various data formats and organizes internal metadata through the following structures:
| Feature | Description |
|---|---|
| File Formats | Supports CSV, Parquet, JSON (auto-detect), and DuckDB native files. |
| Persistence | Data can be stored in .duckdb binary files for cross-session persistence. |
| Metadata | Accessible via .tables and .schema dot commands to inspect table structures. |
| Output Modes | Over 18 formats including csv, json, markdown, and latex. |
DuckDB CLI Specialist Advanced Features
- Direct integration with stdin and stdout for powerful Unix-style piping and automation.
- External editor support via the
.editcommand to write complex SQL in your preferred IDE. - Safe Mode execution to restrict file access and ensure secure data processing environment.
- Context-aware autocomplete for SQL keywords, table names, and file paths using the Tab key.
- Advanced Parquet features including projection and filter pushdown for high-speed analysis of massive datasets.
SKILL.md
Loading
Related Openclaw Skills
TypeScript Style Guide
A comprehensive coding standard skill that enforces strict type safety and best-practice conventions for modern TypeScript development.
Engrm Delivery Review
A specialized accountability workflow for auditing AI agent outputs by comparing initial briefs against actual delivery evidence.
Coupon Center
A comprehensive real-time aggregator for e-commerce coupons, platform red envelopes, and exclusive brand internal discounts.
FitClaw Public Core
A secure, public-safe packaging layer for AI fitness coaching workflows that isolates reusable logic from private user data.
Vibe Learn
Vibe Learn is a micro-learning engine that curate's context-aware knowledge cards for developers to consume during AI agent processing time.
Baidu Search
A powerful AI agent skill for real-time web searching and information retrieval using the Baidu AI Search API.
Featured*
