skills.rest
tankpkg
tankpkgOFFICIAL
Explore all skills by this author →
GitHub

@tank/relational-db-mastery

Optimize PostgreSQL and MySQL query performance with indexing and tuning strategies.

1|1|Updated Feb 20, 2026
Search Tags:#performance#indexing#database#postgresql#optimization#sql#mysql
One-click install
npx skills add https://github.com/tankpkg/skills --skill tank-relational-db-mastery
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: @tank/relational-db-mastery
Source: https://github.com/tankpkg/skills/tree/main/skills/relational-db-mastery
Command: npx skills add https://github.com/tankpkg/skills --skill tank-relational-db-mastery

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

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';

Frequently Asked Questions about @tank/relational-db-mastery

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

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

To optimize slow PostgreSQL queries, this Skill interprets EXPLAIN ANALYZE execution plans to identify bottlenecks and recommends query rewrites or specific indexes like B-tree or GIN to improve performance.

What is the best indexing strategy for MySQL performance optimization?▼

The best indexing strategy for MySQL performance involves analyzing query patterns to recommend optimal indexes. This Skill evaluates your schema and queries to determine when to apply specific index types for maximum database efficiency.

Does this database tuning approach work for both PostgreSQL and MySQL?▼

Yes, this database tuning approach supports both PostgreSQL and MySQL systems. It delivers database-specific tuning parameters and indexing strategies tailored to each platform's distinct architecture and query optimization mechanisms.

When do I need to redesign my database schema for performance?▼

You need to redesign your database schema for performance when experiencing persistent slow load times due to database queries. This Skill analyzes your schema efficiency and suggests structural improvements alongside indexing strategies to resolve bottlenecks.

Why does my SQL query ignore the index I created?▼

Your SQL query might ignore an index due to inefficient query structure or schema design. This Skill analyzes slow queries to identify why indexes are bypassed and recommends query rewrites or alternative index types like BRIN or GiST.

Related Skills

Explore More Software Engineering Skills→
rabbicserabbicse

database-optimizer

Optimize slow PostgreSQL and MySQL queries with EXPLAIN ANALYZE validation.

Community
Advanced
HieubkavHieubkav

database-performance

Analyze database indexes and query execution plans to recommend optimizations.

Community
Advanced
Archive228Archive228
746

sql-review

Reviews SQL and ORM queries for injection risks, missing indexes, and bottlenecks.

Community
Intermediate
AmidVoshakulAmidVoshakul

database-optimizer

Analyze execution plans and implement indexing strategies to optimize database performance.

Community
Advanced