SQL Query Optimizerv1.0.0

An e-commerce site experiences slow product search queries during peak traffic. The skill analyzes queries like SELECT * FROM products WHERE name LIKE '%shoes%' and suggests indexing the name column, avoiding wildcard prefixes, and limiting results to improve response times.

A bank needs to generate daily transaction reports from large datasets. The skill detects inefficient queries such as nested subqueries and recommends using JOINs and proper WHERE clauses to reduce execution time and resource usage.

A hospital's database struggles with slow patient record retrieval. The skill identifies issues like missing LIMIT in queries and suggests adding indexes on patient IDs and optimizing SELECT statements to speed up access for medical staff.

A SaaS provider faces performance degradation as user data grows. The skill analyzes execution plans for user management queries, recommending index additions and avoiding SELECT * to maintain fast query responses and support scaling.

Offer basic query analysis for free to attract users, with premium features like advanced optimization suggestions and priority support for a monthly subscription fee. Targets small to medium businesses.

Provide personalized SQL optimization consulting for enterprises, including on-site training and custom integration. Revenue comes from project-based contracts and ongoing maintenance agreements.

License the skill as an API for integration into other database management tools or platforms. Charge based on usage volume, such as per query analyzed or monthly active users.