Pular para o conteúdo
TakoAPI
Voltar às skills

duckdb-en

por camelsprout

Data & Analytics
3.1kDownloads informados pelo clawskills.sh
3Estrelas
1Visualizações
0 curtidaEntre para curtir esta skill
—Ainda sem avaliações
Sua avaliação

Resumo

DuckDB CLI specialist for SQL analysis, data processing.

Descrição

O que esta skill faz

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.

Quando usá-la

  • 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

Exemplo de fluxo de trabalho

ENTRADA

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

AGENTE
  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

SAÍDA

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

Requisitos

  • DuckDB CLI installed locally

Instalação

clawhub install camelsprout/duckdb-cli-ai-skills

Execute o comando da CLI ou cole o prompt no Claude Code, Cursor, Codex ou no agente de código que você usa.

Links