database-schema-design
This skill guides you through the complete lifecycle of database schema design, from conceptual modeling and logical design through physical optimization and safe migrations. It covers normalization principles, relationship patterns, indexing strategies, and query optimization techniques, with decision tables for choosing between SQL, document, and key-value storage engines. Includes zero-downtime migration patterns and backfill strategies to evolve schemas safely in production.
Database Schema Design helps you create normalized, performant schemas with proper relationships, constraints, and safe migrations.
AI-generated summary based on this skill's SKILL.md
Decision gist · record as of 2026-03-16
Database Schema Design helps you create normalized, performant schemas with proper relationships, constraints, and safe migrations. This skill guides you through the complete lifecycle of database schema design, from conceptual modeling and logical design through physical optimization and safe migrations. It covers normalization principles, relationship patterns, indexing strategies, and query optimization techniques, with decision tables for choosing between SQL, document, and key-value storage engines. Includes zero-downtime migration patterns and backfill strategies to evolve schemas safely in production.
Use it when
- database-schema-design emphasizes normalization to reduce data anomalies, explicit relationship definitions with foreign keys.
- database-schema-design provides decision tables to guide your choice.
Verify before relying
Read SKILL.md below before installing (1 file). Open directory: indexed for reading, not audited.
Install
Pixel-Process-UG/superkit-agents/database-schema-design · repository language: TypeScript
Open directory. Skills are indexed for reading, not audited. Review a skill's body before installing it.
Frequently asked questions
AI-generated answers based on this skill's SKILL.md and metadata
How do I design a database schema?
database-schema-design guides you through conceptual modeling, logical design, and physical optimization. Start by identifying entities and their relationships, apply normalization principles to eliminate redundancy, define primary and foreign keys, and add constraints. The skill covers relationship patterns (one-to-one, one-to-many, many-to-many), denormalization trade-offs, and indexing strategies to balance query performance with storage efficiency.
What are database schema design best practices?
database-schema-design emphasizes normalization to reduce data anomalies, explicit relationship definitions with foreign keys, appropriate constraint enforcement, and strategic indexing. Key practices include avoiding N+1 query patterns, choosing composite indexes wisely, designing for your access patterns, considering multi-tenancy isolation early, and planning schema evolution. Document your design decisions and validate them against real query workloads.
SQL vs NoSQL—which should I use?
database-schema-design provides decision tables to guide your choice. Use SQL for structured data with complex relationships, ACID requirements, and evolving schemas. Choose NoSQL (document stores) for flexible schemas, horizontal scaling, and denormalized data patterns. Key-value stores suit caching and sessions. Consider your consistency needs, query patterns, team expertise, and growth trajectory. The skill covers schema design patterns specific to each engine.
How do I create database migrations safely?
database-schema-design covers zero-downtime migration patterns and rollback strategies. Deploy schema changes separately from application code, use feature flags to gate new columns, backfill data in batches to avoid locking, and maintain dual-write periods during transitions. Always test migrations on production-like data volumes, monitor performance impact, and keep rollback procedures documented and practiced.
What indexing strategy improves database query performance?
database-schema-design teaches query pattern analysis to identify hot paths, then covers single-column indexes for WHERE and JOIN conditions, composite indexes for multi-column filters, and covering indexes to enable index-only scans. Avoid over-indexing—each index slows writes. Monitor slow query logs, use EXPLAIN plans to validate index usage, and regularly remove unused indexes. Balance read optimization against write costs.
Should I normalize or denormalize my database?
database-schema-design explains normalization principles (1NF through 3NF) to eliminate anomalies and redundancy, then covers denormalization trade-offs. Normalize by default for data integrity and storage efficiency. Denormalize strategically when query performance analysis shows repeated joins are bottlenecks, but accept increased storage and update complexity. Document denormalization decisions and validate them against real workloads before committing.
SKILL.md
Rendered from the published skill. Quoted content, verbatim.
Database Schema Design
Overview
Guide the design, implementation, and optimization of database schemas with sound data modeling, safe migrations, effective indexing, and appropriate query patterns. This skill covers the full lifecycle from conceptual modeling through physical optimization, ensuring schemas that are normalized, performant, and safely evolvable.
Announce at start: "I'm using the database-schema-design skill to design the database schema."
Phase 1: Discovery and Conceptual Model
Ask these questions to understand the data requirements:
| # | Question | What It Determines |
|---|---|---|
| 1 | What entities does the system manage? | Table names |
| 2 | What are the relationships between entities? | Foreign keys, join tables |
| 3 | What are the key attributes of each entity? | Column definitions |
| 4 | What are the primary query patterns? | Index strategy |
| 5 | What is the expected data volume? (rows, |
(truncated - see the full file via the links below)
File tree — 1 file
templates/skills/database-schema-design/SKILL.md
Let your AI agent find skills like this
Example. Real query, live index.
You found this page by searching. An agent finds it by wishing: SkillFed indexes 56,283 agent skills by what they can do, searchable in plain language.
wish › “Design a normalized database schema with proper relationships and constraints”
Give your agent the search over MCP, or paste the wish link into any chat. No install? Search from any chat →
Related skills
Database Fundamentals guides code review of schemas, queries, and migrations across SQL and NoSQL systems. It surfaces common pitfalls like N+1 queries, missing indexes, and unsafe string concatenation, while providing checklists for normalization, data types, and reversible migrations.
Database Design guides you through schema normalization, indexing strategies, and query optimization for both SQL and NoSQL systems. It covers normalization forms, denormalization trade-offs, index types, and migration patterns to help you build performant, maintainable databases. Use it when designing tables, fixing performance issues, or planning data migrations.
Build well-structured database schemas from requirements through deployment. This skill guides you through normalization, relationship design, index optimization, and reversible migrations—covering relational databases like PostgreSQL and MySQL, document stores like MongoDB, and ORMs including Prisma, Drizzle, and TypeORM.
oma-db guides you through relational, document, and vector data modeling with schema documentation, integrity rules, and transaction design. It covers normalization, indexing, capacity planning, backup strategy, and anti-pattern remediation, plus ISO 27001/27002-aligned recommendations for security and continuity.
DataModelLM is a visual editor for building database schemas in Prisma format, rendering them as entity-relationship diagrams on an interactive canvas. Define models, relationships, and constraints through a structured schema file, then view the resulting data structure graphically. Supports one-to-many, one-to-one, and many-to-many relationships with full Prisma type and attribute support.
Senior Architect guides system design through structured phases: requirements analysis, architecture evaluation, and decision documentation. It produces Architecture Decision Records, trade-off analyses, and scalability blueprints grounded in proven patterns.
More skills database-design (MIT)