1. Habit
  2. Skills
  3. Database Schema Designer skill
softaworks · 4K installs

Database Schema Designer skill
Runs by itself, schema or migration change.

Schema changes pass the design checklist.

Install the Database Schema Designer skill and make it a habit: follow https://gethabit.dev/skills/softaworks/database-schema-designer.md

  1. 1Copy
  2. 2Paste into Claude Code, Codex or Cursor
  3. 3It runs by itself

4K installs3K starsMIT licenceSource on GitHub ↗

Database Schema Designer

by softaworks · 4K installs

The skill

Database schema designer designs SQL and NoSQL schemas with normalization, indexing, constraints, relationship patterns and reversible migrations built in.

Only when you ask.

The habit

Schema changes pass the design checklist.

↻ Runs by itselfschema or migration change

How the habit works.
You don't have to.

Three questionsWhen does it start? How does it check its work? What does it remember?

01

It starts by itself

schema or migration change. Runs in GitHub Actions or Claude Code routine.

  • ↻ schema or migration change
  • pull_request paths: migrations/**, schema/**

02

It checks its work

design checklist. If a check fails, it tells you.

  • ✓every table has a primary key
  • ✓every foreign key has a constraint and an index
  • ✓money columns use DECIMAL, not FLOAT
  • ✓every migration has a reversible DOWN step

03

It remembers

schema review log. The next run reads it first: open schema issues and denormalization decisions made before.

loops/schema-review-loop/log.md

One run, step by step.
Then it stops.

Stop ruleStops after the changed tables and migrations of one pull request.

  1. 01

    Analyze

    Identify the entities, relationships and whether the workload is read-heavy or write-heavy.

  2. 02

    Check normalization

    Check the change normalizes to 3NF, or justifies any denormalization for read-heavy access.

  3. 03

    Check keys

    Confirm every table has a primary key and every foreign key has a constraint with an ON DELETE strategy.

  4. 04

    Check types and indexes

    Confirm DECIMAL for money, date types for dates and indexes on foreign keys and queried columns.

  5. 05

    Check migrations

    Confirm each migration has an UP and a DOWN step and adds NOT NULL columns safely.

  6. 06

    Log issues

    Record each checklist miss with its table.

What it may do.
Nothing more.

Safe by defaultIt writes only in its own folder and asks you before anything goes out.

Is it for you?
Use it when it fits.

Quick checkRead both lists. If the left one sounds like you, the Database Schema Designer skill helps.

Use it when

  • ✓ You design a new schema
  • ✓ You add a table or migration
  • ✓ You review a schema for issues

Skip it when

  • – You need query tuning only
  • – You have no database

Questions

Database Schema Designer skill, answered.

Why not use FLOAT for money?

The skill lists FLOAT for money as an anti-pattern because of rounding errors; use DECIMAL.

When should I denormalize?

For read-heavy reporting, expensive JOINs or analytics, with pre-calculated aggregates or materialized views.

How do I install the Database Schema Designer skill?

Copy the prompt at the top into your agent. It installs the skill from softaworks/agent-toolkit and sets up the habit. Or run npx skills add softaworks/agent-toolkit --skill database-schema-designer.

Is the Database Schema Designer skill free?

Yes. It is published under MIT. Habit is free too.

Database Schema Designer. Now as a habit.

Install the Database Schema Designer skill and make it a habit: follow https://gethabit.dev/skills/softaworks/database-schema-designer.md

  • Free
  • No account
  • Undo in one line

All softaworks skills →More code skills →

Works in

  • Claude Code
  • Codex
  • Cursor
  • ChatGPT
  • Claude app

Made by softaworks, published under MIT. Habit links to the original and never changes it. Is this your skill?

Copying didn't work here. Select the line and copy it by hand.