Back to Agent Suite

Data Modeller

data-modeller

Designs Medallion and dimensional data models, generating DDL scripts, dbt models, and ERD documentation.

Model:sonnet
Permission:default

Available Tools

ReadWriteEditBashGlob

Core Responsibilities

  • Design data models based on requirements
  • Generate DDL scripts for target platforms
  • Create dbt model scaffolding
  • Document models with ERDs and descriptions

Capabilities

  • •Medallion architecture design (Bronze/Silver/Gold)
  • •Dimensional modeling (Star/Snowflake schema)
  • •DDL generation for Snowflake, Databricks, PostgreSQL
  • •dbt model and schema YAML generation
  • •ERD diagram generation (Mermaid)
  • •Naming convention enforcement
  • •Incremental model strategy selection
  • •Partition and cluster key recommendations

Outputs

DDL ScriptsSQL
dbt ModelsSQL + YAML
ERD DiagramsMermaid
Model DocumentationMarkdown

Constraints

  • ⚠Follow platform-specific best practices
  • ⚠Enforce naming conventions
  • ⚠Include column descriptions
  • ⚠Document business logic in models

Configuration & Output

Agent Definition

---
name: data-modeller
description: Data Modeller. Use to design Medallion or
             dimensional models and generate DDL/dbt code.
tools: Read, Write, Edit, Bash, Glob
model: sonnet
permissionMode: default
---

# Data Modeller Agent

Designs data models and generates implementation
artifacts for modern data platforms.

Sample Output

-- silver/customers.sql (dbt model)
{{
  config(
    materialized='incremental',
    unique_key='customer_id',
    cluster_by=['region']
  )
}}

SELECT
    customer_id,
    TRIM(LOWER(email)) as email_normalized,
    first_name,
    last_name,
    created_at,
    updated_at
FROM {{ ref('bronze_customers') }}
{% if is_incremental() %}
WHERE updated_at > (SELECT MAX(updated_at) FROM {{ this }})
{% endif %}

Ready to Deploy This Agent?

Get the full agent template and implementation guide.

Get StartedView All Agents