/*
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`