Agent skill

Duckdb En

by aAAaqwq in aAAaqwq/AGI-Super-Team

DuckDB CLI specialist for SQL analysis, data processing and file conversion.

MITAuto-check passedDatabases

Install Duckdb En

skills CLI
$ npx skills add aAAaqwq/AGI-Super-Team --skill duckdb-en -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install aAAaqwq/AGI-Super-Team duckdb-en --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/aAAaqwq/AGI-Super-Team.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/duckdb-cli-ai-skills .claude/skills/duckdb-en && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
duckdb-en
GitHub stars
105
Used in
1 other repo
Token cost
~1.6k tokens
SKILL.md length
482 words
Files
3
Skills in repo
167
Repo updated
First seen
Licence
MIT

At a glance

DuckDB CLI specialist for SQL analysis, data processing and file conversion.

  • CSV/Parquet/JSON analysis
  • SKILL.md covers Quick Start, Command Line Arguments, Data Conversion and Dot Commands, plus 4 more sections
  • Calls duckdb
  • Database queries

What it does

Duckdb En is an agent skill from aAAaqwq/AGI-Super-Team. DuckDB CLI specialist for SQL analysis, data processing and file conversion. Use for SQL queries, CSV/Parquet/JSON analysis, database queries, or data conversion. Triggers on "duckdb", "sql", "query", "data analysis", "parquet", "convert data".

Its SKILL.md is about 1.6k tokens, which your agent loads only when the skill is triggered. The skill folder holds 2 other files (for example `README.md` and `_meta.json`).

It sits in Databases, covering SQL, DataFrames and CSV and tabular files. It works with DuckDB and SQL. The repository describes itself as: An installable, cross-framework AI organization: C-suite agents, expert subagents, curated skills, independent review, and one-command setup across 18 AI client/runtime adapters. The licence is MIT.

When your agent uses it

  • CSV/Parquet/JSON analysis
  • Database queries
  • Data conversion

Example prompts

  • “duckdb”
  • “data analysis”
  • “parquet”
  • “/duckdb-en”

What it can do on your machine

Read from SKILL.md and the folder at commit 7cefd81. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • duckdb

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    No URLs in SKILL.md.

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Duckdb En loads about 1.6k tokens when it runs. Until then it costs about 64 tokens; SKILL.md has 482 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~64
When it runs · the whole SKILL.md, loaded when a task matches
~1.6k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from aAAaqwq/AGI-Super-Team at commit 7cefd81, republished under its MIT licence (© aAAaqwq). 482 words, ~1,634 tokens.

Download SKILL.mdSave it as .claude/skills/duckdb-en/SKILL.md (or your agent's skills folder). This skill also uses 2 other files; get the full folder from GitHub.
name
duckdb-en
description
DuckDB CLI specialist for SQL analysis, data processing and file conversion. Use for SQL queries, CSV/Parquet/JSON analysis, database queries, or data conversion. Triggers on "duckdb", "sql", "query", "data analysis", "parquet", "convert data".

DuckDB CLI Specialist

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

Quick Start

Read data files directly with SQL
bash
# 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
bash
# Create/open database
duckdb my_database.duckdb

# Read-only mode
duckdb -readonly existing.duckdb

Command Line Arguments

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

Data Conversion

CSV to Parquet
bash
duckdb -c "COPY (SELECT * FROM 'input.csv') TO 'output.parquet' (FORMAT PARQUET)"
Parquet to CSV
bash
duckdb -c "COPY (SELECT * FROM 'input.parquet') TO 'output.csv' (HEADER, DELIMITER ',')"
JSON to Parquet
bash
duckdb -c "COPY (SELECT * FROM read_json_auto('input.json')) TO 'output.parquet' (FORMAT PARQUET)"
Convert with filtering
bash
duckdb -c "COPY (SELECT * FROM 'data.csv' WHERE amount > 1000) TO 'filtered.parquet' (FORMAT PARQUET)"

Dot Commands

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

Output Formats (18 available)

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

Keyboard Shortcuts (macOS/Linux)

Navigation
ShortcutAction
Home / EndStart/end of line
Ctrl+Left/RightJump word
Ctrl+A / Ctrl+EStart/end of buffer
Show full SKILL.md (187 more words)Show less
History
ShortcutAction
Ctrl+P / Ctrl+NPrevious/next command
Ctrl+RSearch history
Alt+< / Alt+>First/last in history
Editing
ShortcutAction
Ctrl+WDelete word backward
Alt+DDelete word forward
Alt+U / Alt+LUppercase/lowercase word
Ctrl+KDelete to end of line
Autocomplete
ShortcutAction
TabAutocomplete / next suggestion
Shift+TabPrevious suggestion
Esc+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

Database Operations

Create table from file
sql
CREATE TABLE sales AS SELECT * FROM 'sales_2024.csv';
Insert data
sql
INSERT INTO sales SELECT * FROM 'sales_2025.csv';
Export table
sql
COPY sales TO 'backup.parquet' (FORMAT PARQUET);

Analysis Examples

Quick statistics
sql
SELECT
    COUNT(*) as count,
    AVG(amount) as average,
    SUM(amount) as total
FROM 'transactions.csv';
Grouping
sql
SELECT
    category,
    COUNT(*) as count,
    SUM(amount) as total
FROM 'data.csv'
GROUP BY category
ORDER BY total DESC;
Join on files
sql
SELECT a.*, b.name
FROM 'orders.csv' a
JOIN 'customers.parquet' b ON a.customer_id = b.id;
Describe data
sql
DESCRIBE SELECT * FROM 'data.csv';

Pipe and stdin

bash
# 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:

sql
.timer on
.mode duckbox
.maxrows 50
.highlight on
Syntax highlighting colors
sql
.keyword green
.constant yellow
.comment brightblack
.error red

External Editor

Open complex queries in your editor:

sql
.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

© aAAaqwq, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 2 other files in skills/duckdb-cli-ai-skills of aAAaqwq/AGI-Super-Team.

  • SKILL.md
  • README.md
  • _meta.json

Open the folder on GitHubat commit 7cefd81

Used in 1 other repository

We found 1 copy of this SKILL.md (exact, near-identical or edited) in other folders, from 1 other GitHub owner. This page covers the copy in aAAaqwq/AGI-Super-Team, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Duckdb En next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Duckdb En compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Duckdb En this skillaAAaqwq/AGI-Super-Team1051 repos~1.6kAutomated safety check: PassMIT
Data Processingjeremylongshore/tons-of-skills-marketplace2.8k—~1.3kAutomated safety check: PassMIT
Matlab Use Duckdbmatlab/matlab-agentic-toolkit1.1k—~3.9kAutomated safety check: PassCustom licence
Excel and CSV Data Analysisbytedance/deer-flow84k4 repos~2.2kAutomated safety check: PassMIT
Chdb SQLvemetric/vemetric3951 repos~1.2kAutomated safety check: PassApache-2.0
Ops Telemetry Queryboundless-xyz/boundless193—~3.8kAutomated safety check: PassApache-2.0

Similar skills

  • Data Processing

    jeremylongshore/tons-of-skills-marketplace

    A skill your agent uses when working with structured data files (CSV, JSON, YAML, TOML, Parquet) — querying, transforming, filtering, aggregating, or converting between formats

    2.8k GitHub stars~1.3k tokensUpdated yesterday
    Documents & OfficeAuto-check passed
  • Matlab Use Duckdb

    matlab/matlab-agentic-toolkit

    Use DuckDB from MATLAB via Database Toolbox (R2026a+) as a non-math operations engine on large tabular files (CSV/Parquet/JSON) and as a zero-config embedded database.

    1.1k GitHub stars~3.9k tokensUpdated 2 days ago
    DatabasesAuto-check passed
  • Excel and CSV Data Analysis

    bytedance/deer-flow

    Analyzes uploaded Excel and CSV files with SQL through DuckDB, producing schema inspections, statistical summaries and exports to CSV, JSON or Markdown.

    84k GitHub starsUsed in 4 repos~2.2k tokens
    Data & AnalyticsAuto-check passed
  • Chdb SQL

    vemetric/vemetric

    A skill your agent uses when the user wants to run SQL — especially analytical SQL — on local files (parquet/csv/json), URLs, S3 paths, or remote databases (Postgres, MySQL, MongoDB, ClickHouse…

    395 GitHub starsUsed in 1 repo~1.2k tokens
    DatabasesAuto-check passed
  • Ops Telemetry Query

    boundless-xyz/boundless

    Internal — for Boundless team members only. An agent skill from boundless-xyz/boundless.

    193 GitHub stars~3.8k tokensUpdated 1 mo ago
    DatabasesAuto-check passed
  • Analyzing Data

    astronomer/agents

    Queries the data warehouse with SQL and answers business questions about data.

    451 GitHub stars~1.3k tokensUpdated 3 days ago
    DatabasesAuto-check passed

More from aAAaqwq/AGI-Super-Team

All 167 skills in this repo
  • Content Creator

    aAAaqwq/AGI-Super-Team

    Create SEO-optimized marketing content with consistent brand voice.

    105 GitHub starsUsed in 3 repos~1.9k tokens
    Auto-check passed
  • Financial Calculator

    aAAaqwq/AGI-Super-Team

    Advanced financial calculator with future value tables, present value, discount calculations, markup pricing, and compound interest.

    105 GitHub starsUsed in 1 repo~1.5k tokens
    Auto-check passed
  • Bankr Signals

    aAAaqwq/AGI-Super-Team

    Transaction-verified trading signals on Base blockchain. An agent skill from aAAaqwq/AGI-Super-Team.

    105 GitHub starsUsed in 2 repos~3.3k tokens
    Auto-check passed
  • Erc 8004

    aAAaqwq/AGI-Super-Team

    Register AI agents on Ethereum mainnet using ERC-8004 (Trustless Agents).

    105 GitHub starsUsed in 2 repos~1.2k tokens
    Auto-check passed
  • Frontend Design Ultimate

    aAAaqwq/AGI-Super-Team

    Create distinctive, production-grade static sites with React, Tailwind CSS, and shadcn/ui — no mockups needed.

    105 GitHub starsUsed in 2 repos~2.7k tokens
    Auto-check passed
  • Zsxq Smart Publish

    aAAaqwq/AGI-Super-Team

    Publish and manage content on 知识星球 (zsxq.com). An agent skill from aAAaqwq/AGI-Super-Team.

    105 GitHub stars~1.5k tokensUpdated 2 days ago
    Auto-check passed

Works with

Questions about Duckdb En

What does Duckdb En do?

DuckDB CLI specialist for SQL analysis, data processing and file conversion. Duckdb En is an agent skill from aAAaqwq/AGI-Super-Team. DuckDB CLI specialist for SQL analysis, data processing and file conversion.

When should I use Duckdb En?

Duckdb En fits situations like: CSV/Parquet/JSON analysis; database queries; data conversion.

How do I install Duckdb En in Claude Code?

Run `npx skills add aAAaqwq/AGI-Super-Team --skill duckdb-en -a claude-code`. Or copy the skill folder (skills/duckdb-cli-ai-skills in aAAaqwq/AGI-Super-Team) into .claude/skills/duckdb-en in your project. Claude Code loads it when a task matches its description.

How do I install Duckdb En in Codex?

Run `npx skills add aAAaqwq/AGI-Super-Team --skill duckdb-en -a codex`. Or copy the skill folder (skills/duckdb-cli-ai-skills in aAAaqwq/AGI-Super-Team) into .agents/skills/duckdb-en in your project. Codex loads it when a task matches its description.

Can I use Duckdb En in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add aAAaqwq/AGI-Super-Team --skill duckdb-en -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/duckdb-en, .gemini/skills/duckdb-en, .github/skills/duckdb-en and .opencode/skills/duckdb-en in your project.

What does Duckdb En need to run?

Going by SKILL.md and its folder, Duckdb En needs the command-line tools its instructions call (duckdb).

Does Duckdb En access the network?

SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.

Is Duckdb En safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Duckdb En use?

Duckdb En is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Duckdb En use?

About 1.6k tokens (SKILL.md is roughly 6.5k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Duckdb En?

Skills that share tags, products or a category with Duckdb En: Data Processing (jeremylongshore/tons-of-skills-marketplace, 2.8k stars), Matlab Use Duckdb (matlab/matlab-agentic-toolkit, 1.1k stars), Excel and CSV Data Analysis (bytedance/deer-flow, 84k stars) and Chdb SQL (vemetric/vemetric, 395 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Duckdb En?

aAAaqwq (a GitHub user) maintains it in aAAaqwq/AGI-Super-Team, which has 105 GitHub stars. The repository holds 167 skills in this directory. The repository was last updated on October 8, 2026.

Source: aAAaqwq/AGI-Super-Team on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.