Writing Queries
Component skill for systematic SQL query development in DataPeeker analysis sessions
Install
/plugin marketplace add tilmon-engineering/claude-skillsThe repo is a Claude Code plugin marketplace. Run /plugin afterwards to pick the plugin that includes this skill.
npx skills add tilmon-engineering/claude-skills --skill writing-queriesgit clone --depth 1 https://github.com/tilmon-engineering/claude-skills.git /tmp/claude-skills
mkdir -p ~/.claude/skills
cp -r /tmp/claude-skills/plugins/datapeeker/skills/writing-queries ~/.claude/skills/writing-queriesPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Writing Queries ## Purpose This component skill guides systematic query development for analytics. Use it when: - Writing SQL queries for analysis tasks - Need to ensure queries are correct, documented, and reproducible - Referenced by process skills requiring query execution - Struggling with how to express an analytical question in SQL ## Prerequisites - CSV files imported to database (relational database with SQL support) - SQL query tool available (database CLI, IDE, or query interface) - Understanding of table schema (use `understanding-data` skill if needed) - Clear analytical question to answer ## Query Development Process Create a TodoWrite checklist for the 5-phase query development process: ``` Phase 1: Clarify Analytical Question Phase 2: Design Query Logic Phase 3: Write SQL Phase 4: Verify Results Phase 5: Document Query ``` Mark each phase as you complete it. Save queries in numbered markdown files. --- ## Phase 1: Clarify Analytical Question **Goal:** Translate vague analytical question into specific, answerable query requirements. ### Ask Clarifying Questions Before writing any SQL, ensure you can answer: 1. **What exactly are we measuring?** - Specific metric name and calculation method - Example: "Total revenue" vs "Average revenue per customer" vs "Revenue per day" 2. **What is the unit of analysis?** - Per transaction, per customer, per day, per product, etc. - Example: "Daily sales" means one row per date
Details
- Skill name
writing-queries- Repository
- tilmon-engineering/claude-skills
- Path
plugins/datapeeker/skills/writing-queries/SKILL.md- License
- MIT
- Repo updated
- 22 May 2026
FAQ
What does the Writing Queries skill do?
Component skill for systematic SQL query development in DataPeeker analysis sessions
How do I install the Writing Queries skill?
Claude Code plugin: /plugin marketplace add tilmon-engineering/claude-skills. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Writing Queries popular?
It lives in tilmon-engineering/claude-skills, which has 5 GitHub stars and 2 forks.
Related skills
Analyze Branch
5tilmon-engineering/claude-skills
Use when analyzing another branch's iteration journals to extract findings, decisions, and insights from divergent work
Branch Status
5tilmon-engineering/claude-skills
Use when user wants detailed status report for single autonomy branch including iteration timeline and metrics progression
Checkpoint Iteration
5tilmon-engineering/claude-skills
Use when saving current iteration progress mid-conversation, before context compaction, or at interim pause points
Add Repo Inst
8ranbot-ai/awesome-skills
Please browse the current repository under /workspace/{{ REPO_FOLDER_NAME }}, look at the documentation and relevant code, and understand the purpose of this repository.
Google Drive Management
5astoreyai/claude-skills
Manages Google Drive files and folders through the Drive API. Search for files, read content, create and update documents, organize folders, manage permissions, and sync files. Use when working with Google Drive, uploading/downloading files, searching Drive content, or managing Drive organization.
AI Blog Intro Writer
8ranbot-ai/awesome-skills
AI Blog Intro Writer. Use when working with topic and article angle, or article draft.
Browse the most popular Claude skills, all writing & content skills, or write your own with the skills generator.