Tools

Use this skill when writing or updating SQL queries (query.sql) or Python ETL scripts (query.py) following Mozilla BigQuery ETL conventions. ALWAYS checks for and updates existing tests when modifying queries. Coordinates downstream updates to schemas and tests. Works with bigquery-etl-core, metadata-manager, and sql-test-generator skills.

Master TypeScript's advanced type system including generics, conditional types, mapped types, template literals, and utility types for building type-safe applications. Use when implementing complex type logic, creating reusable type utilities, or ensuring compile-time type safety in TypeScript projects.

Track and manage tasks, projects, and tags using a SQLite-backed task tracking system. Use for task creation, project planning, todo lists, and productivity workflows.

ロギングやモニタリングを実装する際に使用。

Creates beautiful ASCII art visualizations for plans, architectures, workflows, and data. This skill should be used when explaining system architecture, creating implementation plans, showing workflows, visualizing comparisons, or documenting file structures. NOT for code syntax highlighting or markdown tables. User explicitly loves ASCII art - use liberally for visual communication.

Creates design document infrastructure including templates, workflows, and a specific design doc skill. Use when setting up design docs for a new project or when the user mentions "bootstrapping-design-docs".

Create a new git worktree for an agent to work in isolation. Use this when starting parallel implementation of a sub-issue to provide complete environment isolation with unique ports and database.

Run comprehensive code quality checks including TypeScript typecheck, ESLint linting, Prettier formatting, and Markdown validation. Auto-fixes formatting issues in agent mode or provides read-only checks for CI pipelines. Use when: (1) Before committing code changes, (2) In CI/CD pipelines for automated quality gates, (3) After making significant code changes, (4) When preparing code for review, (5) When ensuring code meets quality standards, (6) For type checking, linting, formatting, and markdown validation, (7) In pre-commit hooks, or (8) For automated quality gates before merging. Triggers: finalize, code quality, typecheck, lint, format, check code, quality check, run checks, pre-commit, before commit, CI checks, validate code.

Generate Python dataclasses dynamically from SQL queries and database schemas. Use this skill when you need to create type-safe Python classes representing SQL query results, including denormalized fields from JOINs.

Manages HyperFlow keyboard orchestration system including Hyper key architecture, Karabiner configuration, app launcher modifications, SuperWhisper mode integration, and debugging. This skill should be used when adding new keyboard shortcuts, modifying the hyperflow.sh launcher, configuring SuperWhisper modes, debugging race conditions, or when mentioned 'hyperflow', 'hyper key', 'keyboard workflow', 'karabiner', 'add shortcut'.

Create git commits following conventional commits format. Use when asked to commit changes.

Comprehensive React 19 patterns including all hooks, Server/Client Components, Suspense, streaming, and transitions. Ensures correct React 19 usage with TypeScript.

Find comparable sales and calculate ARV. Use when analyzing any property value.

Create new Agent Skills for Claude Code. Use when user wants to create a skill, add a new capability, document a CLI workflow, or asks how skills work.

Guide for configuring GitHub repository rules, branch protection, rulesets, CODEOWNERS, and security policies. Use when users need to set up branch protection rules, configure required reviews, enforce status checks, manage merge strategies, or implement repository security policies.

Create and manage content for blogs, social media, video, and newsletters. USE THIS SKILL when user says "create blog post", "write social post", "content calendar", "repurpose content", "video script", or needs content creation help.

Expert TypeScript/JavaScript development guidance. Use when planning or writing TypeScript/JavaScript code, setting up TS/JS projects, configuring build tools (pnpm, Vite, TypeScript), implementing tests (Vitest), adding logging (pino for services, chalk/console for CLIs), working with React/Tailwind/Xstate, or following FP patterns. Covers stack decisions, tooling setup, testing strategies, and logging patterns for both services and CLI tools.

Use when managing Serena MCP memory files for consolidation, archival, or evergreen doc updates - provides naming conventions, automated workflows with interactive approval, and Python tools for reliable file operations

Guide for creating and configuring custom sub-agents for Claude Code. Use this skill when you need to define specialized agents with dedicated system prompts, tool sets, and models to handle specific tasks.

Build, run, test, and debug Apple platform apps (iOS, macOS) headlessly using xcede CLI. Use when working with Xcode projects or Swift packages outside of Xcode IDE. Covers building for devices/simulators/Mac, running apps, executing tests (XCTest/Swift Testing), debugging with lldb, and configuring projects via .xcrc files.