Dbt Strategy
Use when creating or modifying dimensional dbt models in warehouse-backed analytics projects. Covers a four-layer warehouse architecture (sources/staging/core/marts), naming conventions, no-alias SQL rule, surrogate-key and missing-record patterns, incremental strategies, deduplication, and common project macros. Use when building fact tables, dimension tables, staging models, writing SQL, or des…
Managed Codebase Context
Use when connecting to a managed codebase-context MCP/session service, checking stale maps, or safely using MCP-provided repository context.
Model Routing
Use when selecting a model for a new task or subagent, deciding whether to escalate after a failed attempt, or designing a multi-agent pipeline with mixed task complexity.
Canonical Advisor Routing
Use when routing a prompt to a local provider CLI for a second opinion, review, or plan -- you are about to call a provider directly, need the response saved for later, or want a single consistent way to invoke codex/gemini/claude.
Test Preserving Refactor
Use when code needs restructuring and observable behavior must stay unchanged, with existing tests kept green at every step.
Bigquery Cost Audit
Use when reviewing BigQuery spend, query failure patterns, or scan inefficiencies -- identifying which jobs, users, or projects drive cost, or preparing optimization recommendations for a cost review.
Incremental Migration
Use when migrating APIs, libraries, or patterns across a large codebase and a single mega-commit would be too risky to review or merge.
Search Before Building
Use when about to add a new helper, utility, or abstraction, a task sounds like a solved problem, a new external dependency is being considered, or custom code is proposed without checking what already exists.
Agent Runtime Patterns
Use when optimizing agent runtime loops, card packs, MCP session lifecycle, tool-call count, or multi-agent orchestration patterns.
Log Driven Diagnosis
Use when debugging complex runtime failures, distributed systems, or issues where a local debugger cannot be attached.
Metric Impact Analyzer
Use when a change may affect metrics, semantic models, dashboards, reporting, or stakeholder-facing KPIs and you need to know whether business meaning or downstream BI assets change.
Architecture Simplification
Use when a codebase carries over-engineered abstractions, unnecessary layers, or redundant logic that should be collapsed without changing behavior.
No Fluff
>
Incident Readout
Use when a bug fix or complex debugging session concludes and a blameless post-mortem summary is needed for human review.
Dead Code Removal
Use when unused functions, classes, exports, or files need to be identified and safely deleted.
Dbt Incremental Strategy Audit
Use when reviewing a new or changed dbt incremental model -- the strategy looks over-engineered, rebuild or delete behavior is unclear, or the model deviates from how the rest of the repo handles incrementals.
Agent Harness Design
Use when designing tool definitions for a new agent or subagent, an agent shows high retry rates, ambiguous tool invocations, or silent failures, or an existing agent harness needs a quality review.
Tri Model Review
Use when a request needs parallel external perspectives — combined backend and UI work, code review from multiple angles, or cross-validation where different models may disagree.
Context Retrieval Loop
Use when starting work in an unfamiliar area of a codebase, spawning a subagent that needs targeted file context, a first search pass missed the relevant file, or the file scope of a task is unclear.
Structured Code Search Mcp
Use when designing or using MCP-backed structured code search with search, AST query, symbol inventory, and bounded extraction workflows.
Context Compression
Use when conversation context is bloated, constraints are being forgotten, or a compact handoff is needed before continuing work.
Sql Business Logic Review
Use when reviewing SQL that affects reporting, metrics, transformations, financial logic, product logic, or stakeholder-facing outputs -- especially when a query still runs fine but its business meaning may have drifted.
Semantic Layer Change Review
Use when a change touches dbt semantic models, metrics, saved queries, or other semantic-layer YAML -- especially when an existing metric's expression, aggregation, filters, or dimensions are modified.
Failure Triage
Use when confronted with an unknown failure in CI or production, before committing to a deep debugging approach.
Red Team Eval Authoring
Use when creating or reviewing red-team eval plugins, attack templates, grader rubrics, safety fixtures, or model-risk test metadata.
Awesome Ai Devtools
The open-source map of the AI developer tooling ecosystem
Brainstorming
Use when starting any creative work — creating features, building components, adding functionality, or modifying behavior — before any implementation begins.
Regression Bisecting
Use when a bug was recently introduced but you don't know which commit caused it.
Naming And Structure Cleanup
Use when naming conventions or file structure drift across a project and need to be made consistent without changing business logic.
Safe Refactor
Use when code needs restructuring without changing observable behavior.
Dbt Preflight
Use when a dbt change needs preflight before a PR, review, or merge -- changed models, snapshots, seeds, macros, or semantic YAML whose blast radius and test coverage are not yet known.
Ai Slop Cleaner
Use when a working code path feels bloated, noisy, or over-abstracted, when asked to clean up or deslop AI-generated code, or when a reviewer-only anti-slop pass is requested.
Agent Session Forensics
Use when diagnosing agent session history, interrupted tool loops, missing tool results, timing bottlenecks, or subagent trace correlation.
Minimal Reproduction
Use when a bug must be isolated from a large application into a standalone, runnable script or single test case.
Flaky Test Investigation
Use when tests pass and fail intermittently without code changes, or a test passes alone but fails in the full suite.
Handoff Discipline
Use when ending a session, handing a task back to the user, or approaching the context limit with work unfinished -- the next session or engineer must be able to resume the work instantly.
Repo Map
Use when the task is to understand an unfamiliar codebase, locate key entry points, or summarize architecture before editing.
Dependency Cleanup
Use when package manifests carry unused or redundant third-party dependencies that slow builds, widen the security surface, or complicate updates.
Data Quality
Use when adding or reviewing data quality tests for dbt models in warehouse-backed analytics projects. Covers dbt generic tests, singular tests (assert_*.sql), accepted-values macros, dbt_utils patterns, cross-system consistency tests, and warehouse-oriented validation. Use when writing data tests, creating assert_*.sql files, testing business logic, or validating referential integrity.
Deploy Pipeline Runbook
Use when a release spans multiple systems or vendors, order of operations matters with rollback planned up front, or a failed step in one system could corrupt state in a downstream system.
Context Minimization
Use when a task runs long and the context window is filling -- large files are being read whole, command output is flooding the transcript, or responses are getting verbose and slow.
Local Rag Mcp
Use when querying, ingesting, or maintaining a local RAG MCP corpus for semantic document retrieval with privacy controls.
Dispatching Parallel Agents
Use when facing 2+ independent tasks that can be worked on without shared state or sequential dependencies
Skill Evaluation Workbench
Use when designing, running, debugging, or hardening deterministic eval suites for agent skills, prompts, tool workflows, or MCP-backed cases.
Systematic Debugging
Use when encountering any bug, test failure, or unexpected behavior, before proposing fixes.
Bug Hunt
Use when reproducing, isolating, and fixing a bug with the smallest safe change.
Prompt Evaluation Runner
Use when evaluating prompts, LLM outputs, red-team suites, or model behavior with local eval configs and safe provider/cost controls.