joecastelino
@joecastelino
Public Skills
bc-menu-sales-reports
by joecastelino
Run the Blackstone Chevrolet & Cadillac (BC, a GM store, dealer 1251) Menu Sales scorecards — Daily Closed (2x/day) and Closed Month-To-Date (1x/day) — from the LIVE Tekion OpenAPI, and have Stacey DRAFT them to Ruben Estrada (Restrada@blackstonegm.com). This is the GM-store sibling of the SCT/Kevin pipeline (sct-menu-sales-api-scorecard). Use for any "BC menu report", "Blackstone Chevy/Cadillac menu sales", or Ruben report request.
bt-menu-sales-reports
by joecastelino
Run the Blackstone Toyota (BT, dealer 1249) Menu Sales scorecards — Daily Opened, Daily Closed, and Closed Month-To-Date — from the LIVE Tekion OpenAPI. The 4th sibling of the SCT/Kevin, BC/Ruben, and TOL/Sean pipelines. Use for any "BT menu report", "Blackstone Toyota menu sales", or Tony Garcia menu-sales report request. (Menu REBUILD work is a different skill — bt-tony-menu-rebuild.)
gm-sasar-action-tracker
by joecastelino
Fill out a GM SASAR (warranty self-audit) corrective-action tracker + BAC Action Plan doc for a GM store (built for Blackstone Chevy BC/1251, Ruben Estrada). Joe supplies RO# + GM citation shorthand; Jay pulls each RO from Tekion, verifies the deficiency, writes a full 20-column corrective-action row, and emails the xlsx + paste-ready action-plan rows. Use when Joe mentions SASAR, GM warranty audit/review, "Action Tracker", or gives lists of ROs with GM citations.
jay-google-sheets-drive-access
by joecastelino
Access Joe's Google Sheets and Drive files from Jay's profile — token symlink bootstrap, reading/writing native Sheets, downloading Drive-hosted .xlsx files (like AMG WIP.xlsx) via alt=media, and the xlsx-vs-native-Sheet write limitation. Established 2026-08-02.
jay-brain-and-skill-index
by joecastelino
Operate, diagnose, and repair Jay's GBrain (the single Jay-only knowledge brain) plus the self-maintaining skill index. Use when the nightly brain refresh fails or looks frozen, when gbrain is "command not found", when GBrain search returns nothing/stale, when session knowledge needs to be captured into the brain so it's retrievable later, or when the skill index needs descriptions/metadata/usage-counts. Covers the bun-PATH break, the multi-brain split, the embedding-key gotcha, and the capture-session / skill-usage tracking scripts.
dealerdetail-api-pipeline-build
by joecastelino
Build the DealerDetail Tekion API-driven data pipeline (replacing the email/Excel prototype) by acting as PM and delegating tickets to Claude Code, then verifying independently. Covers the ticket workflow, the live infra (Supabase project, branch, creds), and the hard-won gotchas (Supabase shadow-DB, server-only smoke tests, git credential path, Tekion app-scope 403 on user lookups).
amg-wip-monthly-column-fill
by joecastelino
Fill a month column of Joe's AMG WIP workbook (the monthly fixed-ops tracker, rows=metrics cols=months, one tab per store) with Tekion data — hours sold by pay type, vehicle attendance, ToyotaCare hours, workshop hours, WIP $, ELRs. Includes the quota-free dealer-detail DB method for operation-level hours. Use when Joe says he needs to "finish" or "work on" the AMG WIP sheet for a month.
jay-gmail-draft-verification
by joecastelino
Independently verify a Gmail draft/send that Stacey (email-agent) reports she created — confirm it's actually in Drafts/Sent with correct recipients, body, and attachments, without trusting her self-report alone. Use whenever Joe asks to "chase" or double-check an email Jay routed through Stacey, or when Jay's own Gmail-dependent flow (himalaya/Google API) throws auth errors.
hermes-slack-slash-commands
by joecastelino
Diagnose and fix Hermes slash commands on Slack — especially the "/sethome failed because the app did not respond" error. The Hermes gateway registers exactly ONE Slack slash command (/hermes); every other command (sethome, reset, model, new, status, …) must be invoked as a SUBCOMMAND: /hermes . A bare /sethome is not registered with Slack, so Slack times out. Use when a Slack user reports a slash command "doesn't respond", goes to the wrong thread, or asks to set the Slack home channel. Also covers the "Sending messages to this app has been turned off" DM lockout (App Home Messages Tab disabled) and diagnosing any "can't talk to <agent> on Slack" report across fleet profiles.
install-agent-bridge-into-peer
by joecastelino
Make ANOTHER AMG agent (e.g. Autumn, Don, Ralph) able to message Jay/peers DIRECTLY from their own sessions — not just be reachable BY Jay. Installs the ask-agent bridge helper + a MEMORY.md entry into the target agent's profile so the capability is discoverable in their real chats. Use when Joe says "set up a pipeline between <agent> and Jay" or "<agent> needs to talk to you".
amg-store-manager-meeting-prep
by joecastelino
Prep Joe for a working meeting with a store service manager (e.g. Ruben at BC, Kevin at SCT, Sean at TOL) — actionable items backed by LIVE store baselines computed from Jay's cached Tekion pipeline data, framed as what JOE (VP Fixed Ops) can do to help, drafted to Joe's own inbox. Use for any "prep a meeting with <manager>", "action items for <store>", "what can I do to help him" ask.
amg-wip-payroll-vs-rth-analysis
by joecastelino
Analyze an AMG per-store semi-monthly WIP workbook (tech payroll vs RTH / labor relieved to WIP) and produce Joe's service-manager meeting prep — trend table, per-tech gap ranking, talking points, recoverable-$ target. First run 2026-07-08 on "2026- SCWV Wip.xlsx" (Stevens Creek VW); Joe approved the format verbatim.
bc-gm-menu-build
by joecastelino
The Blackstone Chevrolet & Cadillac (BC, Tekion dealer 1251) GM service-menu build project. Contains Joe's spec direction (clone the Blackstone Toyota architecture), the verified GMLOF oil-tier price audit, the parts-override plan for vehicle-correct GM parts, and open decisions. Load for ANY "GM menu", "BC menu build", "GMLOF", or Blackstone Chevrolet service menu work.
bt-tony-menu-rebuild
by joecastelino
The Blackstone Toyota (BT, dealer 1249) service-menu rebuild project for Tony Garcia (Service Manager). Tony wants menus restructured into Factory Recs / Factory Recs Plus with 25 ordered add-on services. Contains the FULL locked spec, Joe's approved decisions, the opcode audit results, and the build plan. Load for ANY "BT menu", "Tony menu", "Factory Recs", or Blackstone Toyota service menu work. STATUS 2026-07-21: full 5K–200K range (5K-step) built, PUBLISHED, Tony-validated; Phase 7 generic Transmission Fluid placeholders DONE; Phase 8 Tony's BG MENU REVAMP 2026 part-match batch DONE + quote-verified (baseline tony-partmatch-baseline-20260721.json). Remaining: x2.5K half-step menus + EV rows only.
agent-to-agent-bridge
by joecastelino
Talk directly to other AMG agents (Walter II, Ralph, Don, etc.) from Jay's session via a CLI bridge. Use when Joe asks Jay to coordinate with, relay to, or ask another agent something on the same machine.
hermes-agent-provider-switch
by joecastelino
Diagnose why an AMG agent (Walter II, Don, Ralph, Stacey, etc.) is dead/unresponsive on an LLM-billing error, and switch it from OpenRouter to the ChatGPT-Team Codex OAuth provider. Use when an agent boots but can't reply, an ask-agent ping returns an HTTP 402 (out of credits) or 400 (unsupported model), or OpenRouter credits are exhausted. Covers the read_file API-key-masking landmine and how to discover the account's valid Codex model names.
apple-notes
by joecastelino
Manage Apple Notes via the memo CLI on macOS (create, view, search, edit).
apple-reminders
by joecastelino
Manage Apple Reminders via remindctl CLI (list, add, complete, delete).
findmy
by joecastelino
Track Apple devices and AirTags via FindMy.app on macOS using AppleScript and screen capture.
imessage
by joecastelino
Send and receive iMessages/SMS via the imsg CLI on macOS.
claude-code-headless-jay
by joecastelino
Run Claude Code (claude CLI) headless/non-interactive from Jay's Hermes session. Solves the hang where plain claude -p waits forever on interactive login because Jay's profile HOME is unconfigured.
dealerdetail-dev-setup
by joecastelino
Bootstrap the DealerDetail Next.js app for local development against the live Supabase project, verify the DB + Prisma migration state, and validate the Tekion production API before building the API-driven data pipeline. Covers credential retrieval, .env wiring, and the gotchas (Slack-mangled connection strings, missing psql, prototype-vs-API architecture). Use whenever standing up, migrating, or extending the DealerDetail Fixed Ops app.
dealerdetail-persona-and-dedup
by joecastelino
Split the DealerDetail advisor dashboard by Tekion persona (SERVICE_ADVISOR vs an "Others" bucket for cashiers/warranty clerks/service managers/techs), backfill the persona column from the Tekion users API, and fix duplicate-advisor rows caused by null-name pre-scope-upgrade pulls. Use when advisor numbers look polluted by non-advisors, when you see an "Unassigned"/null advisor, when personas are 0/N populated, or when the same Tekion userId appears under two Advisor rows.
hermes-gateway-timeout-restart-loop
by joecastelino
Diagnose and fix an AMG agent (Walter II/base or any profile) that is restarting/flaky with systemd "Failed with result 'timeout'" + status=9/KILL in the journal. Root cause is a hung LLM turn (e.g. gpt-5.5/Codex stall) holding an in-flight 300s API call that blocks clean shutdown past the 60s TimeoutStopSec, so systemd SIGKILLs the gateway and loops. This is NOT a crash, NOT out-of-credits, and the OpenRouter fallback can't save it. Covers how to tell this apart from a billing failure, the exact systemd-log signature, and the per-agent (and fleet-wide) drop-in fix.
hermes-slack-token-recovery
by joecastelino
Fix an AMG Hermes agent that is silent on Slack because its SLACK_BOT_TOKEN/SLACK_APP_TOKEN are missing or wrong in the profile .env — including recovering LOST tokens from old session transcripts without asking Joe to regenerate them at api.slack.com. Use when an agent's service is running but it never answers Slack messages (Autumn case, 2026-07-14).