skills.rest
POWERFULMOVES
POWERFULMOVESCOMMUNITY
Explore all skills by this author →
GitHub

database-design

Design, optimize, and migrate database schemas across PostgreSQL, MySQL, and NoSQL databases.

1|Updated Nov 7, 2025
Search Tags:#schema design#database#optimization#migration#sql#nosql
One-click install
npx skills add https://github.com/POWERFULMOVES/PMOVES-BoTZ --skill database-design-powerfulmoves
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/POWERFULMOVES/PMOVES-BoTZ/tree/main/.claude/skills/database-design
Command: npx skills add https://github.com/POWERFULMOVES/PMOVES-BoTZ --skill database-design-powerfulmoves

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill streamlines the complex processes of designing efficient database schemas, optimizing existing queries, and performing safe, reliable database migrations across various SQL and NoSQL platforms.

Core Features & Use Cases

  • Schema Design: Provides guidelines for normalization, denormalization, and constraint implementation.
  • Index Optimization: Offers strategies for creating effective indexes (B-tree, composite, partial, GIN) and analyzing their usage.
  • Migration Patterns: Details safe and zero-downtime migration techniques, including concurrent index creation and data backfilling.
  • Query Optimization: Guides users on analyzing query performance using EXPLAIN ANALYZE and applying common optimization patterns.
  • Use Case: A developer needs to design a new PostgreSQL schema for user authentication and profile management, ensuring data integrity and fast lookups. They can use this Skill to get best practices for normalization, indexing, and foreign key constraints.

Quick Start

Use the database-design skill to generate a PostgreSQL schema for a blog with posts, users, and comments, including appropriate indexes and foreign keys.

Frequently Asked Questions about database-design

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

FAQPage Schema
What's the best way to design a PostgreSQL schema with proper normalization and foreign keys?▼

To design a PostgreSQL schema, apply normalization guidelines and foreign key constraints to ensure data integrity. This approach streamlines schema design by structuring tables to reduce redundancy while maintaining reliable relationships for robust data modeling.

How do I perform zero-downtime database migrations without locking tables?▼

Zero-downtime database migrations utilize safe patterns like concurrent index creation and data backfilling. This migration approach prevents table locking, ensuring reliable schema evolution and continuous application availability during structural updates.

Can I optimize slow SQL queries using EXPLAIN ANALYZE and index strategies?▼

You can optimize slow SQL queries by running EXPLAIN ANALYZE to inspect performance and applying index strategies like B-tree, composite, or partial indexes. This query optimization identifies bottlenecks and significantly improves database lookup speed.

Does this schema design approach work for NoSQL as well as PostgreSQL and MySQL?▼

Yes, this schema design approach supports NoSQL alongside PostgreSQL and MySQL. It provides specific guidelines for both normalization and denormalization, allowing you to model data effectively across diverse SQL and NoSQL database platforms.

When should I use denormalization instead of normalization in database schema design?▼

Denormalization should be used instead of normalization when query performance and read speed outweigh strict data consistency. This schema design technique strategically combines tables to eliminate complex joins, optimizing database response times for heavy read workloads.

Related Skills

Explore More Software Engineering Skills→
guardiatechnologyguardiatechnology

kata-schema-design

Design relational or NoSQL database schemas with ER diagrams and constraints.

Official
Advanced
pohlai88pohlai88

database-testing

Validate database schemas, data integrity, migrations, and ACID properties.

Community
Advanced
jonnabiojonnabio
6

database-operations

Automate database migrations, schema changes, and query optimization.

Community
Advanced
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced