index-optimizationv1.0.0

Optimize query performance for high-traffic tables like 'orders' or 'products' in MySQL or PostgreSQL, handling frequent searches, filters, and pagination. This scenario uses the skill's full mode to analyze all queries, design reusable indexes, and validate with explain to reduce latency during peak sales events.

Improve read efficiency for user data collections in a multi-tenant SaaS app by identifying inefficient queries and overlapping indexes. The skill applies in single-query mode to target specific slow aggregations, ensuring minimal write overhead and safe index deletions with rollback plans.

Enhance performance for complex analytical queries on transaction tables in TiDB or PostgreSQL, focusing on range scans and joins. Using full mode, it locates all reporting queries, designs composite indexes, and iteratively validates explain results to meet strict SLAs for daily reports.

Streamline access patterns for 'articles' or 'media' tables in MySQL, addressing slow updates and deletions due to outdated indexes. The skill employs confirmation mode to safely remove redundant indexes after verifying alternatives, reducing storage and improving write speeds.

Offer specialized index optimization as a paid service for clients with performance-critical databases, using the skill to deliver detailed reports and SQL scripts. Revenue comes from project-based fees or retainer contracts for ongoing maintenance and tuning.

Integrate the skill into a cloud-based database management platform as a premium feature, automating index recommendations for subscribers. Revenue is generated through tiered subscription plans based on usage volume or number of databases optimized.

Deploy the skill internally within large enterprises to empower development teams with self-service index optimization, reducing reliance on external DBAs. Revenue is indirect, realized through cost savings from improved application performance and reduced downtime.