skills.rest
codeworksID
codeworksIDCOMMUNITY
Explore all skills by this author →
GitHub

backend-db-design

Automate database schema design, ERD generation, and migration planning.

17|1|Updated Jun 12, 2026
Search Tags:#database design#indexing#migration#ERD#normalization#database types#schema planning
One-click install
npx skills add https://github.com/codeworksID/everything-backend --skill backend-db-design
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: backend-db-design
Source: https://github.com/codeworksID/everything-backend/tree/main/.agents/skills/backend-db-design
Command: npx skills add https://github.com/codeworksID/everything-backend --skill backend-db-design

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the challenge of designing and planning database schemas efficiently, providing guidance on table structures, relationships, indexes, and constraints.

Core Features & Use Cases

  • Schema Design: Offers a step-by-step process to design database schemas, including table structures, relationships, indexes, and constraints.
  • Database Selection: Recommends the best database type based on the project's needs, such as PostgreSQL, MySQL, MongoDB, or Redis.
  • ERD Generation: Generates ERD diagrams to visualize database schemas.
  • Migration Planning: Assists in planning and creating migration files for schema changes.
  • Normalization Review: Provides a normalization review template to ensure schema efficiency.
  • Index Design: Offers guidance on creating effective indexes for query optimization.
  • MongoDB Schema Template: Provides a template for designing MongoDB schemas.
  • PostgreSQL Schema Template: Provides a template for designing PostgreSQL schemas.
  • Decision Trees: Includes decision trees for common scenarios like e-commerce, content management, and real-time features.
  • Edge Cases: Covers edge cases such as complex relationships, high write load, and multi-tenant architectures.

Quick Start

Use the backend-db-design skill to design the database schema for your new project.

Frequently Asked Questions about backend-db-design

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

FAQPage Schema
How do I design a database schema for a new project?▼

Designing a database schema is automated through a step-by-step process that structures table relationships, indexes, and constraints. It provides templates for PostgreSQL and MongoDB to generate the foundational schema efficiently.

What is the best way to choose between SQL and NoSQL database types?▼

Choosing between SQL and NoSQL database types is guided by built-in decision trees evaluating project needs. It recommends specific options like PostgreSQL, MySQL, MongoDB, or Redis based on your data structure and feature requirements.

How do I plan database migrations for schema changes?▼

Planning database migrations is handled by generating migration files directly from your schema design. This ensures structured and version-controlled updates when altering table structures or relationships.

Can I generate an ERD diagram to visualize my database schema?▼

Generating an ERD diagram is supported to help visualize your database schema. This allows you to see table structures and their relationships clearly during the planning phase.

How do I optimize query performance with index design and normalization?▼

Optimizing query performance with index design is achieved through specialized guidance on creating effective indexes. A normalization review template is also provided to ensure your schema maintains maximum efficiency.

Does this handle database design for multi-tenant architectures?▼

Handling database design for multi-tenant architectures is explicitly supported. It covers edge cases including complex relationships and high write loads to ensure your schema scales correctly for demanding scenarios.

Related Skills

Explore More Software Engineering Skills→
stribusstribus
1

reversa-data-master

Document legacy database schemas into data dictionaries and Mermaid ERDs.

Community
Advanced
mattbutlerengineeringmattbutlerengineering
1

prisma-migrations

Automate Prisma schema migrations with version-controlled change management.

Community
Advanced
nirukk52nirukk52

backend-dev

Automate Encore.ts backend tasks including APIs, databases, auth, messaging, and storage.

Community
Advanced
dpieterszdpietersz

Backend Models

Define typed ORM models with relationships, constraints, validation across languages.

Community
Advanced