# Send DuckDB CLI skills to your agent
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
## Fast path
- Download the package from Yavira.
- Extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the extracted folder.
## Suggested prompts
### New install

```text
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Then review README.md for any prerequisites, environment setup, or post-install checks. Tell me what you changed and call out any manual steps you could not complete.
```
### Upgrade existing

```text
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Then review README.md for any prerequisites, environment setup, or post-install checks. Summarize what changed and any follow-up checks I should run.
```
## Machine-readable fields
```json
{
  "schemaVersion": "1.0",
  "item": {
    "slug": "duckdb-cli-ai-skills",
    "name": "DuckDB CLI skills",
    "source": "tencent",
    "type": "skill",
    "category": "开发工具",
    "sourceUrl": "https://clawhub.ai/CamelSprout/duckdb-cli-ai-skills",
    "canonicalUrl": "https://clawhub.ai/CamelSprout/duckdb-cli-ai-skills",
    "targetPlatform": "OpenClaw"
  },
  "install": {
    "downloadUrl": "/downloads/duckdb-cli-ai-skills",
    "sourceDownloadUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=duckdb-cli-ai-skills",
    "sourcePlatform": "tencent",
    "targetPlatform": "OpenClaw",
    "packageFormat": "ZIP package",
    "primaryDoc": "SKILL.md",
    "includedAssets": [
      "README.md",
      "SKILL.md"
    ],
    "downloadMode": "redirect",
    "sourceHealth": {
      "source": "tencent",
      "status": "healthy",
      "reason": "direct_download_ok",
      "recommendedAction": "download",
      "checkedAt": "2026-04-30T16:55:25.780Z",
      "expiresAt": "2026-05-07T16:55:25.780Z",
      "httpStatus": 200,
      "finalUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=network",
      "contentType": "application/zip",
      "probeMethod": "head",
      "details": {
        "probeUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=network",
        "contentDisposition": "attachment; filename=\"network-1.0.0.zip\"",
        "redirectLocation": null,
        "bodySnippet": null
      },
      "scope": "source",
      "summary": "Source download looks usable.",
      "detail": "Yavira can redirect you to the upstream package for this source.",
      "primaryActionLabel": "Download for OpenClaw",
      "primaryActionHref": "/downloads/duckdb-cli-ai-skills"
    },
    "validation": {
      "installChecklist": [
        "Use the Yavira download entry.",
        "Review SKILL.md after the package is downloaded.",
        "Confirm the extracted package contains the expected setup assets."
      ],
      "postInstallChecks": [
        "Confirm the extracted package includes the expected docs or setup files.",
        "Validate the skill or prompts are available in your target agent workspace.",
        "Capture any manual follow-up steps the agent could not complete."
      ]
    }
  },
  "links": {
    "detailUrl": "https://openagent3.xyz/skills/duckdb-cli-ai-skills",
    "downloadUrl": "https://openagent3.xyz/downloads/duckdb-cli-ai-skills",
    "agentUrl": "https://openagent3.xyz/skills/duckdb-cli-ai-skills/agent",
    "manifestUrl": "https://openagent3.xyz/skills/duckdb-cli-ai-skills/agent.json",
    "briefUrl": "https://openagent3.xyz/skills/duckdb-cli-ai-skills/agent.md"
  }
}
```
## Documentation

### DuckDB CLI Specialist

Helps with data analysis, SQL queries and file conversion via DuckDB CLI.

### Read data files directly with SQL

# CSV
duckdb -c "SELECT * FROM 'data.csv' LIMIT 10"

# Parquet
duckdb -c "SELECT * FROM 'data.parquet'"

# Multiple files with glob
duckdb -c "SELECT * FROM read_parquet('logs/*.parquet')"

# JSON
duckdb -c "SELECT * FROM read_json_auto('data.json')"

### Open persistent databases

# Create/open database
duckdb my_database.duckdb

# Read-only mode
duckdb -readonly existing.duckdb

### Output formats (as flags)

FlagFormat-csvComma-separated-jsonJSON array-tableASCII table-markdownMarkdown table-htmlHTML table-lineOne value per line

### Execution arguments

ArgumentDescription-c COMMANDRun SQL and exit-f FILENAMERun script from file-init FILEUse alternative to ~/.duckdbrc-readonlyOpen in read-only mode-echoShow commands before execution-bailStop on first error-header / -noheaderShow/hide column headers-nullvalue TEXTText for NULL values-separator SEPColumn separator

### CSV to Parquet

duckdb -c "COPY (SELECT * FROM 'input.csv') TO 'output.parquet' (FORMAT PARQUET)"

### Parquet to CSV

duckdb -c "COPY (SELECT * FROM 'input.parquet') TO 'output.csv' (HEADER, DELIMITER ',')"

### JSON to Parquet

duckdb -c "COPY (SELECT * FROM read_json_auto('input.json')) TO 'output.parquet' (FORMAT PARQUET)"

### Convert with filtering

duckdb -c "COPY (SELECT * FROM 'data.csv' WHERE amount > 1000) TO 'filtered.parquet' (FORMAT PARQUET)"

### Schema inspection

CommandDescription.tables [pattern]Show tables (with LIKE pattern).schema [table]Show CREATE statements.databasesShow attached databases

### Output control

CommandDescription.mode FORMATChange output format.output fileSend output to file.once fileNext output to file.headers on/offShow/hide column headers.separator COL ROWSet separators

### Queries

CommandDescription.timer on/offShow execution time.echo on/offShow commands before execution.bail on/offStop on error.read file.sqlRun SQL from file

### Editing

CommandDescription.edit or \\eOpen query in external editor.help [pattern]Show help

### Data export

csv - Comma-separated for spreadsheets
tabs - Tab-separated
json - JSON array
jsonlines - Newline-delimited JSON (streaming)

### Readable formats

duckbox (default) - Pretty ASCII with unicode box-drawing
table - Simple ASCII table
markdown - For documentation
html - HTML table
latex - For academic papers

### Specialized

insert TABLE - SQL INSERT statements
column - Columns with adjustable width
line - One value per line
list - Pipe-separated
trash - Discard output

### Navigation

ShortcutActionHome / EndStart/end of lineCtrl+Left/RightJump wordCtrl+A / Ctrl+EStart/end of buffer

### History

ShortcutActionCtrl+P / Ctrl+NPrevious/next commandCtrl+RSearch historyAlt+< / Alt+>First/last in history

### Editing

ShortcutActionCtrl+WDelete word backwardAlt+DDelete word forwardAlt+U / Alt+LUppercase/lowercase wordCtrl+KDelete to end of line

### Autocomplete

ShortcutActionTabAutocomplete / next suggestionShift+TabPrevious suggestionEsc+EscUndo autocomplete

### Autocomplete

Context-aware autocomplete activated with Tab:

Keywords - SQL commands
Table names - Database objects
Column names - Fields and functions
File names - Path completion

### Create table from file

CREATE TABLE sales AS SELECT * FROM 'sales_2024.csv';

### Insert data

INSERT INTO sales SELECT * FROM 'sales_2025.csv';

### Export table

COPY sales TO 'backup.parquet' (FORMAT PARQUET);

### Quick statistics

SELECT
    COUNT(*) as count,
    AVG(amount) as average,
    SUM(amount) as total
FROM 'transactions.csv';

### Grouping

SELECT
    category,
    COUNT(*) as count,
    SUM(amount) as total
FROM 'data.csv'
GROUP BY category
ORDER BY total DESC;

### Join on files

SELECT a.*, b.name
FROM 'orders.csv' a
JOIN 'customers.parquet' b ON a.customer_id = b.id;

### Describe data

DESCRIBE SELECT * FROM 'data.csv';

### Pipe and stdin

# Read from stdin
cat data.csv | duckdb -c "SELECT * FROM read_csv('/dev/stdin')"

# Pipe to another command
duckdb -csv -c "SELECT * FROM 'data.parquet'" | head -20

# Write to stdout
duckdb -c "COPY (SELECT * FROM 'data.csv') TO '/dev/stdout' (FORMAT CSV)"

### Configuration

Save common settings in ~/.duckdbrc:

.timer on
.mode duckbox
.maxrows 50
.highlight on

### Syntax highlighting colors

.keyword green
.constant yellow
.comment brightblack
.error red

### External Editor

Open complex queries in your editor:

.edit

Editor is chosen from: DUCKDB_EDITOR → EDITOR → VISUAL → vi

### Safe Mode

Secure mode that restricts file access. When enabled:

No external file access
Disables .read, .output, .import, .sh etc.
Cannot be disabled in the same session

### Tips

Use LIMIT on large files for quick preview
Parquet is faster than CSV for repeated queries
read_csv_auto and read_json_auto guess column types
Arguments are processed in order (like SQLite CLI)
WSL2 may show incorrect memory_limit values on some Ubuntu versions
## Trust
- Source: tencent
- Verification: Indexed source record
- Publisher: CamelSprout
- Version: 1.0.0
## Source health
- Status: healthy
- Source download looks usable.
- Yavira can redirect you to the upstream package for this source.
- Health scope: source
- Reason: direct_download_ok
- Checked at: 2026-04-30T16:55:25.780Z
- Expires at: 2026-05-07T16:55:25.780Z
- Recommended action: Download for OpenClaw
## Links
- [Detail page](https://openagent3.xyz/skills/duckdb-cli-ai-skills)
- [Send to Agent page](https://openagent3.xyz/skills/duckdb-cli-ai-skills/agent)
- [JSON manifest](https://openagent3.xyz/skills/duckdb-cli-ai-skills/agent.json)
- [Markdown brief](https://openagent3.xyz/skills/duckdb-cli-ai-skills/agent.md)
- [Download page](https://openagent3.xyz/downloads/duckdb-cli-ai-skills)