kameshsampath

Guided pedagogical demo of Snowflake Postgres + pg_lake + Cortex AI, demonstrating Intent-Driven Development through a streetlights infrastructure scenario. Use when: "start the streetlights demo", "run the streetlights demo", "show me the streetlights demo", "streetlights infrastructure demo", "demo snowflake postgres with Cortex", "pg_lake demo", "demo Cortex Intelligence with streetlights".

Remove all demo resources (reverse order)

Remove all executor-role-workshop demo objects (roles, database, procedures)

Interactive diagnostic workshop for Snowflake's executor role model. Load when users ask about: stored procedure insufficient privileges, "I have the privilege but it still fails", EXECUTE AS OWNER vs CALLER, INVOKER_ROLE vs CURRENT_ROLE inside objects, task won't resume, EXECUTE TASK grant, dynamic table owner context, masking policy returning wrong role, executor role concept, who is running this query. Trigger phrases: "executor role", "EXECUTE AS", "INVOKER_ROLE", "stored procedure permission", "task won't resume", "masking policy context".

Create a single eval task for a CoCo skill. Generates task.toml, IDD-structured instruction.md, and test.sh with guided prompts. Use when: "create eval task", "new eval", "add task", "write eval for skill", "test my skill", "add evaluation", "create test for skill".

Set up inspect-coco in a project and auto-generate eval tasks from existing CoCo skills/plugins. Reads plugin structure (SKILL.md files) and creates atomic eval tasks with IDD-structured instructions. Use when: "set up inspect-coco", "add inspect evals", "scaffold eval tasks", "create evaluation suite", "add coco eval", "generate evals from skills", "inspect-coco setup", "bootstrap eval tasks from plugin".

Intent-Driven Development pipeline orchestrator. Accepts a vague natural language request and runs the full 5-step IDD pipeline: intent-extraction → architecture-synthesis → code-synthesis → icr-analysis → token-economics. Use when: generate app, build feature, patient risk calculator, IDD demo, run pipeline.