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 totto2727This skill uses the workspace's default tool permissions.
Analyze CSV files using DuckDB SQL queries.
Guides Next.js Cache Components and Partial Prerendering (PPR) with cacheComponents enabled. Implements 'use cache', cacheLife(), cacheTag(), revalidateTag(), static/dynamic optimization, and cache debugging.
Guides building MCP servers enabling LLMs to interact with external services via tools. Covers best practices, TypeScript/Node (MCP SDK), Python (FastMCP).
Generates original PNG/PDF visual art via design philosophy manifestos for posters, graphics, and static designs on user request.
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: