duckdb-en
von camelsprout
Data & AnalyticsKurzbeschreibung
DuckDB CLI specialist for SQL analysis, data processing.
Beschreibung
Was dieser Skill macht
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.
Wann du ihn einsetzt
- 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
Beispiel-Workflow
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
Voraussetzungen
- DuckDB CLI installed locally
Installation
clawhub install camelsprout/duckdb-cli-ai-skillsFühre den CLI-Befehl aus oder füge den Prompt in Claude Code, Cursor, Codex oder deinen Coding-Agenten ein.