跳到正文
TakoAPI
返回技能列表

duckdb-en

由 camelsprout 提供

Data & Analytics
3.1k下载量由 clawskills.sh 提供
3星标
1浏览量
0 个赞登录后即可为这个技能点赞
—暂无评分
你的评分

简介

DuckDB CLI specialist for SQL analysis, data processing.

描述

该技能的功能

DuckDB CLI runs SQL queries against CSV, Parquet, and JSON files directly from the terminal without a database server. It also converts between file formats and integrates with shell pipes and scripts.

Queries files in place without loading them into a running database, so exploratory analysis is faster than spinning up a server or writing a pandas script.

何时使用

  • Querying a CSV file for records matching specific criteria without opening a spreadsheet
  • Converting Parquet exports to CSV for use in Excel or Google Sheets
  • Aggregating transaction totals by category across multiple log files
  • Joining orders and customer data stored in different file formats
  • Previewing a large dataset with a quick LIMIT query before a full import

示例工作流

输入

User asks: Show me total sales per category from sales_2024.csv, sorted highest to lowest

智能体
  1. 1

    Identify the target file and the required grouping and aggregation

  2. 2

    Construct a SELECT with GROUP BY category and SUM(amount) ORDER BY total DESC

  3. 3

    Run: duckdb -table -c "SELECT category, SUM(amount) AS total FROM 'sales_2024.csv' GROUP BY category ORDER BY total DESC"

  4. 4

    Return the formatted ASCII table output

输出

A table listing each category with its total sales, ordered from highest to lowest

前置要求

  • DuckDB CLI installed locally

安装

clawhub install camelsprout/duckdb-cli-ai-skills

运行 CLI 命令,或把这段提示词粘贴到 Claude Code、Cursor、Codex 或你在用的任意编程智能体里。

链接