Diagnose and perform analytics engineering tasks for dbt projects.
npx skills add https://github.com/pkoka888/server-infra-templates --skill dbt-pkoka888
Please help me install this Agent Skill. Skill: dbt Source: https://github.com/pkoka888/server-infra-templates/tree/main/.kilo/skills/marketplace/dbt Command: npx skills add https://github.com/pkoka888/server-infra-templates --skill dbt-pkoka888
Provides concise, actionable guidance and operational instructions for analytics engineering workflows with dbt so teams can build, test, validate, and troubleshoot data transformations reliably.
Ask the dbt skill to build and test the model named "orders" and return a summary of run_results.json with any failing nodes and suggested remediation steps.
High-intent search queries and answers about installing and using this skill.
To write dbt unit tests, you create YAML test definitions with input fixtures and expected outputs, then run them via the dbt CLI to validate transformations and prevent regressions before deployment.
Querying the dbt semantic layer involves authoring and validating semantic models and metrics YAML specs for MetricFlow, then executing dbt CLI commands to retrieve metric values directly from your transformed data.
Troubleshooting failed dbt Cloud runs requires fetching LLM-friendly dbt docs, parsing run_results.json to identify failing nodes, and applying targeted remediation steps to fix the broken data transformations.
Yes, analytics engineering workflows with dbt apply to dbt Core, dbt Fusion, and dbt Cloud, supporting model authoring, unit testing, semantic layer validation, and CLI command execution across all environments.
Format dbt CLI commands by applying safe execution flags, targeting specific models by name, and analyzing run_results.json output to verify successful builds and identify any failing nodes for remediation.
Configuring a dbt MCP server enables LLM-friendly access to dbt docs and semantic layer metadata, allowing automated analytics engineering tools to query metrics, validate specs, and diagnose job failures programmatically.
nrakowSequence six foundational skills to scaffold a complete dbt analytics project.
shaprisAutomate dbt model building, unit tests, semantic layer YAML, and job failure diagnosis.
kyle-chalmersRetrieve and search dbt documentation pages in LLM-friendly markdown format.
Datus-aiMine historical SQL execution data to extract column usage patterns and join relationships.
