Skill

csv-analysis

This skill should be used when analyzing CSV files with SQL queries. Relevant when the user asks to query CSV data, filter rows, aggregate columns, or explore tabular datasets. Common triggers: "analyze this CSV", "query CSV", "filter CSV data", "count rows in CSV", "summarize CSV".

Install

npx claudepluginhub totto2727-org/monorepo --plugin totto2727

Tool Access

This skill uses the workspace's default tool permissions.

Preview

Analyze CSV files using DuckDB SQL queries.

SKILL.md

Similar Skills

cache-components

Guides Next.js Cache Components and Partial Prerendering (PPR) with cacheComponents enabled. Implements 'use cache', cacheLife(), cacheTag(), revalidateTag(), static/dynamic optimization, and cache debugging.

cache-components

139.2k

mcp-builder

9 files

Guides building MCP servers enabling LLMs to interact with external services via tools. Covers best practices, TypeScript/Node (MCP SDK), Python (FastMCP).

anthropics-skills-13

124.2k

canvas-design

20 files

Generates original PNG/PDF visual art via design philosophy manifestos for posters, graphics, and static designs on user request.

anthropics-skills-13

124.2k

Stats

Parent Repo Stars0

Parent Repo Forks0

Last CommitApr 16, 2026

Actions

View Source View Plugin View on GitHub View README

CSV Analysis with DuckDB

Analyze CSV files using DuckDB SQL queries.

Execution

Run queries via the DuckDB CLI:

duckdb -c "SELECT * FROM 'data.csv' LIMIT 10;"

For multi-line queries, use a heredoc:

duckdb <<'SQL'
SELECT column1, COUNT(*) AS cnt
FROM 'data.csv'
GROUP BY column1
ORDER BY cnt DESC;
SQL

Load All Data

SELECT * FROM 'data.csv';

Select Specific Columns

SELECT column1, column2, column3
FROM 'data.csv';

Filter Rows

Retrieve only rows matching a specific condition:

SELECT *
FROM 'data.csv'
WHERE column1 = 'value';

Filter with multiple conditions:

SELECT *
FROM 'data.csv'
WHERE column1 = 'value'
  AND column2 > 100;

Combined Column and Row Filtering

SELECT column1, column2
FROM 'data.csv'
WHERE column1 LIKE '%keyword%'
  AND column3 IS NOT NULL;

Sorting

SELECT *
FROM 'data.csv'
ORDER BY column1 ASC, column2 DESC;

Aggregation

-- Count, sum, average
SELECT
  column1,
  COUNT(*) AS cnt,
  SUM(column2) AS total,
  AVG(column2) AS avg_val,
  MIN(column2) AS min_val,
  MAX(column2) AS max_val
FROM 'data.csv'
GROUP BY column1
HAVING COUNT(*) > 5
ORDER BY cnt DESC;

Distinct Values

SELECT DISTINCT column1
FROM 'data.csv'
ORDER BY column1;

Join Multiple CSVs

SELECT a.id, a.name, b.amount
FROM 'users.csv' AS a
JOIN 'orders.csv' AS b ON a.id = b.user_id;

Filter by Row Number

Retrieve a specific range of rows (e.g., rows 11-20):

SELECT *
FROM (
    SELECT *, row_number() OVER () AS rn
    FROM 'data.csv'
)
WHERE rn BETWEEN 11 AND 20;

Additional SQL Features

Refer to the official documentation only when you need other features.

Reference Documentation: