SignalPilot-Labs

Load when the user asks about Tableau: find, build, copy, edit, redesign, or check a Tableau workbook, dashboard, view, or data source. Covers the tableau_* tools, the .twb builder with its design layer, data sources on SignalPilot connections, the design…

Load before you edit or run notebook cells in chat. Covers the notebook tools, the sp SDK, governed queries, files, and charts.

Load FIRST before any dbt project work. Covers the full 8-step dbt workflow: project scanning, skill loading, validation, macro discovery, research, technical spec, SQL writing, and verification. Also covers output shape inference, incremental model handling,…

Load when the user asks for a dashboard. Covers the dashboard JSON file, SQL datasets, chart types, and the two check tools.

Load before any git or GitHub work in a chat: committing model changes, pushing a branch, opening a pull request, updating a pull request, or commenting on one. Covers the sandbox git checkout, the signalpilot/ branch rule, and the open_pull_request,…

BigQuery-specific SQL patterns: UNNEST for array expansion, STRUCT, ARRAY_AGG, DATE_DIFF/DATE_ADD, backtick-quoted table references, EXCEPT/REPLACE in SELECT, approximate aggregation, partitioned and wildcard tables.

Load when dbt run or dbt parse fails. Covers YML duplicate patches, ref errors, passthrough model warnings, current_date fixes, DuckDB error messages, and zero-row diagnosis.

Load FIRST before any dbt project work. Covers the full 8-step dbt workflow: project scanning, skill loading, validation, macro discovery, research, technical spec, SQL writing, and verification. Also covers output shape inference, incremental model handling,…

BigQuery-specific SQL patterns: UNNEST for array expansion, STRUCT, ARRAY_AGG, DATE_DIFF/DATE_ADD, backtick-quoted table references, EXCEPT/REPLACE in SELECT, approximate aggregation, partitioned and wildcard tables.

Load when dbt run or dbt parse fails. Covers YML duplicate patches, ref errors, passthrough model warnings, current_date fixes, DuckDB error messages, and zero-row diagnosis.

Populate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.

Load FIRST before any dbt project work. Covers the full 8-step dbt workflow: project scanning, skill loading, validation, macro discovery, research, technical spec, SQL writing, and verification. Also covers output shape inference, incremental model handling,…

Loaded at Step 2 for the full workflow. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.

E-commerce domain knowledge: transaction lifecycle, driving tables, status filtering.

Financial reporting rules: grain consistency, balance sheets, double-entry ledgers, fiscal year boundaries, period-over-period calculations.

Media & entertainment domain knowledge: content catalogs, participation tables, ranking determinism.

Load when the user asks about Tableau: find, build, copy, edit, redesign, or check a Tableau workbook, dashboard, view, or data source. Covers the tableau_* tools, the .twb builder with its design layer, data sources on SignalPilot connections, the design…

Load before you read, write, or suggest a change to the team's context folder. Covers the folder layout, every file type and its exact format, the save checks, and how to use context in an answer.

Load when the user asks for a dashboard. Covers the dashboard JSON file, SQL datasets, chart types, and the two check tools.

Load FIRST before any dbt project work. Covers the full 8-step dbt workflow: project scanning, skill loading, validation, macro discovery, research, technical spec, SQL writing, and verification. Also covers output shape inference, incremental model handling,…

Loaded at Step 2 for the full workflow. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, filtering rules, and efficient models.

Load before any git or GitHub work in a chat: committing model changes, pushing a branch, opening a pull request, updating a pull request, or commenting on one. Covers the sandbox git checkout, the signalpilot/ branch rule, and the open_pull_request,…

Load before you write or run an analysis notebook in chat. Covers the notebook file format, run_notebook, the sp SDK, governed queries, files, and charts.

Chat only. Load in the same message as the verifier subagents, after you send the answer. Covers how to decide if this run found a context gap or a dbt gap, and how to file it with the make_recommendations tool.

Populate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.

Load when task involves dbt snapshots, SCD Type 2, or tracking data changes over time. Covers strategy selection, column casing, verification, and common pitfalls.

Load when task involves adding, writing, or fixing dbt unit tests. Covers unit_tests YAML format, given/expect blocks, edge-case coverage, and the difference between unit tests and schema tests.

Load when task involves dbt model versioning, creating v2 of a model, or backward-compatible model changes. Covers versions YAML config, defined_in, latest_version, and ref() with version pins.

Load FIRST before any dbt project work. Covers the full 8-step dbt workflow: project scanning, skill loading, validation, macro discovery, research, technical spec, SQL writing, and verification. Also covers output shape inference, incremental model handling,…

Generates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts. Only load when explicitly requested.

Load when the user asks for a SignalPilot analysis, report, chart, dashboard, or asks to run a SignalPilot agent. Covers the full flow: launch the agent, share the chat link, watch progress, collect the report and artifacts, write a local report.

Load when you need to download the files a SignalPilot agent saved (charts, CSVs, reports, dashboards). Covers list_artifacts, download_artifacts, the single-use POST download, and file checks.

Load when the user asks for a SignalPilot analysis, report, chart, dashboard, or asks to run a SignalPilot agent. Covers the full flow: launch the agent, share the chat link, watch progress, collect the report and artifacts, write a local report.

Load when you need to download the files a SignalPilot agent saved (charts, CSVs, reports, dashboards). Covers list_artifacts, download_artifacts, the single-use POST download, and file checks.

Design system for SignalPilot UI with Soft Violet gradient, Isometric pattern, and brand-native components. Use when building any SignalPilot frontend, UI components, styling, or visual design work.