SignalPilot

Skills

25 in the Claude listing

• Bigquery sqlBigQuery-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
• Dbt date spinesFix current_date/now() hazards in dbt date spine models.
• Dbt debuggingLoad when dbt run or dbt parse fails.
• Dbt knowledgebasePopulate the knowledge base from dbt project research.
• Dbt snapshotsLoad when task involves dbt snapshots, SCD Type 2, or tracking data changes over time.
• Dbt testingLoad when task involves adding, writing, or fixing dbt unit tests.
• Dbt versioningLoad when task involves dbt model versioning, creating v2 of a model, or backward-compatible model changes.
• Dbt workflowLoad FIRST before any dbt project work.
• Dbt writeLoaded at Step 2 for the full workflow.
• Domain ecommerceE-commerce domain knowledge: transaction lifecycle, driving tables, status filtering.
• Domain financialFinancial reporting rules: grain consistency, balance sheets, double-entry ledgers, fiscal year boundaries, period-over-period calculations.
• Domain healthcareHealthcare data science rules: encounter-based grain, clinical coding hierarchies, cost allocation, NULL semantics in clinical data.
• Domain hrHR & operations rules: SCD current-record filtering, issue resolution metrics.
• Domain marketingMarketing domain knowledge: attribution models, engagement funnel order.
• Domain mediaMedia & entertainment domain knowledge: content catalogs, participation tables, ranking determinism.
• Domain productProduct analytics rules: calendar spine cross-joins, date boundary caps, event type pivoting, first-run NULL behavior.
• Duckdb sqlLoad when hitting DuckDB syntax errors or writing DuckDB-specific SQL.
• Knowledge baseWrite a technical spec after research.
• Notion contextGather business context from Notion before dbt builds.
• signalpilotBLOCKING 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.
• Snowflake sqlSnowflake-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.
• Sql workflowUse this skill before writing any SQL query.
• Sqlite sqlSQLite-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(), COALE
• Write reportGenerates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts.
• xataLoad 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.