td-skills: Instructions file for Claude Code

CLAUDE.md

This file provides guidance to Claude Code (claude.ai/code) when working with code in this repository.

Repository Purpose

This is a Claude Code skills marketplace for Treasure Data internal tools. It contains skill definitions that teach Claude how to work with TD-specific technologies: Trino SQL, Hive SQL, and digdag workflows.

Architecture

Skill Structure

Each skill is a directory containing a SKILL.md file with:

• YAML frontmatter: name and description fields that define when Claude should use the skill
• Markdown content: Detailed instructions, examples, and best practices that Claude follows

Organization

.claude-plugin/marketplace.json  # Plugin registry defining skill collections
sql-skills/
  ├── trino/SKILL.md            # Trino query expertise
  └── hive/SKILL.md             # Hive query expertise
workflow-skills/
  ├── digdag/SKILL.md           # Workflow authoring (.dig files)
  │   └── references/           # Operator, pattern, runtime, scheduling references
  └── dbt/SKILL.md              # dbt with TD Trino
template-skill/SKILL.md         # Template for new skills

Plugin Collections

The marketplace.json defines three plugin collections:

1. sql-skills: Trino and Hive query assistance
2. workflow-skills: Digdag workflow creation and management
3. template-skill: Template for creating new TD skills

Creating New Skills

When adding a new skill:

1. Choose the correct category: Place SQL-related skills under sql-skills/, workflow-related skills under workflow-skills/, or create a new category if needed

2. Create directory and SKILL.md:

   mkdir sql-skills/your-skill-name
   # Copy structure from template-skill/SKILL.md
   

3. Write YAML frontmatter:

   • name: lowercase-with-hyphens, unique identifier
   • description: Clear explanation of what the skill does and when Claude should use it

4. Include TD-specific patterns:

   • Use TD table naming: database_name.table_name
   • Include TD functions: TD_INTERVAL, TD_TIME_RANGE, TD_SCHEDULED_TIME
   • Use JST timezone for Japan data, UTC for others
   • Provide complete, working examples with realistic TD data patterns