data-analysis

Ingest JSON, CSV, and Parquet files into DuckDB for SQL-based analysis.

558|75|Updated Dec 18, 2025
One-click install
npx skills add https://github.com/winstonkoh87/Athena-Public --skill data-analysis-winstonkoh87
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: data-analysis
Source: https://github.com/winstonkoh87/Athena-Public/tree/main/examples/skills/research/data-analysis
Command: npx skills add https://github.com/winstonkoh87/Athena-Public --skill data-analysis-winstonkoh87

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

Ingest large JSON, CSV, and Parquet datasets and turn them into structured analyses using an embedded DuckDB engine, avoiding ad-hoc scripting and manual file handling.

Core Features & Use Cases

  • Ingest, profile, and query large data dumps locally to generate file-level insights.
  • Auto-detect data formats (JSON/CSV/Parquet) and cache Parquet-processed results for fast subsequent queries.
  • Produce SQL-based insights and summaries suitable for dashboards or reporting.

Quick Start

Ingest your data file and run a quick analysis to generate key metrics.

Frequently Asked Questions about data-analysis

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

FAQPage Schema
How do I analyze large CSV and JSON files locally without writing ad-hoc scripts?

You can analyze large CSV and JSON files locally by ingesting them into an embedded DuckDB engine, which automatically detects formats and allows you to run standard SQL queries to derive actionable insights without manual scripting.

Does DuckDB support querying Parquet files and caching the results?

Yes, DuckDB supports querying Parquet files and automatically caches Parquet-processed results, enabling fast subsequent SQL queries and file-level profiling on your ingested datasets.

What's the best way to profile very large data dumps on my machine?

The best way to profile large data dumps locally is using an embedded DuckDB engine to ingest JSON, CSV, or Parquet formats, allowing you to generate file-level insights and structured summaries directly on your machine.

Can I run standard SQL queries on JSON files of any size?

Yes, you can run standard SQL queries on JSON files of any size by ingesting them into the embedded DuckDB engine, which handles large datasets efficiently and avoids manual file handling.

What do I need to set up before ingesting large datasets for local analysis?

You need to install DuckDB as the core dependency before ingesting large datasets, as the Skill relies on this embedded engine to process JSON, CSV, and Parquet files and generate structured analyses.

Are there limitations when auto-detecting data formats for local data analysis?

The local data analysis tool auto-detects JSON, CSV, and Parquet formats, but it is limited to these specific file types for profiling and querying, requiring DuckDB to execute the standard SQL operations on your data.