Skip to main content

SignalPilot-Labs/codex-signalpilot-plugin

最近记录的来源活动
SkillsMP 收录数据更新
已收集 skills
15
GitHub 星标
0
GitHub Forks
0

用 AI 助手安装

复制这段 Prompt,发给你正在使用的 AI 助手。

正在加载仓库 README…

这个仓库中的 skills

1 个职业分类 · 已分类 40%

已展示 15 / 15 个已收集 Skill。

职业分类
软件开发工程师
描述

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.

原文语言:英语

更新
职业分类
未分类
描述

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.

原文语言:英语

更新
职业分类
软件开发工程师
描述

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

原文语言:英语

更新
职业分类
软件开发工程师
描述

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,…

原文语言:英语

更新
职业分类
软件开发工程师
描述

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

原文语言:英语

更新
职业分类
未分类
描述

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

原文语言:英语

更新
职业分类
未分类
描述

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

原文语言:英语

更新
职业分类
未分类
描述

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

原文语言:英语

更新
职业分类
未分类
描述

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

原文语言:英语

更新
职业分类
未分类
描述

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

原文语言:英语

更新
职业分类
软件开发工程师
描述

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…

原文语言:英语

更新
职业分类
未分类
描述

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.

原文语言:英语

更新
职业分类
未分类
描述

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…

原文语言:英语

更新
职业分类
未分类
描述

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.

原文语言:英语

更新
职业分类
软件开发工程师
描述

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

原文语言:英语

更新
已展示 15 / 15 个已收集 Skill。