skills.rest
Hadokennn
HadokennnCOMMUNITY
Explore all skills by this author →
GitHub

data-analysis

Automates Excel and CSV analysis with DuckDB SQL, stats, and exports to CSV/JSON/Markdown.

5|Updated Mar 28, 2026
Search Tags:#SQL#data analysis#Excel#DuckDB#CSV
One-click install
npx skills add https://github.com/Hadokennn/deer-agents --skill data-analysis-hadokennn
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/Hadokennn/deer-agents/tree/main/deer-flow/skills/public/data-analysis
Command: npx skills add https://github.com/Hadokennn/deer-agents --skill data-analysis-hadokennn

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires duckdb, openpyxl, openpyxl, json, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill solves the problem of manually analyzing Excel and CSV files by automating the process with SQL queries, statistical summaries, and export capabilities.

Core Features & Use Cases

  • Automated Data Analysis: Perform SQL-based queries on user-uploaded Excel/CSV files.
  • Statistical Summaries: Generate statistical summaries for numeric and string columns.
  • Result Export: Export query results to CSV, JSON, or Markdown formats.
  • Use Case: If you have sales data in an Excel file and want to know the average revenue per month, you can use this Skill to run a SQL query and get the results in a CSV file.

Quick Start

Analyze the 'sales_data.xlsx' file by executing the following SQL query: SELECT category, AVG(revenue) as avg_revenue FROM Sheet1 GROUP BY category.

Frequently Asked Questions about data-analysis

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run SQL queries directly on Excel and CSV files?▼

You can run SQL queries directly on Excel and CSV files using DuckDB for in-process SQL execution. This Skill automates data analysis by inspecting schemas, querying data, and generating statistical summaries without needing a separate database server.

What's the best way to generate statistical summaries for CSV data?▼

Generating statistical summaries for CSV data is automated by this Skill using DuckDB. It calculates statistical metrics for numeric and string columns, allowing you to quickly understand data distributions and generate summaries for large files.

Can I export SQL query results to JSON or Markdown from an Excel file?▼

Yes, you can export SQL query results to JSON or Markdown from an Excel file. After running your SQL queries through DuckDB, the Skill supports exporting the analyzed data into CSV, JSON, or Markdown formats for reporting.

Does DuckDB support analyzing large Excel files with multiple sheets?▼

DuckDB supports analyzing large Excel files and processing multiple sheets or files. The Skill leverages DuckDB's in-process SQL execution to handle large datasets efficiently and inspect schemas across different sheets.

How do I inspect the schema of a CSV file before running a SQL query?▼

To inspect the schema of a CSV file before running a SQL query, this Skill provides automated schema inspection. It uses DuckDB to read the CSV or Excel structure, allowing you to identify column names and data types for accurate SQL querying.

How do I inspect the schema of a CSV file before running a SQL query?▼

To inspect the schema of a CSV file before running a SQL query, this Skill provides automated schema inspection. It uses DuckDB to read the CSV or Excel structure, allowing you to identify column names and data types for accurate SQL querying.

Related Skills

Explore More Data & Analytics Skills→
Citrus-bitCitrus-bit
135

data-analysis

Analyze Excel and CSV files with schema inspection, statistics, and SQL queries.

Community
Advanced
bytedancebytedance
79.6k

data-analysis

Analyzes Excel and CSV files with DuckDB SQL queries and exports results to CSV, JSON, or Markdown.

Official
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

formatted-export-with-parquet

Scan Excel workbook sheets, apply criteria, and export red-highlighted matching rows.

Community
Intermediate
HwFeeHwFee

data-analyst

Analyze CSV, Excel, JSON, and SQL datasets to generate visual insights and reports.

Community
Intermediate