i9wa4/dotfiles

Guide for creating effective skills. This skill should be used when users want to create a new skill (or update an existing skill) that extends Claude's capabilities with specialized knowledge, workflows, or tool integrations.

Python environment and execution guide. Use when: - Running Python scripts - Working with uv, poetry, venv

Restricted BigQuery dbt environment

Claude Code config optimization skill. Use when: - Editing CLAUDE.md, rules/, skills/, agents/, commands/ - User asks about config best practices - Checking optimization status - User says "claude code changelog" or "claude code updates" - User asks about new features or breaking changes in Claude Code

Codex CLI config optimization skill. Use when: - Editing agents.md or agents/ - User asks about Codex CLI config best practices - User says "codex cli changelog" or "codex cli updates" - User asks about new features or changes in Codex CLI

Fetch Slack thread from URL using API directly (no MCP server needed). Use when: - User provides a Slack message URL - User says "read this slack thread" or "fetch slack thread" - User wants to see conversation context from Slack - User wants to search Slack messages - User wants to fetch channel history (e.g., Google Calendar DM)

Terraform Expert Engineer Skill - Comprehensive guide for Infrastructure as Code, resource management, module design, and state management Use when: - Running terraform init, plan, apply, destroy - Managing Terraform state (import, move, rm) - Designing modules or configuring backends - Working with HCP Terraform / Terraform Cloud

Atlassian (Jira/Confluence) operations using acli and REST API scripts. Use when: - Working with Jira issues, boards, sprints - Converting Confluence pages to Markdown - Checking Jira authentication status - Searching or viewing Jira work items

Daily report creation skill. Summarizes GitHub and Jira activities, creates a draft, and posts as an Issue. Use when: - Asked to "create daily report" or "write daily report" - Asked to "summarize today's activities" - Requested to create a daily report or journal

draw.io diagram creation, editing, and review. Use for .drawio XML editing, PNG conversion, layout adjustment, and AWS icon usage.

Git operations guide. Provides how-to for common git tasks. Use when: - Writing commit messages (Conventional Commits format) - Understanding git workflows

GitHub operations guide using gh CLI. Use when: - Working with GitHub Issues - Managing sub-issues (parent-child relationships) - Posting comments to a PR - Posting inline comments to a PR - Replying to PR comments - Checking diffs with line numbers

Orchestration workflow for orchestrator role ONLY. Use when: - Agent's $A2A_PEER environment variable contains "orchestrator" Do NOT use for worker or observer roles.

BigQuery Expert Engineer Skill - Comprehensive guide for GoogleSQL queries, data management, performance optimization, and cost management Use when: - Running bq commands (query, load, extract) - Writing GoogleSQL queries (functions, JOINs, CTEs) - Designing partitioned/clustered tables - Using BigQuery ML or external data sources

Jupyter Notebook Expert Skill - Guide for notebook execution and Databricks kernel integration Use when: - Executing Jupyter notebooks via CLI (jupyter execute) - Running notebooks with Databricks kernel - Configuring notebook execution options (timeout, inplace)

Databricks Expert Engineer Skill - Comprehensive guide for data engineering, machine learning infrastructure, and permission design Use when: - Running databricks CLI commands (auth, api) - Executing SQL queries via Databricks SQL Warehouse - Working with Unity Catalog permissions - Managing Lakeflow Jobs or Delta Lake

dbt Expert Engineer Skill - Comprehensive guide for dbt development best practices, command execution, and environment configuration Use when: - Running dbt commands (debug, compile, run, test, show) - Setting up Issue-specific targets in profiles.yml - Working with Databricks SQL dialect in dbt