skills.rest
julianromli
julianromliCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

database-design

Design relational schemas and migration patterns for PostgreSQL, MySQL, and NoSQL databases.

141|20|Updated Dec 19, 2025
Search Tags:#design#performance#indexing#migrations#schema#sql#normalization
One-click install
npx skills add https://github.com/julianromli/opencode-template --skill database-design-julianromli
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-design
Source: https://github.com/julianromli/opencode-template/tree/main/skill/database-design
Command: npx skills add https://github.com/julianromli/opencode-template --skill database-design-julianromli

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Designing robust, scalable database schemas and safe migration strategies is essential for reliable applications across PostgreSQL, MySQL, and NoSQL systems.

Core Features & Use Cases

  • Normalization guidelines to produce clean, scalable schemas.
  • Migration patterns that minimize downtime and support zero-downtime upgrades.
  • Indexing and query optimization strategies to improve performance and data integrity.
  • Real-world use cases include structuring users and addresses with appropriate constraints and relations.

Quick Start

Design and migrate a sample schema using the guidelines described above.

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 normalization and indexing?▼

Design a database schema by applying normalization guidelines to produce clean, scalable structures, and use indexing strategies to improve query performance and data integrity across PostgreSQL and MySQL.

What is the best way to minimize downtime during database migrations?▼

Minimize downtime during database migrations by applying safe migration patterns that support zero-downtime upgrades, ensuring continuous application availability while updating relational schemas.

How do I structure users, orders, and audit trails across PostgreSQL and NoSQL?▼

Structure users, orders, and audit trails by identifying robust relational schemas and applying appropriate constraints and relations, ensuring compatibility across PostgreSQL, MySQL, and NoSQL workloads.

Does this schema design approach work for NoSQL databases?▼

Yes, the approach works for NoSQL databases by identifying robust schemas and migration patterns tailored to NoSQL systems, extending normalization and indexing techniques beyond traditional PostgreSQL and MySQL environments.

When should I apply normalization vs indexing for database performance?▼

Apply normalization to produce clean, scalable schemas and use indexing to improve query performance and data integrity, balancing both techniques based on specific workload requirements and access patterns.

Related Skills

Explore More Software Engineering Skills→
Snowflake-LabsSnowflake-Labs
1

oracle-connection

Configure and verify Oracle database connections for schema extraction.

Official
Intermediate
novskidevnovskidev
2

database-design

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

Community
Advanced
devon87warren-afkdevon87warren-afk

database-design

Guide database and ORM selection, schema design, indexing, and query optimization.

Community
Intermediate
edulazaroedulazaro
12

lc:model-diagram

Generate Mermaid Entity-Relationship diagrams from Eloquent models and migrations.

Community
Intermediate