skills.rest
deerawan
deerawanCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-schema-designer

Design SQL or NoSQL database schemas with migrations and constraints.

1|Updated Sep 6, 2015
Search Tags:#indexing#migrations#data integrity#database schema#nosql design#sql design#constraint modeling
One-click install
npx skills add https://github.com/deerawan/dotfiles --skill database-schema-designer-deerawan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-schema-designer
Source: https://github.com/deerawan/dotfiles/tree/main/claude/skills/database-schema-designer
Command: npx skills add https://github.com/deerawan/dotfiles --skill database-schema-designer-deerawan

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) and assets (resource) components.

What problem does it solve?

This Skill helps you design robust, scalable database schemas that preserve data integrity and deliver strong query performance without turning schema work into guesswork.

Core Features & Use Cases

  • Generate production-ready schemas from a described data model, including sensible SQL table structures and relationships.
  • Apply database design best practices such as normalization guidance, constraint design, indexing strategy, and anti-pattern avoidance (e.g., missing foreign keys, poor money types).
  • Plan safe schema evolution with migration patterns, including reversible up/down migrations and backward-compatible changes.

Quick Start

Use database-schema-designer to design a schema for a multi-tenant SaaS with users, organizations, roles, and audit events at high traffic scale.

Frequently Asked Questions about database-schema-designer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I design a database schema for a new application from scratch?▼

Designing a database schema involves generating scalable SQL or NoSQL structures from your data model, applying normalization, constraint rules, and indexing strategy to prevent data integrity issues and optimize query performance.

What is the best way to plan safe database schema migrations and evolution?▼

Plan safe database schema migrations by generating reversible up/down migration steps and backward-compatible changes, ensuring maintainable table structures deploy without disrupting production systems.

How do I apply indexing and constraint modeling to improve database query performance?▼

Improve database query performance by applying indexing and constraint modeling, defining foreign-key rules and access patterns that prioritize query efficiency and avoid anti-patterns like missing foreign keys.

Can database schema design work for both SQL and NoSQL data models?▼

Yes, database schema design supports both SQL and NoSQL data models by producing scalable table or collection structures tailored to your described data model and specific access patterns.

How do I avoid common data integrity anti-patterns when designing database tables?▼

Avoid data integrity anti-patterns by applying normalization guidance and constraint design during schema generation, enforcing foreign-key rules to prevent issues like missing constraints or poor money types.

Does database schema design handle high traffic multi-tenant SaaS architectures?▼

Yes, database schema design handles high traffic multi-tenant SaaS architectures by generating scalable table structures for entities like users, organizations, and roles while prioritizing query efficiency.

Related Skills

Explore More Software Engineering Skills→
TorbenMerraldTorbenMerrald
1

Backend Models

Define and enforce database models and entity schemas across ORM and migration scripts.

Community
Advanced
Prompt-or-Die-LabsPrompt-or-Die-Labs
7

database-migration-helper

Generate reversible database migrations with schema changes and data transformations.

Official
Intermediate
EIS-ITSEIS-ITS

Backend Queries

Generate secure, optimized database queries with parameterized statements, eager loading, indexing, and transactions.

Official
Intermediate
Prorise-coolProrise-cool
24

data-modeling

Create conceptual, logical, and physical data models with ERDs and data dictionaries.

Community
Intermediate