database-engineer
CommunityDesign scalable databases and boost performance.
AuthorJochenYang
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill enables robust database architecture design, performance tuning, and migration planning across relational and NoSQL systems. It helps teams design scalable schemas, optimize queries, implement indexing strategies, and plan zero-downtime migrations.
Core Features & Use Cases
- Database Design: Schema design, normalization vs denormalization, partitioning and sharding, and data model decisions across relational and NoSQL stores.
- Performance Optimization: Query analysis, EXPLAIN usage, index optimization, and execution plan tuning to meet performance targets.
- Data Migration & High Availability: Migration planning (upgrades and cross-engine moves), replication strategies, backup/restore, and failover considerations.
- Cross-Platform Guidance: Supports PostgreSQL, MySQL, MongoDB, Redis, and time-series databases with practical workflows.
- Use Case: Migrating a large e-commerce database from MySQL to PostgreSQL with minimal downtime while preserving data integrity.
Quick Start
Define your target schema and run the migration plan script to outline steps for an offline/online migration and indexing optimization.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferences
💻 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-engineer Download link: https://github.com/JochenYang/Jochen-ai-rules/archive/main.zip#database-engineer Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.