Skills
.Work. You
Rest

database-dev

Community

Design, optimize, and secure robust databases.

Software Engineering#indexing#database#migrations#sql#normalization#nosql#query-optimization
Authoriamtatsuki05
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: database-dev
Download link: https://github.com/iamtatsuki05/dotfiles/archive/main.zip#database-dev

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.