Database Schema Designer

This walks you through schema design from requirements to production-ready SQL or NoSQL. You describe your data model (e-commerce platform, SaaS app, whatever) and get normalized tables, foreign key constraints, indexing strategy, and reversible migrations. The real value is in the opinionated defaults: it indexes foreign keys automatically, enforces 3NF unless you have a reason not to, uses DECIMAL for money instead of FLOAT, and won't let you ship a migration without a rollback plan. The anti-patterns section alone (no VARCHAR(255) everywhere, no dates as strings) is worth keeping open during code review. Best for greenfield projects or when you're refactoring a schema that grew organically and now has orphaned records everywhere.

install copies · 90 days. Times the install command was copied on this site in the last 90 days, bots filtered.: 5
skills.sh installs: 4.4K
GitHub stars: 2.7K
last updated: Aug 21, 2026

View on GitHub

Install

$ npx -y skills add softaworks/agent-toolkit --skill database-schema-designer --agent claude-code

Installs into .claude/skills of the current project.

Files

Database Schema Designer

Design production-ready database schemas with best practices built-in.

Quick Start

Just describe your data model:

design a schema for an e-commerce platform with users, products, orders

You'll get a complete SQL schema like:

CREATE TABLE users (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  email VARCHAR(255) UNIQUE NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

CREATE TABLE orders (
  id BIGINT AUTO_INCREMENT PRIMARY KEY,
  user_id BIGINT NOT NULL REFERENCES users(id),
  total DECIMAL(10,2) NOT NULL,
  INDEX idx_orders_user (user_id)
);

What to include in your request: