database-design

Extract entities from requirements and design normalized relational database schemas.

Updated Apr 23, 2026

Search Tags:#database design #schema design #ORM #normalization #relational database

Ready to run

npx skills add https://github.com/baasith6/cursor-skills --skill database-design-baasith6

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies the complex task of designing database schemas, ensuring efficient and normalized data structures.

Core Features & Use Cases

Entity Identification: Extracts core entities from requirements and translates them into tables.
Relationship Definition: Provides guidance on defining one-to-one, one-to-many, many-to-many, and self-referential relationships.
Schema Design: Offers a step-by-step guide to designing the schema, including primary keys, timestamps, and naming conventions.
Best Practices: Covers best practices for primary keys, timestamps, naming, constraints, and indexes.
ORM Setup: Includes examples for ORM setup using Prisma and Drizzle.
Common Patterns: Discusses common patterns like soft deletes, audit logs, tags/labels, tree/hierarchy, and polymorphic associations.
Tips: Provides tips on normalization, derived data storage, enums, and thinking about data deletion.

Quick Start

Use the database-design skill to guide you through the design of your next database schema.

Frequently Asked Questions about database-design

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

FAQPage Schema

How do I design a relational database schema from scratch?▼

To design a relational database schema, extract core entities from your requirements, define their relationships, and apply best practices like normalization and indexing to ensure efficient data structures.

What are the best practices for defining relationships in schema design?▼

Schema design best practices for relationships include correctly identifying one-to-one, one-to-many, many-to-many, and self-referential connections, while applying consistent naming conventions and constraints across your tables.

How do I set up an ORM with my database schema?▼

You can set up an ORM with your database schema using frameworks like Prisma or Drizzle, which translate your defined tables, relationships, and constraints into application-level code.

What common patterns should I include when designing a database schema?▼

Common database schema patterns include implementing soft deletes, audit logs, tags or labels, tree hierarchies, and polymorphic associations to handle complex data tracking and structural requirements efficiently.

When should I apply normalization in relational database design?▼

Apply normalization in relational database design to reduce data redundancy and improve integrity, while also considering tips like derived data storage and proper enum usage for specific use cases.

Do I need prior knowledge of relational databases to use this schema design guide?▼

Yes, you need an understanding of relational database design principles to effectively use this guide for extracting entities, defining relationships, and applying schema best practices.