Skip to content

skilldrop·docs·How-to

Use the Data and analytics pack

Install the Data and analytics pack, run its first task, and follow a typical session step by step.

For analysts and the people who rely on their numbers: review SQL for the bugs that quietly inflate a figure, and spec dashboards around a decision instead of every chart that was easy to make.

Reach for it when: A number matters (a board metric, a finance figure, a team KPI) and people either disagree about it or are about to build a dashboard on it.

1. Install it

npx skilldrop-cli install --pack data-analytics                 # Claude Code, your user folder
npx skilldrop-cli install --pack data-analytics --project       # Claude Code, this repo
npx skilldrop-cli install --pack data-analytics --ide cursor    # or kiro, codex, antigravity, copilot
npx skilldrop-cli install --pack data-analytics --local         # this repo, hidden from git

In Claude Code you can also add the marketplace once (/plugin marketplace add sananthanarayan/skilldrop) and run /plugin install data-analytics@skilldrop.

It brings core with it, so the shared skills are there too.

2. Run the first task: check a query before its number goes into a report

Before you start:

Paste this into your agent:

Review this Postgres query before it goes into the finance dashboard. One row per region; customers.customer_id is unique and an order has many order_items. Finance reports in New York time.

SELECT c.region, SUM(o.amount_usd) AS revenue_usd
FROM orders o
JOIN customers c ON c.customer_id = o.customer_id
JOIN order_items oi ON oi.order_id = o.order_id
WHERE o.created_at BETWEEN '2026-09-01' AND '2026-09-30'
GROUP BY c.region;

How to tell it worked: sql-review opens with a verdict, flags the order_items join as multiplying revenue and the BETWEEN as losing 30 September, gives a corrected query with New York boundaries, and lists verification queries to prove the fix.

If nothing happens: If the review jumps to indexes before correctness, ask for it by name ("use sql-review"). If it guesses the database, tell it which one: integer division and timezone functions differ between engines.

3. A typical session

Bring:

You end with: Reviewed SQL whose number you can defend, and a dashboard spec a BI developer can build without guessing.

4. Run it as a loop

A loop runs the skills in order and stops at each gate for a verdict. Install and start one:

npx skilldrop-cli install --loop --pack data-analytics

Next

Edit this page on GitHub · View source