skills.rest
anavvanzin
anavvanzinCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

agency-database-optimizer

Optimize PostgreSQL and MySQL database schemas and queries for high performance.

Updated Apr 15, 2026
Search Tags:#indexing#database#postgresql#migrations#performance-tuning#query-optimization#schema-design
One-click install
npx skills add https://github.com/anavvanzin/Research --skill agency-database-optimizer-anavvanzin
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: agency-database-optimizer
Source: https://github.com/anavvanzin/Research/tree/main/cowork/integrations/antigravity/agency-database-optimizer
Command: npx skills add https://github.com/anavvanzin/Research --skill agency-database-optimizer-anavvanzin

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Organizations building data-intensive applications often struggle to design scalable database schemas, optimize slow queries, and perform migrations safely under load.

Core Features & Use Cases

  • Optimized Schema Design: create robust schemas with appropriate constraints, indexing, and decisions between normalization and denormalization to balance performance and maintainability.
  • Query Optimization & Analysis: use EXPLAIN ANALYZE, appropriate indexes, and join strategies to eliminate bottlenecks and reduce response times on core workloads.
  • Safe Migrations & Maturity: plan reversible migrations with zero-downtime strategies, test performance impacts, and implement reliable rollback procedures.

Quick Start

Create an optimized schema for a simple blog app with users and posts, then run EXPLAIN ANALYZE on a representative query to verify performance.

Frequently Asked Questions about agency-database-optimizer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize slow PostgreSQL queries using EXPLAIN ANALYZE?▼

PostgreSQL query optimization involves using EXPLAIN ANALYZE to identify execution plan bottlenecks, applying appropriate indexes, and adjusting join strategies to eliminate N+1 query patterns and reduce response times.

What is the best way to design a scalable database schema for high traffic?▼

Scalable database schema design requires creating robust schemas with appropriate constraints, proper indexing, and strategic decisions between normalization and denormalization to balance performance and maintainability under load.

How do I perform zero-downtime database migrations safely under load?▼

Safe database migrations under load require planning reversible migrations with zero-downtime strategies, testing performance impacts beforehand, and implementing reliable rollback procedures to ensure system stability.

Does this database optimizer work with Supabase and PlanetScale?▼

Yes, the database optimizer supports PostgreSQL and MySQL, including specific patterns for Supabase and PlanetScale to address schema design, indexing, and migrations within those platforms.

How do I eliminate N+1 query problems in my database?▼

Eliminating N+1 queries requires analyzing query execution with EXPLAIN ANALYZE, applying appropriate indexing, and optimizing join strategies to batch data retrieval and avoid redundant database calls.

Related Skills

Explore More Software Engineering Skills→
ripgraphicsripgraphics

database-expert

Analyze database query plans and optimize performance across PostgreSQL, MySQL, MongoDB, and SQLite.

Community
Advanced
farmountainfarmountain
1

Performance Tester

Execute load and stress tests to validate application scalability and response times.

Community
Advanced
JesusFigueroa25JesusFigueroa25

Database Optimizer

Optimize PostgreSQL and MySQL database performance through schema, query, and indexing analysis.

Community
Advanced
VeradelaCruzVeradelaCruz

database-schema-design

Design and optimize SQL and NoSQL database schemas with migrations.

Community
Advanced