1. Habit
  2. Skills
  3. Data Analyst skill
cline · 2K installs

Data Analyst skill
Runs by itself, weekly metrics report.

Weekly metrics with clear definitions.

Install the Data Analyst skill and make it a habit: follow https://gethabit.dev/skills/cline/data-analyst.md

  1. 1Copy
  2. 2Paste into Claude Code, Codex or Cursor
  3. 3It runs by itself

2K installs37 starsApache-2.0 licenceSource on GitHub ↗

Data Analyst

by cline · 2K installs

The skill

The data analyst skill helps teams ask questions of ClickHouse data the way an analyst would: clarify intent, resolve definitions, run safe bounded SQL with clickhousectl, then report with caveats.

Only when you ask.

The habit

Weekly metrics with clear definitions.

↻ Runs by itselfweekly metrics report

How the habit works.
You don't have to.

Three questionsWhen does it start? How does it check its work? What does it remember?

01

It starts by itself

weekly metrics report. Runs in Claude Code routine.

  • ↻ weekly metrics report
  • 0 7 * * 1

02

It checks its work

intent confirmed, answer shaped. If a check fails, it stops.

  • ✓no intent field is still NEED FROM USER before querying
  • ✓every query ran through clickhousectl, not ClickHouse MCP tools
  • ✓each answer has Answer, How I measured it, SQL/source and Caveats
  • ✓artifact paths for saved CSVs or charts exist

03

It remembers

confirmed intent blocks. The next run reads it first: confirmed metric, population, window, grain and filters per question.

loops/clickhouse-metrics-report-loop/intents.md

One run, step by step.
Then it stops.

Stop ruleStops after 5 metric questions per run; asks before any unbounded or long query.

  1. 01

    Restate intent

    Fill the intent block from the saved definitions and ask you about any new gap.

  2. 02

    Verify connection

    Load skills/clickhouse/ and confirm the right local server or Cloud service.

  3. 03

    Resolve terms

    Use skills/reading-data-dict/ for any LOOK UP term.

  4. 04

    Run bounded SQL

    Run previews and aggregates with clickhousectl, using skills/clickhouse-best-practices/ for complex SQL.

  5. 05

    Analyze

    Use skills/analyzer/ for trends, comparisons and sanity checks.

  6. 06

    Save and report

    Use skills/plotting/ and skills/artifact-management/, then write the standard answer.

What it may do.
Nothing more.

Safe by defaultIt writes only in its own folder and asks you before anything goes out.

Is it for you?
Use it when it fits.

Quick checkRead both lists. If the left one sounds like you, the Data Analyst skill helps.

Use it when

  • ✓ You ask about active users or revenue
  • ✓ You need a funnel or trend from ClickHouse
  • ✓ You want a chart or data export

Skip it when

  • – Your data is not in ClickHouse
  • – You only need a raw table dump

Questions

Data Analyst skill, answered.

Why ask before querying?

The skill assumes first requests are underspecified and resolves the metric definition before running SQL.

Can it use ClickHouse MCP tools?

No. The skill runs every query through the clickhousectl CLI.

How do I install the Data Analyst skill?

Copy the prompt at the top into your agent. It installs the skill from cline/skills and sets up the habit. Or run npx skills add cline/skills --skill data-analyst.

Is the Data Analyst skill free?

Yes. It is published under Apache-2.0. Habit is free too.

Data Analyst. Now as a habit.

Install the Data Analyst skill and make it a habit: follow https://gethabit.dev/skills/cline/data-analyst.md

  • Free
  • No account
  • Undo in one line

All cline skills →More planning skills →

Works in

  • Claude Code
  • Codex
  • Cursor
  • ChatGPT
  • Claude app

Made by cline, published under Apache-2.0. Habit links to the original and never changes it. Is this your skill?

Copying didn't work here. Select the line and copy it by hand.