add-entity
Create a domain entity with multi-tenancy, auditing, soft-delete, and domain events. Use when adding new database entities to a module.
Create a domain entity with multi-tenancy, auditing, soft-delete, and domain events. Use when adding new database entities to a module.
Use when creating, improving, or troubleshooting Claude Code subagents. Expert guidance on agent design, system prompts, tool access, model selection, and best practices for building specialized AI assistants.
Use when adding documentation for a new Nango integration - creates main page, setup guide, and updates docs.json and providers.yaml following established patterns
Optimizes the performance of existing Liger Kernel Triton kernels. Profiles kernels, diagnoses bottlenecks (memory-bound vs compute-bound), generates multiple optimization variants with benchmarking, and applies the best variant while maintaining correctness. Supports GPU architecture-specific optimization (Ampere, Hopper, Blackwell). Use when a user asks to optimize, speed up, tune, profile, or reduce memory of an existing Liger kernel.
Correctness invariants and architectural guidance for the adapter layer, coordinator, pgwire, peek paths, and timestamp oracle. Trigger when the user works on or asks questions about these subsystems — including "how does the coordinator work", "what are read holds", "explain the peek path", "how does timestamp selection work", "why does this query block". Also trigger when editing files in src/adapter/, src/pgwire/, or src/timestamp-oracle/.
Perform a local code review of the current branch's changes against Materialize project standards. Trigger when the user says "review my code", "review my changes", "check my diff", "does this look ok", "what do you think of this PR", "code review", or asks you to look over changes before merging. Also trigger when the user passes a PR number and wants feedback on quality, style, or correctness.
General guide for running tests and choosing the right test framework in Materialize. Trigger when the user wants to "run tests", "run testdrive", "run sqllogictest", "run mzcompose", "run cargo test", "run pgtest", "rewrite test results", "add a test", "reproduce a bug", "write a regression test", or mentions testing, testdrive, sqllogictest, mzcompose, pgtest, cargo test, nextest, flaky tests, or test failures. Use this skill even if the user just says "test this" or "how do I verify this works" without naming a specific framework. For deep guidance on specific frameworks, see the dedicated skills: mz-platform-checks (upgrade/restart survival), mz-parallel-workload (concurrent stress testing), and mz-limits-test (scaling to many objects).
Add, modify, or debug benchmark scenarios for measuring Materialize performance. Covers three frameworks: Feature Benchmark (single-operation micro-benchmarks), Scalability Test (SQL throughput under concurrency), and Parallel Benchmark (sustained latency over time via scenarios.py). Trigger on "benchmark", "feature benchmark", "scalability test", "parallel benchmark", "performance regression", "micro-benchmark", "TPS", "latency test", or when editing files in feature_benchmark/scenarios/, scalability/workload/workloads/, or parallel_benchmark/scenarios.py. Note: this is about benchmark measurement frameworks, not the parallel-workload stress-testing framework (which tests for panics under concurrency, not performance).
Investigate CI failures on a PR using gh and bk CLI tools. Trigger when the user asks about failing checks, Buildkite failures, or CI issues — including casual phrases like "why is CI red", "build broken", "checks failing", "what went wrong in CI", "nightly broke", "tests failing on this PR", or pastes a Buildkite URL. Also trigger when the user mentions a specific PR number and wants to understand why it's failing.
Add a new LLM provider to hermesllm. Use when integrating a new AI provider.
Bump a database migration's timestamp to the current time. Required when a PR's migration is older than one already merged to main. Use when asked to "bump migration", "update migration timestamp", or when a migration ordering conflict is detected.
Help with Fleet GitOps configuration files including queries, profiles, software, and DDM declarations with validation against upstream references.
Perform comprehensive code reviews focusing on best practices, security vulnerabilities, performance optimization, and maintainability
Smart LLM router — save 67% on inference costs. Routes every request to the cheapest capable model across 55+ models from OpenAI, Anthropic, Google, DeepSeek, xAI, NVIDIA, and more. 11 free NVIDIA models included.