all publishers

signalpilot-labs

@signalpilot-labs source repo

71 published skills

  1. ▌
    Dbt Knowledgebase 4 · signalpilot-labs
    Populate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.
    489 repo stars
  2. ▌
    Write Report 4 · signalpilot-labs
    Generates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts. Only load when explicitly requested.
    489 repo stars
  3. ▌
    Dbt Workflow 5 · signalpilot-labs bundle
    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, and what to trust in YML.
    489 repo stars
  4. ▌
    Dbt Testing 3 · signalpilot-labs
    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.
    489 repo stars
  5. ▌
    Dbt Snapshots 3 · signalpilot-labs
    Load when task involves dbt snapshots, SCD Type 2, or tracking data changes over time. Covers strategy selection, column casing, verification, and common pitfalls.
    489 repo stars
  6. ▌
    Dbt Versioning 3 · signalpilot-labs
    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.
    489 repo stars
  7. ▌
    Xata 3 · signalpilot-labs
    Load when working with Xata Postgres branches: connecting to a branch, diffing two branches, or checking whether an upstream branch's schema change breaks a dbt project or pipeline before it merges. Covers branch connections, schema_diff_branches, pgroll migrations, and the pre-merge impact report.
    489 repo stars
  8. ▌
    Dbt Write 4 · signalpilot-labs
    Loaded at Step 2 for the full workflow. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.
    489 repo stars
  9. ▌
    Signalpilot 3 · signalpilot-labs
    BLOCKING REQUIREMENT: If the user's message mentions dbt, SQL, database, or data pipeline — invoke this skill as your FIRST tool call, BEFORE Read, Glob, Grep, Bash, or Agent. Covers: SignalPilot MCP tools, available skills, and the governed workflow for dbt projects, SQL queries, schema discovery, and database access.
    489 repo stars
  10. ▌
    Bigquery SQL 4 · signalpilot-labs
    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.
    489 repo stars
  11. ▌
    Dbt Workflow 4 · signalpilot-labs bundle
    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, and what to trust in YML.
    489 repo stars
  12. ▌
    Write Report 3 · signalpilot-labs
    Generates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts. Only load when explicitly requested.
    489 repo stars
  13. ▌
    Dbt Date Spines 2 · signalpilot-labs
    Fix current_date/now() hazards in dbt date spine models. Replaces nondeterministic date references with data-driven boundaries from get_date_boundaries.
    489 repo stars
  14. ▌
    Dbt Knowledgebase 3 · signalpilot-labs
    Populate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.
    489 repo stars
  15. ▌
    Dbt Testing 2 · signalpilot-labs
    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.
    489 repo stars
  16. ▌
    Dbt Snapshots 2 · signalpilot-labs
    Load when task involves dbt snapshots, SCD Type 2, or tracking data changes over time. Covers strategy selection, column casing, verification, and common pitfalls.
    489 repo stars
  17. ▌
    Dbt Versioning 2 · signalpilot-labs
    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.
    489 repo stars
  18. ▌
    Dbt Write 3 · signalpilot-labs
    Loaded at Step 2 for the full workflow. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.
    489 repo stars
  19. ▌
    Domain Hr 2 · signalpilot-labs
    HR & operations rules: SCD current-record filtering, issue resolution metrics.
    489 repo stars
  20. ▌
    Duckdb SQL 3 · signalpilot-labs
    Load when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.
    489 repo stars
  21. ▌
    Sqlite SQL 3 · signalpilot-labs
    SQLite-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.
    489 repo stars
  22. ▌
    Signalpilot 2 · signalpilot-labs
    BLOCKING REQUIREMENT: If the user's message mentions dbt, SQL, database, or data pipeline - invoke this skill as your FIRST tool call, BEFORE Read, Glob, Grep, Bash, or Agent. Covers: SignalPilot MCP tools, available skills, and the governed workflow for dbt projects, SQL queries, schema discovery, and database access.
    489 repo stars
  23. ▌
    Bigquery SQL 3 · signalpilot-labs
    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.
    489 repo stars
  24. ▌
    Domain Media 2 · signalpilot-labs
    Media & entertainment domain knowledge: content catalogs, participation tables, ranking determinism.
    489 repo stars
  25. ▌
    SQL Workflow 3 · signalpilot-labs
    Use 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.
    489 repo stars
  26. ▌
    Dbt Debugging 3 · signalpilot-labs
    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.
    489 repo stars
  27. ▌
    Snowflake SQL 3 · signalpilot-labs
    Snowflake-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.
    489 repo stars
  28. ▌
    Domain Product 2 · signalpilot-labs
    Product analytics rules: calendar spine cross-joins, date boundary caps, event type pivoting, first-run NULL behavior.
    489 repo stars
  29. ▌
    Knowledge Base 2 · signalpilot-labs
    Write a technical spec after research. Distills exploration into structured decisions. On retries, read the existing spec instead of re-researching.
    489 repo stars
  30. ▌
    Domain Ecommerce 2 · signalpilot-labs
    E-commerce domain knowledge: transaction lifecycle, driving tables, status filtering.
    489 repo stars
  31. ▌
    Domain Financial 2 · signalpilot-labs
    Financial reporting rules: grain consistency, balance sheets, double-entry ledgers, fiscal year boundaries, period-over-period calculations.
    489 repo stars
  32. ▌
    Domain Marketing 2 · signalpilot-labs
    Marketing domain knowledge: attribution models, engagement funnel order.
    489 repo stars
  33. ▌
    Domain Healthcare 2 · signalpilot-labs
    Healthcare data science rules: encounter-based grain, clinical coding hierarchies, cost allocation, NULL semantics in clinical data.
    489 repo stars
  34. ▌
    Xata 2 · signalpilot-labs
    Load 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.
    489 repo stars
  35. ▌
    Dbt Workflow 3 · signalpilot-labs bundle
    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, and what to trust in YML.
    489 repo stars
  36. ▌
    Write Report 2 · signalpilot-labs
    Generates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts. Only load when explicitly requested.
    489 repo stars
  37. ▌
    Dbt Knowledgebase 2 · signalpilot-labs
    Populate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.
    489 repo stars
  38. ▌
    Dbt Write 2 · signalpilot-labs
    Loaded at Step 2 for the full workflow. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.
    489 repo stars
  39. ▌
    Duckdb SQL 2 · signalpilot-labs
    Load when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.
    489 repo stars
  40. ▌
    Sqlite SQL 2 · signalpilot-labs
    SQLite-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.
    489 repo stars
  41. ▌
    Bigquery SQL 2 · signalpilot-labs
    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.
    489 repo stars
  42. ▌
    Dbt Workflow 2 · signalpilot-labs bundle
    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, and what to trust in YML.
    489 repo stars
  43. ▌
    SQL Workflow 2 · signalpilot-labs
    Use 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.
    489 repo stars
  44. ▌
    Dbt Debugging 2 · signalpilot-labs
    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.
    489 repo stars
  45. ▌
    Snowflake SQL 2 · signalpilot-labs
    Snowflake-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.
    489 repo stars
  46. ▌
    Notion Context · signalpilot-labs
    Gather 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.
    489 repo stars
  47. ▌
    Domain Hr · signalpilot-labs
    HR & operations rules: SCD current-record filtering, issue resolution metrics.
    489 repo stars
  48. ▌
    Dbt Testing · signalpilot-labs
    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.
    489 repo stars
  49. ▌
    Dbt Snapshots · signalpilot-labs
    Load when task involves dbt snapshots, SCD Type 2, or tracking data changes over time. Covers strategy selection, column casing, verification, and common pitfalls.
    489 repo stars
  50. ▌
    Dbt Versioning · signalpilot-labs
    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.
    489 repo stars
  51. ▌
    Domain Product · signalpilot-labs
    Product analytics rules: calendar spine cross-joins, date boundary caps, event type pivoting, first-run NULL behavior.
    489 repo stars
  52. ▌
    Domain Marketing · signalpilot-labs
    Marketing domain knowledge: attribution models, engagement funnel order.
    489 repo stars
  53. ▌
    Domain Healthcare · signalpilot-labs
    Healthcare data science rules: encounter-based grain, clinical coding hierarchies, cost allocation, NULL semantics in clinical data.
    489 repo stars
  54. ▌
    Dbt Write · signalpilot-labs
    Load at Step 4 when writing SQL models. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.
    489 repo stars
  55. ▌
    Duckdb SQL · signalpilot-labs
    Load when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.
    489 repo stars
  56. ▌
    Sqlite SQL · signalpilot-labs
    SQLite-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.
    489 repo stars
  57. ▌
    Bigquery SQL · signalpilot-labs
    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.
    489 repo stars
  58. ▌
    Dbt Workflow · signalpilot-labs bundle
    Load at Step 1 before exploring the project. Covers output shape inference, incremental model handling, and what to trust in YML.
    489 repo stars
  59. ▌
    SQL Workflow · signalpilot-labs
    Use 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.
    489 repo stars
  60. ▌
    Dbt Debugging · signalpilot-labs
    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.
    489 repo stars
  61. ▌
    Snowflake SQL · signalpilot-labs
    Snowflake-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.
    489 repo stars
  62. ▌
    Xata · signalpilot-labs
    Load 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.
    489 repo stars
  63. ▌
    Dbt Date Spines · signalpilot-labs
    dbt Date Spine Hazard — Fixing current_date in Model Files
    489 repo stars
  64. ▌
    Signalpilot · signalpilot-labs
    SignalPilot MCP tool catalog for governed database access.
    489 repo stars
  65. ▌
    Domain Media · signalpilot-labs
    Media & entertainment domain knowledge: content catalogs and participation tables.
    489 repo stars
  66. ▌
    Write Report · signalpilot-labs
    Generates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts. Only load when explicitly requested.
    489 repo stars
  67. ▌
    Knowledge Base · signalpilot-labs
    Write a technical spec after research. Distills exploration into structured decisions. On retries, read the existing spec instead of re-researching.
    489 repo stars
  68. ▌
    Domain Ecommerce · signalpilot-labs
    E-commerce domain knowledge: transaction lifecycle, driving tables, status filtering.
    489 repo stars
  69. ▌
    Domain Financial · signalpilot-labs
    Financial reporting rules: grain consistency, balance sheets, double-entry ledgers, fiscal year boundaries, period-over-period calculations.
    489 repo stars
  70. ▌
    Dbt Knowledgebase · signalpilot-labs
    Populate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.
    489 repo stars
  71. ▌
    Dashboard Authoring · signalpilot-labs
    Create, 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.
    489 repo stars