SignalPilot

Skills (25)

• Skill bigquery-sql

  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…

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill bigquery-sql

• Skill dbt-date-spines

  Fix current_date/now() hazards in dbt date spine models. Replaces nondeterministic date references with data-driven boundaries from get_date_boundaries.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill dbt-date-spines

• Skill dbt-debugging

  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.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill dbt-debugging

• Skill dbt-knowledgebase

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

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill dbt-knowledgebase

• Skill dbt-snapshots

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

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill dbt-snapshots

• Skill dbt-testing

  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.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill dbt-testing

• Skill dbt-versioning

  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.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill dbt-versioning

• Skill dbt-workflow

  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.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill dbt-workflow

• Skill dbt-write

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

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill dbt-write

• Skill domain-ecommerce

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

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill domain-ecommerce

• Skill domain-financial

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

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill domain-financial

• Skill domain-healthcare

  Healthcare data science rules: encounter-based grain, clinical coding hierarchies, cost allocation, NULL semantics in clinical data.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill domain-healthcare

• Skill domain-hr

  HR & operations rules: SCD current-record filtering, issue resolution metrics.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill domain-hr

• Skill domain-marketing

  Marketing domain knowledge: attribution models, engagement funnel order.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill domain-marketing

• Skill domain-media

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

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill domain-media

• Skill domain-product

  Product analytics rules: calendar spine cross-joins, date boundary caps, event type pivoting, first-run NULL behavior.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill domain-product

• Skill duckdb-sql

  Load when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill duckdb-sql

• Skill knowledge-base

  Write a technical spec after research. Distills exploration into structured decisions. On retries, read the existing spec instead of re-researching.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill knowledge-base

• Skill notion-context

  Gather business context from Notion before dbt builds. Searches all configured integrations, extracts definitions/decisions/constraints, writes structured context for the build agent and…

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill notion-context

• Skill signalpilot

  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.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill signalpilot

• Skill snowflake-sql

  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.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill snowflake-sql

• Skill sql-workflow

  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…

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill sql-workflow

• Skill sqlite-sql

  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()…

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill sqlite-sql

• Skill write-report

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

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill write-report

• Skill xata

  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.

  Any agent

  npx skills add signalpilot-labs/signalpilot-plugin --skill xata

Agents (3)

• Agent notion-verify

  Post-build verification and traceability report. Checks that Notion context was correctly applied to SQL, writes a governed report to Notion via SignalPilot.

• Agent value-verifier

  Value verification: call verify_model_values MCP tool, then reason about column name vs aggregation alignment. Read-only - returns report only.

• Agent verifier

  Structure verification: table existence, column completeness via map_columns, row counts, fan-out, cardinality. Read-only - returns report only.

From Anthropic's public plugin directory, read on 2026-10-15. Find a skill by task.