skills.rest
enoch-robinson
enoch-robinsonCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design relational database schemas with ER modeling, normalization, and indexing.

Updated Jan 10, 2026
Search Tags:#design#indexing#SQL#database#normalization#schema-design#ER-modeling
One-click install
npx skills add https://github.com/enoch-robinson/agent-skill-collection --skill database-design-enoch-robinson
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/enoch-robinson/agent-skill-collection/tree/main/skills/development/database-design
Command: npx skills add https://github.com/enoch-robinson/agent-skill-collection --skill database-design-enoch-robinson

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps developers design efficient, scalable database schemas that produce reliable data integrity and performance across applications.

Core Features & Use Cases

  • ER modeling & relationship mapping: guides conceptual design to translate business domains into entities and relationships.
  • Logical & physical design: defines tables, keys, normalization levels, and indexing strategies for performance and storage efficiency.
  • Practical use cases: examples include designing schemas for an e-commerce catalog and order processing system, or a SaaS multi-tenant data model.

Quick Start

Start by identifying core entities and relationships in your domain, then translate them into tables with primary and foreign keys and an initial indexing plan. For example, outline tables for users, products, orders, and order_items with appropriate keys and indexes to support common queries.

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 scalable database schema for a multi-tenant SaaS application?▼

Database schema design for e-commerce starts with identifying core entities like users, products, orders, and order_items. It translates these into tables with primary and foreign keys, applying indexing strategies to support common queries and ensure performance.

What are the best practices for database normalization and ER modeling?▼

Database schema design applies to relational database tasks across domains like e-commerce, SaaS, and analytics. It enforces best practices for primary and foreign keys, relationships, and indexing strategies to support performance tuning and data integrity.

How do I create an indexing strategy for SQL performance tuning?▼

Database schema design avoids anti-patterns by enforcing best practices for naming conventions, primary and foreign keys, relationships, and indexing strategies. It provides practical templates and anti-pattern guidance to maintain reliable data integrity.

What is the best way to structure database tables for an e-commerce catalog and order processing system?▼

Structure e-commerce database tables by mapping core entities like users, products, orders, and order_items. It translates these into tables with primary and foreign keys, applying an initial indexing plan to support common queries and ensure reliable performance.

Related Skills

Explore More Software Engineering Skills→
SSiertsemaSSiertsema

conceptual-data-modeling

Define domain entities, relationships, and business rules in plain language.

Community
Intermediate
prashsubprashsub
1

01-yaml-table-setup

Create Gold layer tables from YAML schema definitions using Python scripts.

Community
Advanced
mahamaneharouna9-cpumahamaneharouna9-cpu

database-expert

Optimize database performance and schema design across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
chef0111chef0111
1

databases

Manage MongoDB and PostgreSQL databases with schema design, CRUD, indexing, and migrations.

Community
Advanced