skills.rest
iamtatsuki05
iamtatsuki05COMMUNITY
Explore all skills by this author →
Website𝕏@iam_tatsuki05GitHub

database-dev

Design database schemas and optimize SQL and NoSQL queries.

Updated Jul 10, 2023
Search Tags:#indexing#database#migrations#sql#normalization#nosql#query-optimization
One-click install
npx skills add https://github.com/iamtatsuki05/dotfiles --skill database-dev
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-dev
Source: https://github.com/iamtatsuki05/dotfiles/tree/main/dotfiles/.agent/skills/database-dev
Command: npx skills add https://github.com/iamtatsuki05/dotfiles --skill database-dev

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This skill helps database engineers and teams design or modify database schemas, optimize queries, plan migrations, and model data across SQL and NoSQL systems to improve performance and reliability.

Core Features & Use Cases

  • Schema design and normalization guidance for PostgreSQL, MySQL, SQLite, and MongoDB.
  • Query optimization and performance analysis including EXPLAIN plans, indexing strategies, and join optimization.
  • Migration planning and safety patterns with step-by-step best practices for zero-downtime changes and rollback procedures.
  • NoSQL and multi-model modeling patterns to balance normalization vs denormalization in document stores and key-value stores.
  • Performance debugging and N+1 diagnosis with production-ready recommendations for common workloads.

Quick Start

Design and optimize a sample orders database schema and outline a safe migration plan.

Frequently Asked Questions about database-dev

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

FAQPage Schema
How do I optimize slow SQL queries and analyze execution plans?▼

To optimize slow SQL queries, analyze EXPLAIN plans to identify bottlenecks and apply indexing strategies and join optimization for performance tuning across PostgreSQL and MySQL.

What is the best way to plan safe database migrations with zero downtime?▼

Safe database migrations require step-by-step planning with best practices for zero-downtime changes and rollback procedures, ensuring robust data modeling with guardrails for production environments.

How do I design and normalize database schemas for e-commerce platforms?▼

Design and normalize database schemas for e-commerce by applying normalization, indexing, and data modeling techniques to balance relationships and optimize query performance for real-world workloads.

How do I debug N+1 query problems in production applications?▼

Debug N+1 query problems by diagnosing performance issues with production-ready recommendations, utilizing query optimization and indexing strategies to resolve common workload inefficiencies.

Does this database modeling approach work with both SQL and NoSQL databases?▼

Yes, this approach supports SQL and NoSQL databases, applying normalization and multi-model modeling patterns to balance normalization vs denormalization in document stores like MongoDB.

When should I use denormalization in NoSQL document stores?▼

Use denormalization in NoSQL document stores when multi-model modeling patterns require balancing normalization vs denormalization to optimize query performance for specific workloads.

Related Skills

Explore More Software Engineering Skills→
DatTran26DatTran26

ck:databases

Translate business requirements into scalable MongoDB and PostgreSQL schema designs.

Community
Advanced
jabrenajabrena
423

513-frameworks-micronaut-db-migrations-flyway

Manage Flyway database migrations in Micronaut applications.

Community
Advanced
dhruvinrsonidhruvinrsoni

data-access

Implement data access layers with Repository pattern, transaction management, and N+1 prevention.

Community
Advanced
samChang72samChang72
1

database-specialist

Analyze and optimize SQL database queries with EXPLAIN ANALYZE and indexing strategies.

Community
Intermediate