onewave-ai/database-schema-designer
database-schema-designer/SKILL.md
Design optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints. Creates ERD diagrams, migration scripts, and data modeling best practices. Use when users need database design, schema optimization, or data architecture planning.
$ install --global
skillsauthnpx skillsauth add onewave-ai/claude-skills database-schema-designerInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Jun 8, 2026, 5:14 AM19.0s4 files scanned
SKILL.md
- name:
- database-schema-designer
- description:
- Design optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints. Creates ERD diagrams, migration scripts, and data modeling best practices. Use when users need database design, schema optimization, or data architecture planning.
Database Schema Designer
Design optimized, scalable database schemas with proper relationships and indexes.
Contents
references/schema-templates.md— SQL/NoSQL schema templates, ASCII ERD, and migration script templates.references/output-format.md— labeled section structure for the final deliverable.references/best-practices.md— naming, data types, indexes, relationships, SQL/NoSQL design rules, and the output quality checklist.
Workflow
-
Gather requirements. Determine the database engine (PostgreSQL, MySQL, MongoDB, etc.), application domain, main entities, most common queries, expected data volume and growth, performance requirements, and any compliance constraints.
-
Design the schema. Apply the engine-appropriate rules in
references/best-practices.md(SQL Database Design or NoSQL Database Design). -
Generate the complete schema. Produce CREATE TABLE statements or collection documents using the templates in
references/schema-templates.md. -
Create the entity relationship diagram in text format following the ERD template in
references/schema-templates.md. -
Provide migration scripts with both up and down (rollback) paths, per the migration template in
references/schema-templates.md. -
Format the complete output using the labeled sections in
references/output-format.md. -
Verify the result against the output quality checklist in
references/best-practices.md.
Example Triggers
- "Design a database schema for an e-commerce platform"
- "Create SQL tables for a blog system"
- "Help me design a MongoDB schema for a social network"
- "Optimize this database schema for performance"
- "Generate migration scripts for my schema"
Generate production-ready, optimized database schemas that scale.
Related Skills
onewave-ai/typography-scale-builder
development
VerifiedTrustedCommunity
Build a complete typographic system -- modular or fluid type scale, line-height and tracking per size, weight roles, and vertical rhythm -- exported as tokens, Tailwind config, and CSS. Pairs with font-pairing-suggester (which picks the fonts; this builds the system they live in).
217SKILL.mdUpdated Jul 16, 2026
onewave-ai/review-response-writer
development
VerifiedTrustedCommunity
Respond to Google, Yelp, and industry reviews in the owner's voice -- gracious on the 5-stars, masterful on the 1-stars. Handles the angry customer, the unfair review, the fake review, and the one that mentions a legal or health issue. Every response written for the thousand future customers reading it.
217SKILL.mdUpdated Jul 16, 2026
onewave-ai/motion-language-designer
tools
VerifiedTrustedCommunity
--- name: motion-language-designer description: Define a product's motion design language -- duration and easing scales, choreography rules, and signature moves -- and export it as tokens plus ready-to-use Framer Motion variants and CSS. The difference between animations and a motion system: everything moves like it belongs to the same product. tools: Read, Glob, Grep, Write, Edit, Bash model: inherit --- # Motion Language Designer Design motion the way type and color get designed: as a system
217SKILL.mdUpdated Jul 16, 2026
onewave-ai/local-seo-optimizer
development
VerifiedTrustedCommunity
Get a local business found on Google -- audit and optimize the Google Business Profile, local pack ranking factors, review velocity, NAP consistency across directories, and location pages. For businesses whose customers search "near me," this outranks everything else in marketing.
217SKILL.mdUpdated Jul 16, 2026