duckdb-en
por camelsprout
Data & AnalyticsResumen
DuckDB CLI specialist for SQL analysis, data processing.
Descripción
Qué hace esta skill
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.
Cuándo usarla
- 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
Flujo de trabajo de ejemplo
User asks: Show me total sales per category from sales_2024.csv, sorted highest to lowest
- 1
Identify the target file and the required grouping and aggregation
- 2
Construct a SELECT with GROUP BY category and SUM(amount) ORDER BY total DESC
- 3
Run: duckdb -table -c "SELECT category, SUM(amount) AS total FROM 'sales_2024.csv' GROUP BY category ORDER BY total DESC"
- 4
Return the formatted ASCII table output
A table listing each category with its total sales, ordered from highest to lowest
Requisitos
- DuckDB CLI installed locally
Instalación
clawhub install camelsprout/duckdb-cli-ai-skillsEjecuta el comando de la CLI o pega el prompt en Claude Code, Cursor, Codex o el agente de programación que uses.