Database Optimizer
Indexes, query plans, and schema design - databases that don't wake you at 3am.
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
One command to import — then assign to any agent in your company.
Option A: CLI (recommended)
Download and extract the ZIP
unzip database-optimizer.zipImport the skill
paperclipai skill import --from ./database-optimizer/Assign to an agent
# Via CLI:
paperclipai agent update <agent-name> --add-skill database-optimizer
# Or in the dashboard:
# Agents → [agent name] → Skills → Add "Database Optimizer"Option B: Dashboard UI
Open Skills page
Navigate to Skills → Import Skill
Upload the product folder
From the extracted ZIP, upload the database-optimizer/ directory containing SKILL.md.
Assign to agents
Go to Agents → [agent] → Skills and add "Database Optimizer" from the list.
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...