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
Secure checkout via Stripe
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
A real example of what this skill takes in and produces.
Sample output
-- 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.
Secure checkout via Stripe
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
A real example of what this skill takes in and produces.
Sample output
-- 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.
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
mkdir -p ~/.claude/skills && curl -sL https://www.agensi.io/api/install/db-schema | tar xz -C ~/.claude/skills/Free skills install directly. Paid skills require purchase - use the download button above after buying.
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
More Premium Skills
software-architect
A structured framework for planning, reviewing, and evolving complex software systems with explicit trade-offs.
designing-hybrid-context-layers
Architects the right retrieval strategy for every query — teaching your agent when to use RAG, a knowledge graph, or a temporal index instead of defaulting to vector search for everything.
consumer-motivation-analyzer
Go beyond surface-level feedback to uncover the psychological drivers and hidden motivations behind buyer behavior.
keyword-research
Transform URLs or product lists into SEO keyword research packs with Google Ads data and intent-based clustering.