Modeler
sidequery/sidemantic
Build, validate, and manage semantic models using Sidemantic.
Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling.
Install Erd Studio Setup
$ npx skills add liam-machine/erd-studio --skill erd-studio-setup -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install liam-machine/erd-studio erd-studio-setup --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/liam-machine/erd-studio.git skills-src && mkdir -p .claude/skills && cp -r skills-src/src/harness/claude/erd-studio-setup .claude/skills/erd-studio-setup && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "erd-studio-setup" agent skill from https://github.com/liam-machine/erd-studio/tree/main/src/harness/claude/erd-studio-setup into .claude/skills/erd-studio-setup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "erd-studio-setup", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/liam-machine/erd-studio/tree/main/src/harness/claude/erd-studio-setupType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add liam-machine/erd-studio --skill erd-studio-setup -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install liam-machine/erd-studio erd-studio-setup --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/liam-machine/erd-studio.git skills-src && mkdir -p .agents/skills && cp -r skills-src/src/harness/claude/erd-studio-setup .agents/skills/erd-studio-setup && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "erd-studio-setup" agent skill from https://github.com/liam-machine/erd-studio/tree/main/src/harness/claude/erd-studio-setup into .agents/skills/erd-studio-setup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "erd-studio-setup", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add liam-machine/erd-studio --skill erd-studio-setup -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install liam-machine/erd-studio erd-studio-setup --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/liam-machine/erd-studio.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/src/harness/claude/erd-studio-setup .cursor/skills/erd-studio-setup && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "erd-studio-setup" agent skill from https://github.com/liam-machine/erd-studio/tree/main/src/harness/claude/erd-studio-setup into .cursor/skills/erd-studio-setup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "erd-studio-setup", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/liam-machine/erd-studio.git --path src/harness/claude/erd-studio-setup--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add liam-machine/erd-studio --skill erd-studio-setup -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install liam-machine/erd-studio erd-studio-setup --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/liam-machine/erd-studio.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/src/harness/claude/erd-studio-setup .gemini/skills/erd-studio-setup && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "erd-studio-setup" agent skill from https://github.com/liam-machine/erd-studio/tree/main/src/harness/claude/erd-studio-setup into .gemini/skills/erd-studio-setup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "erd-studio-setup", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install liam-machine/erd-studio erd-studio-setupInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add liam-machine/erd-studio --skill erd-studio-setup -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/liam-machine/erd-studio.git skills-src && mkdir -p .github/skills && cp -r skills-src/src/harness/claude/erd-studio-setup .github/skills/erd-studio-setup && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "erd-studio-setup" agent skill from https://github.com/liam-machine/erd-studio/tree/main/src/harness/claude/erd-studio-setup into .github/skills/erd-studio-setup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "erd-studio-setup", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add liam-machine/erd-studio --skill erd-studio-setup -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install liam-machine/erd-studio erd-studio-setup --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/liam-machine/erd-studio.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/src/harness/claude/erd-studio-setup .opencode/skills/erd-studio-setup && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "erd-studio-setup" agent skill from https://github.com/liam-machine/erd-studio/tree/main/src/harness/claude/erd-studio-setup into .opencode/skills/erd-studio-setup/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "erd-studio-setup", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
erd-studio-setup- GitHub stars
- 165
- Token cost
- ~8.5k tokens
- SKILL.md length
- 4,924 words
- Files
- 8 (incl. references)
- Skills in repo
- 1
- Repo updated
- First seen
- Licence
- Custom licence
At a glance
Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling.
- Works in 7 steps: Say hello and pick the route → Check dbt → Refresh dbt's project files → …
- The user runs /erd-studio-setup
- SKILL.md covers How to talk, Your AI assistant, The helper tool and Stage 0 — Say hello and pick…, plus 8 more sections
- Calls dbt
What it does
Erd Studio Setup is an agent skill from liam-machine/erd-studio. Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling. By default a quick start: checks the dbt CLI, draws one business area as an ERD Studio logical model that mirrors dbt, checks it with the ERD Studio diff until logical matches physical and opens the canvas within minutes - then offers to detect and apply the team's modelling style (medallion or staging/marts layers; Kimball, Data Vault, One Big Table or Activity Schema tables). Enriches…
Its SKILL.md is about 8.5k tokens, which your agent loads only when the skill is triggered. The skill folder holds 8 other files, including reference files (for example `references/building-the-model.md`, `references/dbt-explained.md` and `references/dbt-setup.md`).
It sits in Data & Analytics, covering Data pipelines and ETL, Database schema design and Diagrams. It works with dbt, Model Context Protocol and Visual Studio Code. The repository describes itself as: Visual ERD designer for dbt — design your data warehouse on a canvas, in your repo, where your AI assistant can read it. Free and open source.
When your agent uses it
- The user runs /erd-studio-setup
- $erd-studio-setup
- Is new to ERD Studio
- Asks to set up ERD Studio
Example prompts
- “set up ERD Studio”
- “create a logical model from my dbt project”
- “model my dbt project the Kimball way”
- “/erd-studio-setup”
Requirements
- Pre-approved tools (allowed-tools): Read, Glob, Grep, WebSearch, WebFetch(domain:www.kimballgroup.com), WebFetch(domain:docs.getdbt.com), WebFetch(domain:datavaultalliance.com), WebFetch(domain:automate-dv.readthedocs.io), WebFetch(domain:activityschema.com), Bash(~/.erd-studio-cli/bin/erd-studio:*), Bash(~/.erd-studio-cli/bin/erd-studio.cmd:*), Bash(dbt --version), Bash(dbt parse:*), Bash(dbt docs generate:*), Bash(dbt compile --write-catalog:*), Bash(dbt debug:*), Bash(dbt deps:*)
Workflow steps
7 steps, taken from the step headings in SKILL.md.
- Say hello and pick the route
- Check dbt
- Refresh dbt's project files
- Choose a business area (and, in a full setup, the modelling style)
- Write the logical model
- Check it against dbt
- Open it in ERD Studio
What it can do on your machine
Read from SKILL.md and the folder at commit c34e12e. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves these tools, so the agent can use them without asking each time:
ReadGlobGrepWebSearchWebFetch(domain:www.kimballgroup.com)WebFetch(domain:docs.getdbt.com)WebFetch(domain:datavaultalliance.com)WebFetch(domain:automate-dv.readthedocs.io)WebFetch(domain:activityschema.com)Bash(~/.erd-studio-cli/bin/erd-studio:*)
…and 7 more on the same allowed-tools line.
From allowed-tools in the SKILL.md frontmatter.
Runs code
Shell commands in SKILL.md call:
dbt
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Erd Studio Setup loads about 8.5k tokens when it runs, and up to ~33k if it reads all its reference files. Until then it costs about 257 tokens; SKILL.md has 4,924 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
Its licence (Custom licence) doesn't allow us to republish the file, so here is its outline and opening line. It has 4,924 words (~8,476 tokens).
“You are walking someone through setting up ERD Studio on a dbt project they already have. Many are new to dbt, data modelling or AI coding assistants. The goal is that they finish with a working diagram and understand what…”
- name
- erd-studio-setup
- allowed-tools
- Read, Glob, Grep, WebSearch, WebFetch(domain:www.kimballgroup.com), WebFetch(domain:docs.getdbt.com), WebFetch(domain:datavaultalliance.com), WebFetch(domain:automate-dv.readthedocs.io), WebFetch(domain:activityschema.com), Bash(~/.erd-studio-cli/bin/erd-studio:*), Bash(~/.erd-studio-cli/bin/erd-studio.cmd:*), Bash(dbt --version), Bash(dbt parse:*), Bash(dbt docs generate:*), Bash(dbt compile --write-catalog:*), Bash(dbt debug:*), Bash(dbt deps:*)
- argument-hint
- [business area, e.g. orders]
Files
SKILL.md and 7 other files (references) in src/harness/claude/erd-studio-setup of liam-machine/erd-studio.
- SKILL.md
- references/building-the-model.md
- references/dbt-explained.md
- references/dbt-setup.md
- references/metadata.md
- references/modelling-approaches.md
- references/troubleshooting.md
- references/verify-and-fix.md
Open the folder on GitHubat commit c34e12e
Compare with similar skills
Erd Studio Setup next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Erd Studio Setup this skillliam-machine/erd-studio | 165 | — | ~8.5k | Automated safety check: Pass | Custom licence | |
| Modelersidequery/sidemantic | 129 | — | ~4.2k | Automated safety check: Pass | Apache-2.0 | |
| Analytics Engineerborghei/Claude-Skills | 874 | — | ~3.4k | Automated safety check: Pass | MIT | |
| Tushare Plugin BuilderYourdaylight/stock_datasource | 188 | — | ~2.5k | Automated safety check: Pass | MIT | |
| dbt Incremental ModelsAltimateAI/data-engineering-skills | 127 | — | ~2.3k | Automated safety check: Pass | MIT | |
| Airflow State Storeastronomer/agents | 450 | — | ~6.1k | Automated safety check: Pass | Apache-2.0 |
Similar skills
Analytics Engineer
borghei/Claude-Skills
Analytics engineering across data modeling, dbt, transformation, and semantic layers.
Tushare Plugin Builder
Yourdaylight/stock_datasource
Turns a Tushare API doc URL into a full data plugin for the stock_datasource repo: extractor, ClickHouse schema, query service, config and curl examples.
dbt Incremental Models
AltimateAI/data-engineering-skills
Helps choose an incremental strategy, design a reliable unique_key and debug failing dbt incremental models, and says when a plain table is the better choice.
Airflow State Store
astronomer/agents
Persists task and asset state across retries and DAG runs using Airflow 3.3's AIP-103 key/value stores (taskstatestore, assetstatestore) and the crash-safe ResumableJobMixin.
- Official
Modeling Revenue Metrics
PostHog/posthog-foss
Build reusable revenue models — MRR, ARR, gross revenue, new/expansion/contraction/churn, ARPU, LTV, and per-customer/per-account revenue — on either PostHog data-warehouse views (HogQL) or an…
Related
Categories
Questions about Erd Studio Setup
What does Erd Studio Setup do?
Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling. Erd Studio Setup is an agent skill from liam-machine/erd-studio. Friendly, step-by-step setup for ERD Studio in an existing dbt project, for people who may be new to dbt or data modelling.
When should I use Erd Studio Setup?
Erd Studio Setup fits situations like: the user runs /erd-studio-setup; $erd-studio-setup; is new to ERD Studio; asks to set up ERD Studio.
How do I install Erd Studio Setup in Claude Code?
Run `npx skills add liam-machine/erd-studio --skill erd-studio-setup -a claude-code`. Or copy the skill folder (src/harness/claude/erd-studio-setup in liam-machine/erd-studio) into .claude/skills/erd-studio-setup in your project. Claude Code loads it when a task matches its description.
How do I install Erd Studio Setup in Codex?
Run `npx skills add liam-machine/erd-studio --skill erd-studio-setup -a codex`. Or copy the skill folder (src/harness/claude/erd-studio-setup in liam-machine/erd-studio) into .agents/skills/erd-studio-setup in your project. Codex loads it when a task matches its description.
Can I use Erd Studio Setup in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add liam-machine/erd-studio --skill erd-studio-setup -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/erd-studio-setup, .gemini/skills/erd-studio-setup, .github/skills/erd-studio-setup and .opencode/skills/erd-studio-setup in your project.
What does Erd Studio Setup need to run?
Going by SKILL.md and its folder, Erd Studio Setup needs the command-line tools its instructions call (dbt). Its frontmatter pre-approves these tools: Read, Glob, Grep, WebSearch, WebFetch(domain:www.kimballgroup.com), WebFetch(domain:docs.getdbt.com), WebFetch(domain:datavaultalliance.com), WebFetch(domain:automate-dv.readthedocs.io), WebFetch(domain:activityschema.com), Bash(~/.erd-studio-cli/bin/erd-studio:*), Bash(~/.erd-studio-cli/bin/erd-studio.cmd:*), Bash(dbt --version), Bash(dbt parse:*), Bash(dbt docs generate:*), Bash(dbt compile --write-catalog:*), Bash(dbt debug:*), Bash(dbt deps:*).
Does Erd Studio Setup access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Erd Studio Setup safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Erd Studio Setup use?
Erd Studio Setup has a licence file (the repository's licence) that doesn't match a standard licence. Read it on GitHub before reusing the skill.
How many tokens does Erd Studio Setup use?
About 8.5k tokens (SKILL.md is roughly 34k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 25k tokens, read only when the agent opens those files.
What are the alternatives to Erd Studio Setup?
Skills that share tags, products or a category with Erd Studio Setup: Modeler (sidequery/sidemantic, 129 stars), Analytics Engineer (borghei/Claude-Skills, 874 stars), Tushare Plugin Builder (Yourdaylight/stock_datasource, 188 stars) and dbt Incremental Models (AltimateAI/data-engineering-skills, 127 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Erd Studio Setup?
liam-machine (a GitHub user) maintains it in liam-machine/erd-studio, which has 165 GitHub stars. The repository was last updated on October 4, 2026.
Source: liam-machine/erd-studio on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.