Stats
Actions
Tags
Help us improve
Share bugs, ideas, or general feedback.
From totto2727
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".
npx claudepluginhub totto2727-org/monorepo --plugin totto2727How this skill is triggered — by the user, by Claude, or both
Slash command
/totto2727:csv-analysisThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Analyze CSV files using DuckDB SQL queries.
Creates p5.js generative art with seeded randomness, noise fields, and interactive parameter exploration. Use for algorithmic art, flow fields, or particle systems.
Share bugs, ideas, or general feedback.
Analyze CSV files using DuckDB SQL queries.
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
SELECT * FROM 'data.csv';
SELECT column1, column2, column3
FROM 'data.csv';
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;
SELECT column1, column2
FROM 'data.csv'
WHERE column1 LIKE '%keyword%'
AND column3 IS NOT NULL;
SELECT *
FROM 'data.csv'
ORDER BY column1 ASC, column2 DESC;
-- 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;
SELECT DISTINCT column1
FROM 'data.csv'
ORDER BY column1;
SELECT a.id, a.name, b.amount
FROM 'users.csv' AS a
JOIN 'orders.csv' AS b ON a.id = b.user_id;
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;
Refer to the official documentation only when you need other features.
Reference Documentation: