/* LEEWAY HEADER — DO NOT REMOVE

REGION: AI.SKILL.DATABASE_DESIGN TAG: AI.SKILL.DATABASE_DESIGN.DATABASE_DESIGN_OPTIMIZATION

COLOR_ONION_HEX: NEON=#39FF14 FLUO=#0DFF94 PASTEL=#E8F5E9

ICON_ASCII: family=lucide glyph=zap

5WH: WHAT = database design optimization skill for Leeway-compliant AI systems WHY = Provides capabilities for database-design within the AIskills ecosystem WHO = Leeway Industries (By Leonard Jerome Lee) WHERE = skills/database-design/database-design-optimization/SKILL.md WHEN = 2026 HOW = Leeway-governed skill.md definition with structured capabilities and tags

AGENTS: ASSESS AUDIT

ASSIGNED_SACRED_AGENTS: L7_Memory: ClerkArchive.ts, L7_Memory: indexer.py

LICENSE: MIT */

SOVEREIGN ALIGNMENT: This skill is strictly executed by L7_Memory: ClerkArchive.ts, L7_Memory: indexer.py. No unassigned Clones may natively execute this without Hive Mind routing.

Database Design and Optimization

Expert in: Designing scalable, efficient database systems with proper modeling, indexing, and query optimization.

Capabilities

• Design relational and NoSQL database schemas
• Implement normalization and denormalization strategies
• Create optimal indexing strategies
• Optimize complex queries and execution plans
• Implement partitioning and sharding strategies
• Design data migration and backfill processes
• Handle eventual consistency and CAP theorem trade-offs
• Implement caching strategies (Redis, Memcached)

Use this skill when:

• Designing new database systems
• Scaling databases for performance
• Optimizing slow queries
• Planning data structure changes
• Implementing complex queries
• Managing data growth and scale
• Handling consistency requirements

Key techniques

• Relational normalization (1NF through BCNF)
• Index design (B-tree, hash, bitmap)
• Query planning and optimization
• Join strategies and explanation
• Partitioning strategies (range, hash, list)
• Sharding and distributed databases
• MVCC and transaction isolation levels
• Connection pooling and resource management

Tags

database sql optimization schema-design performance scaling