database-design

Design database schemas and migration plans for PostgreSQL, MySQL, and NoSQL systems.

Updated Feb 15, 2026

Search Tags:#indexing #database #postgresql #migrations #sql #query-optimization #schema-design

Ready to run

npx skills add https://github.com/ricable/mcai --skill database-design-ricable

💬 Prompt for ChatGPT / Claude Chat▼

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

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you design reliable databases, avoid schema mistakes, and improve query performance without sacrificing data integrity.

Core Features & Use Cases

Schema Design: Model normalized or denormalized tables for PostgreSQL, MySQL, and NoSQL systems.
Performance Tuning: Plan effective indexes, analyze query execution, and reduce slow scans.
Safe Migrations: Create zero-downtime migration paths, backfills, and constraint changes for production databases.
Use Case: When a product team needs to launch a new billing feature, this Skill can define the tables, relationships, indexes, and migration steps needed to ship safely.

Quick Start

Ask for a production-ready database schema, migration plan, and indexing strategy for your application.

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 PostgreSQL schema with proper indexing and constraints?▼

Schema design for PostgreSQL involves modeling normalized or denormalized tables, planning effective indexes, and defining constraints to maintain data integrity. Analyzing query execution plans further reduces slow scans and ensures production reliability.

What is the best way to plan zero-downtime database migrations for production?▼

Zero-downtime database migrations require creating safe migration paths, backfills, and constraint changes without disrupting production traffic. This process enforces transactional safety and integrity controls throughout the schema transition.

How does query optimization work for slow SQL scans?▼

Query optimization for slow SQL scans works by analyzing query execution plans and planning effective indexes to reduce full table scans. This ensures performance tuning improves retrieval speed without sacrificing data integrity.

Can I use this approach for both relational databases and NoSQL systems?▼

Yes, this approach supports both relational databases like PostgreSQL and MySQL, as well as NoSQL systems. It handles document-oriented workflows, applying normalization or denormalization strategies appropriate to each data model.

When do I need denormalization in database schema design?▼

Denormalization in database schema design is needed when query performance requires reducing complex joins, often for read-heavy workloads. It involves intentionally modeling tables to combine data, balancing redundancy against improved query execution speed.