skills.rest
novskidev
novskidevCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Design and migrate PostgreSQL, MySQL, and NoSQL database schemas.

2|Updated Jan 27, 2026
Search Tags:#query optimization#database migration#data integrity#database optimization#database schema design
One-click install
npx skills add https://github.com/novskidev/codex-skill-template --skill database-design-novskidev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/novskidev/codex-skill-template/tree/main/skills/database-design
Command: npx skills add https://github.com/novskidev/codex-skill-template --skill database-design-novskidev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill aids in creating robust and efficient database schemas for PostgreSQL, MySQL, and NoSQL databases, optimizing for design, migration, and query performance.

Core Features & Use Cases

  • Schema Design Principles: Offers normalization guidelines and denormalization for performance, aiding in building strong data structures.
  • Index Design: Helps in creating effective index strategies, including B-tree, composite, partial, GIN, and covering indexes.
  • Migration Patterns: Provides a safe migration template and zero-downtime migration strategies to update databases without disruptions.
  • Query Optimization: Teaches how to use EXPLAIN and analyze common optimizations like using EXISTS, pagination, and CTEs for complex queries.
  • Constraints & Data Integrity: Implements primary keys, foreign keys, check constraints, unique constraints, and exclusion constraints to ensure data integrity.
  • Best Practices: Encourages using UUIDs, adding timestamps, soft deletes, and documenting schema decisions for maintainable schemas.

Quick Start

Apply the database-design skill to design your next database schema and implement optimized 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 database schema with proper normalization and performance optimization?▼

Database schema design combines normalization guidelines with denormalization strategies to optimize query performance. This skill provides structural patterns for PostgreSQL, MySQL, and NoSQL databases to ensure data integrity.

What's the best way to execute zero-downtime database migrations?▼

Zero-downtime database migrations utilize safe migration templates and specific strategies to update schemas without service disruptions. This approach ensures data integrity during structural transitions across PostgreSQL and MySQL environments.

How do I use EXPLAIN and CTEs for PostgreSQL query optimization?▼

PostgreSQL query optimization uses EXPLAIN to analyze execution plans and applies Common Table Expressions (CTEs) for complex queries. It includes techniques like using EXISTS and pagination to improve data retrieval efficiency.

When do I need composite, partial, or GIN indexes in my database?▼

You need composite, partial, or GIN indexes when optimizing specific database query patterns. Effective index design strategies target exact lookup requirements, ensuring fast data retrieval without degrading write performance.

Does this database design approach support NoSQL and relational databases?▼

This database design approach supports NoSQL, PostgreSQL, and MySQL databases. It provides tailored schema design principles, index creation strategies, and data integrity enforcement mechanisms across different database paradigms.

Why should I use UUIDs, soft deletes, and timestamps in database schema design?▼

Using UUIDs, soft deletes, and timestamps in database schema design ensures maintainable, auditable data structures. These best practices enforce data integrity, preserve historical records, and prevent accidental data loss.

Related Skills

Explore More Software Engineering Skills→
earayuearayu
34

database-migration

Generate and apply Alembic migrations for SQLAlchemy models in Neon environments.

Community
Advanced
januarfontijanuarfonti
10

database-design

Design schemas, indexes, migrations, and query optimizations for PostgreSQL, MySQL, and NoSQL databases.

Community
Advanced
jeremylongshorejeremylongshore
2.6k

generating-orm-code

Generate ORM models and database schemas across multiple frameworks.

Community
Intermediate
ntaksh42ntaksh42
1

database-migration-generator

Generate SQL and TypeORM database migration scripts with rollback support.

Community
Intermediate