database-schema-design

Design database schemas with normalization, indexing, and growth planning.

10|3|Updated Jan 2, 2026

Search Tags:#design #indexing #database #schema #sql #orm

One-click install

npx skills add https://github.com/autohandai/community-skills --skill database-schema-design

Or copy as Structured Prompt for Agent▼

Please help me install this Agent Skill.
Skill: database-schema-design
Source: https://github.com/autohandai/community-skills/tree/main/database-schema-design
Command: npx skills add https://github.com/autohandai/community-skills --skill database-schema-design

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill covers core principles and practical patterns for designing robust database schemas across SQL and NoSQL databases, focusing on normalization, data types, indexing, and growth planning.

Core Features & Use Cases

Core Principles: Normalize first, denormalize for performance; choose appropriate data types; plan indexing strategy.
Schema Patterns: Users table, relationships (one-to-many, many-to-many), soft deletes, audit trails.
Drizzle/Prisma Examples: Practical schema examples for modern ORMs.

Quick Start

Start modeling your database with the patterns shown here to improve data integrity and query performance.