कंटेंट पर जाएँ
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 या जो भी कोडिंग एजेंट आप इस्तेमाल करते हैं उसमें पेस्ट करें।

लिंक