@tank/relational-db-mastery

What problem does it solve?

This Skill tackles slow database queries and general performance issues in PostgreSQL and MySQL, helping you identify and fix bottlenecks.

Core Features & Use Cases

• Query Optimization: Analyze and rewrite slow queries.
• Indexing Strategies: Recommend and create optimal indexes (B-tree, GIN, GiST, BRIN).
• Database Tuning: Provide guidance on PostgreSQL and MySQL specific tuning parameters.
• Use Case: Your application is experiencing slow load times due to database queries. Use this Skill to analyze a slow query, identify missing indexes, and get recommendations for rewriting it or tuning your database configuration.

Quick Start

Analyze the following slow query and suggest an index: SELECT * FROM users WHERE last_login < '2020-01-01';