db-schema
by Kevin Cline
Turn plain English app descriptions into fully normalized SQL schemas and entity relationship documentation.
- Generate 3NF normalized SQL schemas from high-level app ideas
- Create detailed SCHEMA.md manuals documenting all entity relationships
- Automate the creation of junction tables for many-to-many relationships
$12
One-time purchase · Own forever
Included in download
- Generate 3NF normalized SQL schemas from high-level app ideas
- Create detailed SCHEMA.md manuals documenting all entity relationships
- Includes example output and usage patterns
See it in action
-- schema.sql generated for Postgres
CREATE TABLE products (
id BIGSERIAL PRIMARY KEY,
slug VARCHAR(255) UNIQUE NOT NULL,
price NUMERIC(10,2) NOT NULL,
category_id BIGINT REFERENCES categories(id),
deleted_at TIMESTAMP WITH TIME ZONE
);
CREATE INDEX idx_products_category ON products(category_id);db-schema
by Kevin Cline
Turn plain English app descriptions into fully normalized SQL schemas and entity relationship documentation.
$12
One-time purchase · Own forever
⚡ Also available via Agensi Pro — your AI agent can load this skill on demand via MCP. Learn more →
Included in download
- Generate 3NF normalized SQL schemas from high-level app ideas
- Create detailed SCHEMA.md manuals documenting all entity relationships
- Includes example output and usage patterns
- Instant install
- One-time purchase
See it in action
-- schema.sql generated for Postgres
CREATE TABLE products (
id BIGSERIAL PRIMARY KEY,
slug VARCHAR(255) UNIQUE NOT NULL,
price NUMERIC(10,2) NOT NULL,
category_id BIGINT REFERENCES categories(id),
deleted_at TIMESTAMP WITH TIME ZONE
);
CREATE INDEX idx_products_category ON products(category_id);About This Skill
What it does
This skill transforms natural language requests into production-ready database architectures. It interprets high-level business requirements and automatically generates both the SQL DDL and comprehensive markdown documentation for your data layer.
Problem it solves
Designing a normalized database from scratch is time-consuming and prone to manual errors, such as missing indexes on foreign keys, inconsistent naming conventions, or improper data types for currency. This skill automates the drudgery of schema design while enforcing industry best practices from the start.
Supported Tools
- PostgreSQL: Default support with JSONB, BIGSERIAL, and automated updated_at triggers.
- MySQL: Optimized with UNSIGNED types and AUTO_INCREMENT syntax.
- SQLite: Lightweight syntax with CHECK constraints for enums.
Why use this skill
Unlike generic AI prompts, this skill applies strict 3rd Normal Form (3NF) logic, ensures every table includes audit timestamps and soft-delete support, and handles complex many-to-many junction tables automatically. It doesn't just give you code; it produces a professional SCHEMA.md directory of your entities and relationships for your team.
📖 Learn more: Best Frontend & Design Skills for Claude Code →
Use Cases
- Generate 3NF normalized SQL schemas from high-level app ideas
- Create detailed SCHEMA.md manuals documenting all entity relationships
- Automate the creation of junction tables for many-to-many relationships
- Standardize audit fields like soft-deletes and timestamps across all tables
- Implement database-specific best practices for Postgres, MySQL, or SQLite
How to Install
unzip db-schema.zip -d ~/.claude/skills/Reviews
No reviews yet — be the first to share your experience.
Only users who have downloaded or purchased this skill can leave a review.
Early access skill
Be the first to review this skill.
Only users who have downloaded or purchased this skill can leave a review.
Security Scanned
Passed automated security review
Permissions
No special permissions declared or detected
Creator
ClawdWorks
Builder of autonomous AI agents and Claude Code skills. ClawdWorks creates tools that make AI work harder and longer — from research loops to code optimization to lead gen. Powered by Claude Opus 4.6 + Codex 5.4.
Frequently Asked Questions
Learn More About AI Agent Skills
Similar Skills
code-reviewer
Reviews your code for bugs, security vulnerabilities, logic errors, performance issues, and style violations. Organizes findings by severity and suggests fixes with code examples.
git-commit-writer
Writes conventional commit messages by analyzing your staged git changes. Detects commit type, scope, and breaking changes automatically.
readme-generator
Generates a complete, polished README.md by scanning your actual project structure, dependencies, and code.
pr-description-writer
Writes clear pull request descriptions by analyzing your branch diff. Covers what changed, why, how, and what to test. Works with GitHub, GitLab, and Bitbucket.