본문으로 건너뛰기
TakoAPI
스킬로 돌아가기

duckdb-en

camelsprout 제작

Data & Analytics
3.1kclawskills.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 등 사용하는 코딩 에이전트에 붙여넣으세요.

링크