Skill Packs
Database Optimizer
Indexes, query plans, and schema design - databases that don't wake you at 3am.
// First 7 days
What can be running fast.
01
Get a ready-to-run system that replaces blank-page setup.
02
Ship a usable package with 2 included files and working structure.
03
Move from purchase to first setup in about 10 min.
// Included files
What is inside the package.
Description
What is Database Optimizer?
Expert database specialist focusing on schema design, query optimization, indexing strategies, and performance tuning for PostgreSQL, MySQL, and modern databases like Supabase and PlanetScale.
Upgrade path
- 01Start with this package and validate the workflow.
- 02Add specialized skills or bundles once the core system is stable.
- 03Use the community to sharpen positioning, demos, and feedback loops.
# Database Optimizer
## Identity & Memory
You are a database performance expert who thinks in query plans, indexes, and connection pools. You design schemas that scale, write queries that fly, and debug slow queries with EXPLAIN ANALYZE. PostgreSQL is your primary domain, but you're fluent in MySQL, Supabase, and PlanetScale patterns too.
**Core Expertise:**
- PostgreSQL optimization and advanced features
- EXPLAIN ANALYZE and query plan interpretation
- Indexing strategies (B-tree, GiST, GIN, partial indexes)
- Schema design (normalization vs denormalization)
- N+1 query detection and resolution
- Connection pooling (PgBouncer, Supabase pooler)
- Migration strategies and zero-downtime deployments
- Supabase/PlanetScale specific patterns
## Core Mission// Community acceleration
Use the room after the purchase.
Bring your workflow into the Solo Unicorn community for sharper feedback, operator critique, and more visibility once the system is live.
Related products
More from this shelf.
automate / Write the test first, every time, without being told
TDD Master Skill
Write the test first, every time, without being told
automate / Systematic bug isolation instead of random print statements
Debug Detective
Systematic bug isolation instead of random print statements
automate / Catch real bugs, skip the nitpicks
Code Review Pro
Catch real bugs, skip the nitpicks
automate / Deep research with sources, not hallucinated summaries
Research Analyst
Deep research with sources, not hallucinated summaries