skills.rest
BigPapiCB
BigPapiCBCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design relational database schemas and migration plans with indexing guidelines.

2|Updated Feb 6, 2026
Search Tags:#indexing#database#migrations#sql#data-modeling#schema-design#relational-databases
One-click install
npx skills add https://github.com/BigPapiCB/Universal-Claude-Skills --skill database-design-bigpapicb
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/BigPapiCB/Universal-Claude-Skills/tree/main/database-design
Command: npx skills add https://github.com/BigPapiCB/Universal-Claude-Skills --skill database-design-bigpapicb

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Database schema design and migration governance for relational databases, enabling teams to plan robust data models, efficient indexes, and safe evolution paths.

Core Features & Use Cases

  • Schema design guidance for relational databases (PostgreSQL, MySQL, etc.)
  • Indexing strategy recommendations and performance considerations
  • Migration rules and anti-patterns to avoid
  • Use cases: designing a new schema, reviewing existing migrations, auditing query performance

Quick Start

Describe a relational database schema plan for a new project and outline the initial migration steps.

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 relational database schema for a new project?▼

Designing a scalable relational database schema requires structured data modeling and indexing strategies. It provides checklists and best practices to plan robust data models and efficient indexes for PostgreSQL, MySQL, and similar relational systems.

What are the best practices for safe database migrations across a team?▼

Safe database migrations require enforcing structured rules and avoiding anti-patterns during schema changes. It establishes reliable evolution paths and change governance across teams to prevent data loss or downtime.

How do I create an indexing strategy to improve query performance?▼

Creating an indexing strategy involves analyzing query patterns and applying performance considerations to your schema. It offers recommendations for efficient indexes to audit and improve relational database query performance.

What are common database schema design anti-patterns I should avoid?▼

Database schema design anti-patterns include poorly structured data models and inefficient indexes that degrade performance. It outlines specific migration rules and anti-patterns to avoid when reviewing existing schemas or planning new ones.

Can I use this schema design guidance for both PostgreSQL and MySQL?▼

Yes, the schema design guidance applies to relational databases including PostgreSQL and MySQL. It provides general data modeling, indexing strategies, and migration governance applicable across various relational database systems.

Related Skills

Explore More Software Engineering Skills→
lexicalninjalexicalninja
2

database-implementer

Design database schemas, migrations, and data access layers for applications.

Community
Advanced
KILWA73KILWA73

schema-designer

Generate normalized database schemas with Mermaid ERDs and migration code.

Community
Advanced
MovchanetsMovchanets

database-design

Design database schemas for microservices applications with migration planning.

Community
Intermediate
devCharuzudevCharuzu

database-designer

Design database schemas with normalization checks and ERD generation.

Community
Advanced