joe-broadhead

User-facing Gateway assistant for OpenCode, Telegram, and WhatsApp sessions. Use when the user asks normal Gateway questions, wants to create or manage durable work, asks what needs attention, or interacts from a linked channel.

Coordinate Gateway queues, runs, channel bindings, requests, and service state.

Plan Gateway roadmaps and durable scheduler tasks using Gateway MCP tools.

Spec-driven review and verification gate for Gateway tasks across code, docs, slides, research, operations, and other deliverables.

Execute a Gateway scheduler stage and return the required structured stage result.

Supervise a durable Gateway roadmap using event cursors, roadmap memory, and safe action proposals.

Use when running a periodic OpenWiki review cycle that looks for stale knowledge, missing links, unresolved proposals, inbox backlog, and schema-pack drift.

Use when proposing OpenWiki page edits, source additions, or synthesis pages through proposal-safe configured OpenWiki MCP tools.

Designs, debugs, and operationalizes dbt-nova eval suites for manifest metadata quality and agent tool-use quality. Use when creating bridge evals, provider-backed agent evals, CI eval gates, regression suites for Nova metadata, or when interpreting dbt-nova eval artifacts and failures.

Adversarially reviews high-stakes dbt-nova analytics answer drafts for evidence quality, semantic-layer bypass, unsafe raw joins, stale or unknown freshness caveats, and provenance-backed fixes. Use before leadership-bound, launch-readiness, customer-facing, or recurring production answers.

Answers business questions with Nova using first-principles decomposition, canonical KPI discovery, explicit entity selection, validated filters, bounded execution, and evidence-first reporting. Use when resolving metrics, comparing performance, validating measures, or running recurring analytical workflows through Nova MCP or the dbt-nova CLI.

Runs deterministic governance audits with Nova using frozen scope, repeatable scoring, explicit blocker extraction, and remediation planning. Use when enforcing metadata standards, testing and documentation gates, ownership and compliance requirements, and rerunnable audit evidence through MCP or the dbt-nova CLI.

Builds and reviews high-signal `meta.nova` and curated domain references for dbt resources. Use when adding Nova metadata, choosing canonical datasets or indicators, defining model-bound measures or metric templates, annotating columns, de-ranking helper models, authoring domain reference docs, or improving Nova MCP search and metadata scores.

Improves dbt project structure with Nova using first-principles architecture work: define the repeated business concept, scope candidate clusters, compare overlap, grain, semantics, lineage, and blast radius, choose canonical execution surfaces, and produce migration-safe refactor plans through Nova MCP or the dbt-nova CLI.

Finds and plans structural cleanup in dbt projects with Nova using first-principles triage: freeze scope, detect overlap clusters, duplicate indicators, naming drift, and canonical conflicts, separate accidental duplication from legitimate specialization, quantify impact, and produce prioritized cleanup queues through Nova MCP or the dbt-nova CLI.

Designs dashboard-ready analytical products with Nova using first-principles BI engineering: start from the decision, audience, and consumer artifact; resolve canonical indicators; choose execution entities and grain; validate filters, comparisons, and bounded sample outputs; then produce dashboard specs, dataset contracts, metric cards, and viz QA handoffs through MCP or the dbt-nova CLI.

Google Workspace automation: Drive (44 tools), Gmail (39), Calendar (22), Sheets (33), Slides (25), Docs (26), Tasks (13), Forms (16). Use when the user asks to manage files, search email, draft replies, schedule meetings, create spreadsheets, analyze data, build presentations, write documents, manage tasks, or build forms.

workspace-lite installer/operator: Use when helping a user install, configure, push, deploy, redeploy, or troubleshoot the Workspace Lite Google Workspace MCP servers, Apps Script web apps, clasp, tokens, or OpenCode config.

Author and validate production-safe Slideflow YAML for Google Slides, Google Docs, Google Sheets, and local PowerPoint, including composable dbt connectors and AI providers.

Open-Meteo weather forecasts, geocoding, saved locations, demand signal features, and threshold filtering via MCP + CLI. Use when a task needs current/daily/hourly weather, weather-derived demand features for forecasting, city geocoding, or repeatable business-location aliases.

Local-first agent clock with MCP tools + CLI. Current time, IANA timezone ops, date arithmetic, calendar queries, business days, offline holiday lookups (2000-2030), and SQLite timers. Use when a task needs reliable agent time context, timezone conversion, working-day counts, holiday-aware planning, date formatting, or local reminder timers.