Solo UnicornDatabase Optimizer
Indexes, query plans, and schema design - databases that don't wake you at 3am.
What you can have running in the first 7 days
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.
10 min
Advanced
What's Included
- SKILL.md
- README.md
Preview
# 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 MissionInstallation Guide
Get up and running in under 5 minutes.
# Copy the skill into your project
cp database-optimizer/SKILL.md .claude/skills/database-optimizer.md
# Verify it loads
claude /skill database-optimizerOperator Pack. Pay once for the asset. Upgrade to implementation only when you want higher-touch help.
Community acceleration
Bring your workflow into the Solo Unicorn community for sharper feedback, operator critique, and more visibility once the system is live.
Upgrade path
- Start with this package and validate the workflow.
- Add specialized skills or bundles once the core system is stable.
- Use the community to sharpen positioning, demos, and feedback loops.
Need this adapted to your business?
Buy the asset first if you can run it yourself. If this workflow is business-critical or needs custom implementation, move into a sprint or fractional CIO advisory instead of guessing.
Discuss implementation →Tags
Related Products
AI Engineer
Turns ML models into production features that actually scale.
Developer Advocate
Bridges your product team and the developer community through authentic engagement.
Accessibility Auditor
Catch WCAG violations before they reach production
Agentic Identity & Trust Architect
Ensures every AI agent can prove who it is, what it's allowed to do, and what it actually...