signalpilot-labs
- 34 skills
- 0 followers
- 17 hours ago last updated
- ▌ Dbt Write 2 · signalpilot-labsLoaded at Step 2 for the full workflow. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.
- ▌ Duckdb SQL 2 · signalpilot-labsLoad when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.
- ▌ Sqlite SQL 2 · signalpilot-labsSQLite-specific SQL patterns: substr/instr for string ops, || for concatenation, LIKE (no ILIKE), date()/strftime() for dates, CAST for type coercion, no FULL OUTER JOIN, GROUP_CONCAT, typeof(), COALESCE/IFNULL, printf() formatting.
- ▌ Bigquery SQL 2 · signalpilot-labsBigQuery-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.
- ▌ Dbt Workflow 2 · signalpilot-labs bundleLoad 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, and what to trust in YML.
- ▌ SQL Workflow 2 · signalpilot-labsUse this skill before writing any SQL query. Covers: output shape inference (cardinality clues from the question), efficient schema exploration, iterative CTE-based query building, structured verification loop (row count, NULL audit, fan-out check, sample inspection), error recovery protocol, saving output to result.sql and result.csv, turn budget management, and common query traps.
- ▌ Dbt Debugging 2 · signalpilot-labsLoad 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.
- ▌ Snowflake SQL 2 · signalpilot-labsSnowflake-specific SQL patterns: QUALIFY for window filtering, LATERAL FLATTEN for arrays, semi-structured VARIANT data, ILIKE for case-insensitive matching, date functions, and time travel.
- ▌ Notion Context · signalpilot-labsGather business context from Notion before dbt builds. Searches all configured integrations, extracts definitions/decisions/constraints, writes structured context for the build agent and notion-verify subagent.
- ▌ Domain Hr · signalpilot-labsHR & operations rules: SCD current-record filtering, issue resolution metrics.
- ▌ Dbt Testing · signalpilot-labsLoad 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.
- ▌ Dbt Snapshots · signalpilot-labsLoad when task involves dbt snapshots, SCD Type 2, or tracking data changes over time. Covers strategy selection, column casing, verification, and common pitfalls.
- ▌ Dbt Versioning · signalpilot-labsLoad 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.
- ▌ Domain Product · signalpilot-labsProduct analytics rules: calendar spine cross-joins, date boundary caps, event type pivoting, first-run NULL behavior.
- ▌ Domain Marketing · signalpilot-labsMarketing domain knowledge: attribution models, engagement funnel order.
- ▌ Domain Healthcare · signalpilot-labsHealthcare data science rules: encounter-based grain, clinical coding hierarchies, cost allocation, NULL semantics in clinical data.
- ▌ Dbt Write · signalpilot-labsLoad at Step 4 when writing SQL models. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.
- ▌ Duckdb SQL · signalpilot-labsLoad when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.
- ▌ Sqlite SQL · signalpilot-labsSQLite-specific SQL patterns: substr/instr for string ops, || for concatenation, LIKE (no ILIKE), date()/strftime() for dates, CAST for type coercion, no FULL OUTER JOIN, GROUP_CONCAT, typeof(), COALESCE/IFNULL, printf() formatting.
- ▌ Bigquery SQL · signalpilot-labsBigQuery-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.
- ▌ Dbt Workflow · signalpilot-labsLoad at Step 1 before exploring the project. Covers output shape inference, incremental model handling, and what to trust in YML.
- ▌ SQL Workflow · signalpilot-labsUse this skill before writing any SQL query. Covers: output shape inference (cardinality clues from the question), efficient schema exploration, iterative CTE-based query building, structured verification loop (row count, NULL audit, fan-out check, sample inspection), error recovery protocol, saving output to result.sql and result.csv, turn budget management, and common benchmark traps.
- ▌ Dbt Debugging · signalpilot-labsLoad 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.
- ▌ Snowflake SQL · signalpilot-labsSnowflake-specific SQL patterns: QUALIFY for window filtering, LATERAL FLATTEN for arrays, semi-structured VARIANT data, ILIKE for case-insensitive matching, date functions, and time travel.
- ▌ Xata · signalpilot-labsLoad when working with Xata Postgres branches: forking a branch, building or testing dbt models on a branch, wiring dbt to a branch's credentials, diffing two branches, or the pre-merge impact report. Covers create_xata_branch, delete_xata_branch, get_dbt_profile, xata_branch_diff, schema_diff_branches, and pgroll migrations.
- ▌
- ▌
- ▌ Domain Media · signalpilot-labsMedia & entertainment domain knowledge: content catalogs and participation tables.
- ▌ Write Report · signalpilot-labsGenerates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts. Only load when explicitly requested.
- ▌ Knowledge Base · signalpilot-labsWrite a technical spec after research. Distills exploration into structured decisions. On retries, read the existing spec instead of re-researching.
- ▌ Domain Ecommerce · signalpilot-labsE-commerce domain knowledge: transaction lifecycle, driving tables, status filtering.
- ▌ Domain Financial · signalpilot-labsFinancial reporting rules: grain consistency, balance sheets, double-entry ledgers, fiscal year boundaries, period-over-period calculations.
- ▌ Dbt Knowledgebase · signalpilot-labsPopulate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.
- ▌ Dashboard Authoring · signalpilot-labsCreate, repair, or refine governed SignalPilot dashboards through the run-scoped authoring tools. Use only for explicit dashboard authoring requests, not ordinary analytics questions, chart answers, or HTML reports.