Skills

Adds a new table to the Reapit Bronze/Silver orchestration pipeline. Reads the Silver notebook to derive schema, target, and column list, then generates the INSERT SQL for [CONFIG].[Processes], renames the notebook to follow the {n}_merge_{table} convention if needed, and updates the context CSV.

Reads a staging table DDL from the CRL repo, generates the corresponding [dw] Dim or Fact table DDL and a [LOAD] stored procedure using an UPDATE/INSERT pattern with RowHash computed on the fly. Surrogate keys use the @maxid + ROW_NUMBER() pattern (Fabric-compatible). Output written to _output\ and opened in Notepad.

Re-clones the project repo at the start of a new session. Fully context-aware — reads customer, project, repo name and URL from the project CLAUDE.md. If there is only one repo, no input is needed: just confirm and it deletes the old folder and clones fresh. Use this every time you pick a project back up.

Logs a contract for Disseminate Limited. Checks Downloads for the most recent file, reads the PDF to extract key terms, confirms details, saves the hard copy to _contracts\{Category}\, checks for continuity gaps against previous contracts for the same counterparty, adds a row to the contracts register, and reports the next expected contract date.

Creates a new agent end-to-end. Gathers the name, description, icon, tools, and prompt content — then creates the .md file in ~/.claude/agents/, inserts a card into agents.html in alphabetical order, adds the file to structure.html, and confirms. Use this instead of creating agent files manually.

Creates a new customer workspace under Customers\ — including the standard folder structure, CLAUDE.md, and _context\urls-connections.md. Asks for customer name and any known contacts before building.

Creates a new project under an existing customer — including folder structure (_context\, _output\, _temp\, repos\), project CLAUDE.md with DevOps and Fabric details, and URL placeholders in the customer's urls-connections.md. Also updates the customer CLAUDE.md Active Projects list.

First-time repo setup for a project. Asks for the Azure DevOps clone URL, clones it into repos\, and saves the repo name and URL into the project CLAUDE.md under ## Repos. Run once per project — after this, use /clone-repo to refresh.

Creates a new global skill end-to-end. Gathers the name, description, icon, and content — then creates the .md file, inserts the card into skills.html in alphabetical order, adds the file to structure.html, and commits everything together. Use this instead of manually creating skill files.

Finds all _temp\ folders across the Claude workspace, lists their contents, asks for confirmation, then deletes every file one at a time. Safe — never touches folders outside _temp\.

Sets up automated Microsoft Fabric deployment (DEV → UAT → PRD) via Azure DevOps for a given repo. Copies pipeline files, discovers deployment stage IDs, and outputs the complete variable group values needed in Azure DevOps.

Creates a structured handover note for the current session. Prompts for a session name and save location, then compiles what was worked on, what's complete, the next immediate action, open questions, key decisions, and files to read on pickup. Also used automatically by Rule 2 when context is running low.

Updates an existing handover note with the latest progress from the current session. Appends newly completed items, updates the next action, revises remaining work, and updates the summary on the Handovers page. Pass a session name to target a specific handover, or leave blank to update the most recent.

Saves and retrieves plain-text reference information on demand. Three operations: /notes list — show all saved notes; /notes add — save a new note by name; /notes get {name} — retrieve a stored note. Notes are stored at _notes\notes.md and displayed on the Notes page in Compass.

Logs a purchase receipt. Saves the hard copy to _receipts\{Category}\, adds a row to the global receipts index on receipts.html, and optionally links from a source page (e.g. home-entertainment.html). Accepts item, retailer, date, amount, category, and an optional file path.

Takes a screenshot of any URL using the Playwright MCP server. Saves temporarily to _temp\screenshot.png, displays it inline, then deletes the file automatically once done.

Manages the encrypted secrets vault. Three operations: /secrets list — show all stored secret names and descriptions; /secrets add — encrypt a value with AES-256 and store it in the vault; /secrets get {name} — decrypt and return a value (requires password). The password is never stored. Secrets are indexed at _secrets\index.md.