skills.rest
Citrus-bit
Citrus-bitCOMMUNITY
Explore all skills by this author →
GitHub

data-analysis

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

135|12|Updated Mar 30, 2026
Search Tags:#sql#statistics#excel#data-analysis#csv#duckdb#export
One-click install
npx skills add https://github.com/Citrus-bit/medrix-flow --skill data-analysis-citrus-bit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/Citrus-bit/medrix-flow/tree/main/skills/public/data-analysis
Command: npx skills add https://github.com/Citrus-bit/medrix-flow --skill data-analysis-citrus-bit

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Many users need fast, reliable analysis of uploaded Excel and CSV files but lack a safe, repeatable way to inspect schemas, run ad-hoc queries, and produce summaries or exports. This Skill removes that friction by providing a single, script-driven workflow that inspects multi-sheet workbooks, executes SQL queries, and generates statistical summaries and exportable results.

Core Features & Use Cases

  • Schema inspection: Discover sheets, columns, inferred types, row counts, and sample rows for quick data exploration.
  • SQL querying: Run arbitrary SQL (including joins, window functions, and CTEs) against all tables loaded from Excel sheets and CSV files using DuckDB.
  • Statistical summaries: Produce numeric statistics (mean, median, std, percentiles, null counts) and top-value breakdowns for categorical fields.
  • Multi-file & multi-sheet support: Load multiple files into a single query context to enable cross-file joins and pivot-style analyses.
  • Exports & caching: Export results to CSV/JSON/Markdown and use a SHA256-hash-backed DuckDB cache for fast repeated queries on the same inputs.
  • Use case: Inspect sales_2024.xlsx to find top products by revenue, generate monthly revenue trends, and export results for reporting.

Quick Start

Use the data-analysis skill to inspect the uploaded sales_2024.xlsx, run a SQL query to list top products by revenue, and export monthly trends to /mnt/user-data/outputs/monthly-trends.csv.

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 on Excel and CSV files without a database server?▼

Use this data analysis skill to load Excel and CSV files into DuckDB, enabling schema inspection, custom SQL queries, and statistical summaries without needing a separate database server.

Can I join tables across multiple Excel sheets and CSV files in a single query?▼

Yes, multiple Excel sheets and CSV files are loaded into a single DuckDB query context, enabling cross-file joins, multi-table aggregations, and pivot-style analyses across all uploaded datasets.

What statistical summaries can I generate for numeric and categorical columns in my CSV data?▼

The skill generates numeric statistics like mean, median, standard deviation, and percentiles, plus null counts and top-value breakdowns for categorical fields, providing comprehensive statistical summaries for CSV and Excel data.

Does DuckDB support exporting SQL query results to JSON and Markdown formats?▼

Yes, SQL query results processed through DuckDB can be exported to CSV, JSON, and Markdown formats, allowing you to save outputs for reporting and downstream analysis.

How do I inspect the schema of a multi-sheet Excel workbook before writing SQL?▼

Use the schema inspection feature to discover sheets, columns, inferred data types, row counts, and sample rows in a multi-sheet Excel workbook before writing SQL queries.

What is the best way to cache SQL query results for repeated analysis on the same Excel files?▼

Use the built-in SHA256 file-hash-backed DuckDB database to cache loaded Excel and CSV data, accelerating repeated SQL queries and statistical analysis on identical file inputs.

Related Skills

Explore More Data & Analytics Skills→
HadokennnHadokennn
5

data-analysis

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

Community
Intermediate
bytedancebytedance
79.6k

data-analysis

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

Official
Intermediate
Mohamed-ElkahefMohamed-Elkahef

csv-data-visualizer

Generate interactive Plotly visualizations and statistical profiles from CSV datasets.

Community
Intermediate
xukrutdonutxukrutdonut

duckdb-en

Run SQL queries on CSV, Parquet, and JSON files using the DuckDB CLI.

Community
Advanced