agency-database-optimizer

Name: agency-database-optimizer
Availability: InStock
Author: bomberoxenviosdosruedas

Analyze PostgreSQL database schemas and queries for optimization recommendations.

1|Updated May 5, 2026

Search Tags:#schema design #PostgreSQL #query performance #database optimization #indexing strategies

Ready to run

npx skills add https://github.com/bomberoxenviosdosruedas/01EnviosDosRueda --skill agency-database-optimizer-bomberoxenviosdosruedas

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: agency-database-optimizer
Source: https://github.com/bomberoxenviosdosruedas/01EnviosDosRueda/tree/main/.agents/workflows/agency-database-optimizer
Command: npx skills add https://github.com/bomberoxenviosdosruedas/01EnviosDosRueda --skill agency-database-optimizer-bomberoxenviosdosruedas

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve?

The agency-database-optimizer skill tackles database inefficiency and poor performance by focusing on schema design, query optimization, and system stability.

Core Features & Use Cases

Optimized Schema Design: Offers guidelines for indexed foreign keys, appropriate constraints, and schema normalization/denormalization.
Query Optimization: Provides methods to detect and prevent N+1 queries, optimize joins, and enhance connection pooling.
Database Maintenance: Delivers best practices for maintaining PostgreSQL and other databases like MySQL, Supabase, and PlanetScale.
Use Case: For a company that manages large amounts of customer data across various database platforms, this skill helps to enhance database performance, streamline data access, and improve query speed.

Quick Start

Analyze the database schema using agency-database-optimizer to optimize indexing strategies and query 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 PostgreSQL schema design for better query performance?▼

To optimize PostgreSQL schema design, you need effective indexing strategies, appropriate constraints, and proper normalization. This skill provides guidelines for indexed foreign keys and schema adjustments to enhance query performance and overall database stability.

What's the best way to prevent N+1 queries and optimize joins in PostgreSQL?▼

Preventing N+1 queries and optimizing joins requires efficient querying patterns and connection pooling. This skill provides methods to detect N+1 queries, optimize joins, and enhance connection pooling for faster database access.

Does this database optimization approach work with MySQL, Supabase, and PlanetScale?▼

Yes, this database optimization approach works with MySQL, Supabase, and PlanetScale. While it focuses on PostgreSQL schema design and query execution, it delivers general maintenance best practices applicable to these compatible database platforms.

How do I choose the right indexing strategies for large customer databases?▼

Choosing the right indexing strategies involves analyzing schema design and querying patterns to handle large customer data. This skill emphasizes index strategy and efficient querying to maximize database performance, streamline data access, and improve query speed.

When should I normalize or denormalize my database schema for performance?▼

You should normalize or denormalize your database schema based on specific query performance needs and system stability. This skill offers guidelines on schema normalization and denormalization to tackle database inefficiency and improve execution.