Claude Skills by SignalPilot-Labs

github.com/SignalPilot-Labs

40 skillsA× 39B× 10 installs77 views

Bigquery SqlABigQuery-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.databasespythonsqlVotes: 0GitHub stars: 485
Dbt Date SpinesA- `dbt_project_map` reports "WARNING: Models use current_date" - `dbt run` produces far more rows than expected in a date-spine modelresearchsqlVotes: 0GitHub stars: 485
Dbt DebuggingALoad 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.code-qualitysqlnodeVotes: 0GitHub stars: 485
Dbt WorkflowALoad at Step 1 before exploring the project. Covers Notion context gathering, output shape inference, incremental model handling, and what to trust in YML.businessrustgoVotes: 0GitHub stars: 485
Dbt WriteALoad at Step 4 when writing SQL models. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.businessgosqlVotes: 0GitHub stars: 485
Duckdb SqlALoad when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.databasesgosqlVotes: 0GitHub stars: 485
Snowflake SqlASnowflake-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.code-qualitygosqlVotes: 0GitHub stars: 485
Sql WorkflowAUse 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.businessgosqlVotes: 0GitHub stars: 485
Sqlite SqlASQLite-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.databasesgosqlVotes: 0GitHub stars: 485
Bigquery SqlABigQuery-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.databasessqlVotes: 0GitHub stars: 485
Dbt DebuggingALoad 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.code-qualitysqldebuggingVotes: 0GitHub stars: 485
Dbt KnowledgebaseAPopulate the knowledge base from dbt project research. Proposes entries across all 6 categories at org, project, and connection scopes.businesspythonrustVotes: 0GitHub stars: 485
Dbt SnapshotsALoad when task involves dbt snapshots, SCD Type 2, or tracking data changes over time. Covers strategy selection, column casing, verification, and common pitfalls.testinggobashVotes: 0GitHub stars: 485
Dbt TestingALoad 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.testinggobashVotes: 0GitHub stars: 485
Dbt VersioningALoad 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.testingbashsqlVotes: 0GitHub stars: 485
Dbt WorkflowALoad 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.testingpythonrustVotes: 0GitHub stars: 485
Dbt WriteALoaded at Step 2 for the full workflow. Covers column naming, type preservation, JOIN defaults, lookup joins, sibling models, materialization, packages, and filtering rules.businessgosqlVotes: 0GitHub stars: 485
Domain EcommerceAE-commerce domain knowledge: transaction lifecycle, driving tables, status filtering.businessgoVotes: 0GitHub stars: 485
Domain FinancialAFinancial reporting rules: grain consistency, balance sheets, double-entry ledgers, fiscal year boundaries, period-over-period calculations.databasesVotes: 0GitHub stars: 485
Domain HealthcareAHealthcare data science rules: encounter-based grain, clinical coding hierarchies, cost allocation, NULL semantics in clinical data.devopsgodocumentationVotes: 0GitHub stars: 485
Domain HrAHR & operations rules: SCD current-record filtering, issue resolution metrics.businessVotes: 0GitHub stars: 485
Domain MarketingAMarketing domain knowledge: attribution models, engagement funnel order.content-marketingapiVotes: 0GitHub stars: 485
Domain MediaAMedia & entertainment domain knowledge: content catalogs and participation tables.content-marketingVotes: 0GitHub stars: 485
Domain ProductAProduct analytics rules: calendar spine cross-joins, date boundary caps, event type pivoting, first-run NULL behavior.dataVotes: 0GitHub stars: 485
Duckdb SqlALoad when hitting DuckDB syntax errors or writing DuckDB-specific SQL. Covers gotchas that differ from PostgreSQL/MySQL.databasesgosqlVotes: 0GitHub stars: 485
Knowledge BaseAWrite a technical spec after research. Distills exploration into structured decisions. On retries, read the existing spec instead of re-researching.researchgosqlVotes: 0GitHub stars: 485
SignalpilotASignalPilot MCP tool catalog for governed database access.databasesgosqlVotes: 0GitHub stars: 485
Snowflake SqlASnowflake-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.code-qualitygosqlVotes: 0GitHub stars: 485
Sql WorkflowAUse 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.businessgosqlVotes: 0GitHub stars: 485
Sqlite SqlASQLite-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.databasesgosqlVotes: 0GitHub stars: 485
Write ReportAGenerates an HTML report summarizing dbt project work: decisions, SQL, queries, verifier results, and visual charts. Only load when explicitly requested.researchjavascriptgoVotes: 0GitHub stars: 485
XataALoad 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.databasesgoshellVotes: 0GitHub stars: 485
Dbt WorkflowALoad 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.testingpythonrustVotes: 0GitHub stars: 485
DashboardALoad when the user asks for a dashboard. Covers the dashboard JSON file, SQL datasets, chart types, and the two check tools.businesspythongoVotes: 0GitHub stars: 485
GithubALoad 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, update_pull_request, and comment_on_pull_request tools.code-qualitygogitVotes: 0GitHub stars: 485
NotebookALoad before you edit or run notebook cells in chat. Covers the notebook tools, the sp SDK, governed queries, files, and charts.datapythongoVotes: 0GitHub stars: 485
TableauALoad 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 standard, and the render review.datapythongoVotes: 0GitHub stars: 485
Env SetupBUse when setting up a project environment — installing dependencies, verifying builds, detecting the tech stack. Covers Phase 0 of a new session.devopspythonrustVotes: 0GitHub stars: 101
Git WorkflowAUse when committing code, pushing branches, writing .gitignore entries, or generating PR metadata. Covers commit format, branch rules, and artifact exclusion.code-qualitysqlnodeVotes: 0GitHub stars: 101
Self ImprovementAUse when updating project documentation, saving learnings, or running retrospectives. Covers CLAUDE.md updates, memory persistence, and cross-session learning.documentationgodockerVotes: 0GitHub stars: 101