SkillsAdd

onewave-ai/claude-skills

database-schema-designer

Design optimized database schemas for SQL and NoSQL databases including tables, relationships, indexes, and constraints.

First seen Jan 24, 2026

Installation

$ npx skills add onewave-ai/claude-skills --skill database-schema-designer
View on skills.sh ↗ GitHub repository ↗

Summary

  • 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.

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

supabase-postgres-best-practices Shared topics
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
agent-browser Shared topics
vercel-labs/agent-browser

Browser automation CLI for AI agents. Use when the user needs to interact with websites, includ…

810.4K installs
vercel-react-best-practices Shared topics
vercel-labs/agent-skills 697.8K installs
web-design-guidelines Shared topics
vercel-labs/agent-skills

Review UI code for Web Interface Guidelines compliance. Use when asked to "review my UI", "chec…

617.3K installs
microsoft-foundry Shared topics
microsoft/azure-skills

Build, deploy, evaluate, optimize, fine-tune, and manage Microsoft Foundry agents, models, and …

576.5K installs
azure-hosted-copilot-sdk Shared topics
microsoft/azure-skills 440.4K installs

Also in this package

Other skills from onewave-ai/claude-skills · top by installs.

npx skills add onewave-ai/claude-skills
landing-page-copywriter 6K code-review-pro 2.5K csv-excel-merger 1.1K screenshot-to-code 1.0K technical-writer 971 social-media-content-repurposer 764 css-animation-creator 748 sports-betting-analyzer 666 knowledge-base-builder 633 job-application-optimizer 631

Browse all from onewave-ai/claude-skills

More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Repository health

Stars 287
License MIT
Default branch main
Open issues 0
Status Active

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 2,118 B
  • docs SUMMARY.md 2,083 B

History

  1. First seen on skills.sh
  2. First recorded snapshot · 346 installs

SKILL.md

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

  1. 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.
  1. Design the schema. Apply the engine-appropriate rules in references/best-practices.md (SQL Database Design or NoSQL Database Design).
  1. Generate the complete schema. Produce CREATE TABLE statements or collection documents using the templates in references/schema-templates.md.
  1. Create the entity relationship diagram in text format following the ERD template in references/schema-templates.md.
  1. Provide migration scripts with both up and down (rollback) paths, per the migration template in references/schema-templates.md.
  1. Format the complete output using the labeled sections in references/output-format.md.
  1. 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.