Skip to content
TrustedSkillsbeta
Back to all skills

Dbt Test Creator

Listed
jeremylongshore·vlatest·data·MIT

Automatically generates dbt test code based on your model descriptions, improving data quality and reliability.

Repository

Install on your platform

Showing Claude Code. One command installs this skill into any of the agents below.

  1. 1

    Run this in your project

    terminal
    $ npx skills add jeremylongshore/tons-of-skills-marketplace --skill dbt-test-creator -a claude-code

  2. Uses the open-source skills CLI and needs Node.js. Add -g to install it for your user instead of this project.

What we know about this skill

Publisher

jeremylongshore

Taken from the source listing. We haven't verified who controls this account.

Install target

Live repository

Not pinned. Installing fetches whatever the repository holds at the time you run the command.

Nobody has reviewed this code. TrustedSkills indexes and links skills; it does not audit, run or scan them. A skill runs with whatever access you give your agent — read the source before you install it.

Automated safety checks

scanned

We could not read this skill's source, so none of the checks below were run.

Not scanned. none of the 396 skills in the repository match this slug — it was most likely renamed or removed upstream after the registry indexed it Source recorded as jeremylongshore/claude-code-plugins-plus-skills.
This is a static scan, not a review. It reads the skill's files; it does not run them, and it cannot tell you whether the skill is any good or whether the code does what its description says. A skill runs with whatever access you give your agent.
What each check looks for →

About this skill

What it does

This skill automatically generates dbt (data build tool) tests based on your data model definitions. It analyzes the structure of your models and creates corresponding test configurations to ensure data quality and consistency within your data warehouse. The generated tests cover aspects like uniqueness, not null constraints, and relationships between tables.

When to use it

  • New dbt projects: Quickly establish a baseline for testing when setting up a new dbt project.
  • Expanding existing models: Automate test creation as you add or modify data models in your existing dbt workflow.
  • Ensuring data quality: Proactively identify and prevent data errors by automatically enforcing constraints through generated tests.
  • Reducing manual effort: Eliminate the repetitive task of manually writing dbt tests for each model.

Key capabilities

  • Generates dbt test configurations.
  • Analyzes data model structures.
  • Creates tests for uniqueness, not null constraints, and relationships.
  • Automates test creation process.

Example prompts

  • "Create dbt tests for my 'customers' model."
  • "Generate tests based on the schema of my 'orders' table in dbt."
  • "Can you create a uniqueness test for the 'customer_id' column in my 'transactions' model?"

Tips & gotchas

  • Requires access to your dbt project and data models.
  • The generated tests may need adjustments based on specific business logic or edge cases not captured by the schema alone.