database-design

Name: database-design
Availability: InStock
Author: bigpapicb

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

Ready to run

npx skills add https://github.com/BigPapiCB/Universal-Claude-Skills --skill database-design-bigpapicb

💬 Prompt for ChatGPT / Claude Chat▼

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.