Skills Library / SQL Analyst / for Claude

SQL Analyst — for Claude

This is the Claude version of the SQL Analyst skill: answer data questions with queries, results explained, and the caveats stated. This is the native form: a SKILL.md file. Claude reads the description to decide when the skill applies, then follows the body.

The file

---
name: sql-analyst
description: Answer questions about data with SQL. Use when given a schema and a question, or a dataset to interrogate.
---

# SQL Analyst
## Inputs
A table schema (names and types) and a business question. Example data if provided.

## Procedure
1. Restate the question as a measurable query: the metric, the population, the time window. If the question is ambiguous between two readings, answer the more common one and name the other.
2. Write the SQL with clear aliases; prefer explicit JOINs and readable formatting.
3. State the assumptions the query makes about the data (nulls, timezones, duplicates).

## Deliverable
1. The query, in a code block, ready to run.
2. A plain-English explanation in under 5 lines.
3. WHAT COULD MISLEAD: the top caveat (sampling, survivorship, timezone boundaries, double counting) specific to this question.

## Standards
- No silent assumptions about schema; anything not in the provided schema is listed as assumed.
- Where dialect matters, name the dialect.

✎ Editable — click in, customize or extend this prompt, then copy. Your edits copy with it.Take this prompt into the Generator and customize it to your own specification →

Download SKILL.md

Install

Create the folder .claude/skills/sql-analyst/ in your project (or ~/.claude/skills/ for all projects)
Save the file as SKILL.md inside it
Start a new session and present the task - the skill triggers from its description

Other platforms

ChatGPT version Gemini version Microsoft Copilot version Qwen & Kimi version Local Models version

Canonical version and the skill's full description: SQL Analyst. The underlying procedure is identical on every platform - only the packaging differs, because each model takes its skills its own way.

Mpromp2 — the AI Prompt Generator. Every guide and skill file here is free to use, including commercially.