Ready to supercharge your AI agents?

Install any skill in seconds. Free to start, no credit card required.

Schema Design Skill · butterbase-ai | DecimalAI

databy butterbase-ai

Schema Design Skill

butterbase-ai/schema-design

Source butterbase-ai/butterbase-skills ↗License MIT

Use when designing database schemas, creating or modifying tables, choosing column types, adding indexes, or working with the Butterbase declarative schema DSL

SkillScore95Maintained

Automatic

Data Engineer pack

Last verified 8/18/2026

What it changes

Passed 21 of 22 test cases with the skill, and 12 of 22 without it.

Without skill55%

With skill95%

Checks it passed that the model alone missed

Invokes manage_schema tool
Sets action parameter to get
Specifies column type as text

and 9 more in the full report

9 fixed12 passed either way1 still failing0 broke

Pass-rate lift: +41 pp
Tokens: +430%
Agent turns: 0%
Response time: -32%

Model gemini-3.6-flashMeasured 8/18/2026v121 of 22 cases passed with skill

Tokens, turns and time describe resource use, not a dollar price.

Use this skill

Save it into your project's skills folder. Claude Code picks it up in its next session.

curl -fsSL --create-dirs -o .claude/skills/butterbase-ai-schema-design/SKILL.md https://app.decimal.ai/s/butterbase-ai-schema-design/SKILL.md

Want it pinned and updatable? pip install "decimalai>=0.15", then decimalai skills add butterbase-ai-schema-design, and start Claude Code with claude --plugin-dir "$(git rev-parse --show-toplevel)/.agents"

1 · One-time — install the CLI (docs ↗)

pip install "decimalai>=0.15"

2 · Get the skill — writes .agents/skills/butterbase-ai-schema-design/ and pins it in .decimal/skills.lock

decimalai skills add butterbase-ai-schema-design

No CLI? Get the same file — curl · raw file

curl -fsSL --create-dirs -o .claude/skills/butterbase-ai-schema-design/SKILL.md https://app.decimal.ai/s/butterbase-ai-schema-design/SKILL.md

Raw file: /s/butterbase-ai-schema-design/SKILL.md ↗ · machine-readable summary at /s/butterbase-ai-schema-design.json ↗

Safety checks: 3 of 3 passed

Code scan CleanIntent PassedContent Clean

See it in action

One of 9 test cases the skill fixed. Same model, same prompt, with and without the skill.

1 of 9

Prompt

Construct the tool call request to retrieve the current active database schema definition for application `app_11092`.

What was checked, without and with the skill
Checked	Without skill	With skill
Sets action parameter to get	Missed	Passed
Invokes manage_schema tool	Missed	Passed

case-15 · gemini-3.6-flash · 8/18/2026 · answers are capped and redacted

What's inside

The instructions your model reads when the skill loads.

SKILL.md546 linessingle file

Schema Design Skill

Reference guide for Butterbase's declarative schema DSL. Covers column types, constraints, indexes, and common data modeling patterns.

1. Overview

Butterbase uses a declarative schema DSL — you describe the desired end state of your database, and the platform computes and applies the diff. You never write raw ALTER TABLE or CREATE TABLE SQL. Instead, call manage_schema with action: "apply" and a JSON payload describing your tables, columns, and indexes.

The single manage_schema tool exposes four actions:

Action	Purpose
`"get"`	Read the current schema
`"dry_run"`	Preview SQL that `apply` would execute, without running it
`"apply"`	Apply a declarative schema (diffs against current, runs safe DDL)
`"list_migrations"`	List applied migrations, most recent first

Key principles:

Idempotent: applying the same schema twice is safe — returns "Schema is up to date" if no changes needed
Additive by default: new columns and tables are created automatically
Explicit drops: destructive operations require opt-in via _drop / _dropColumns
Preview first: use action: "dry_run" to see what will change before committing
Transactional: each migration runs in a single transaction — all changes commit or all roll back

2. Column Types Reference

Type	PostgreSQL	Use case
`uuid`	UUID	Primary keys, foreign keys
`text`	TEXT	Strings of any length
`integer`	INTEGER	Whole numbers (-2B to 2B)
`bigint`	BIGINT	Large whole numbers
`boolean`	BOOLEAN	True/false flags
`timestamptz`	TIMESTAMPTZ	Dates with timezone
`jsonb`	JSONB	Structured/semi-structured data
`real`	REAL	32-bit floating point

Track record

Benchmark

21 / 22

test cases passed, vs 12 / 22 without

Adoption

Users: 0
Times used: 0

Safety and source details

SkillSafety

✓ 3 of 3 passed

Code scan15 of 15 checks clean

0 critical · 0 warning · 0 info — scanner v4 — 8/3/2026

View 15 scanner checks

live_secretremote_code_executionreverse_shelldata_exfiltrationssrf_metadataagent_snoopinganti_refusaldestructive_commandsobfuscated_unicodeunicode_homoglyphopaque_blobsuspicious_urltool_overreachtrigger_abuseprompt_injection_phrasing

IntentSafe

LLM judge · does the skill do what it claims

ContentClean

LLM judge · policy & harmful-content review

Source

Imported

butterbase-ai / butterbase-skills

skills/schema-design/SKILL.md

View on GitHub ↗

License MITImported 8/3/2026Version v1

More skills from the same source and nearby in the registry, with their headline benchmark lift.

Ready to supercharge your AI agents?

See it in action

What's inside

Schema Design Skill

1. Overview

2. Column Types Reference

Track record

Benchmark

Adoption

SkillSafety

Source

Related skills