skills.rest
codeApe-7
codeApe-7COMMUNITY
Explore all skills by this author →
GitHub

database-optimizer

Analyze PostgreSQL and MySQL query performance and recommend index and configuration tuning.

17|3|Updated Mar 18, 2026
Search Tags:#performance#indexing#database#postgresql#sql#mysql#tuning
One-click install
npx skills add https://github.com/codeApe-7/ai-agent-workflowGroup --skill database-optimizer-codeape-7
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/codeApe-7/ai-agent-workflowGroup/tree/main/skills/database/database-optimizer
Command: npx skills add https://github.com/codeApe-7/ai-agent-workflowGroup --skill database-optimizer-codeape-7

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires psycopg2, mysql-connector-python, pymongo, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill enhances database query speed and scalability by providing detailed analysis and optimization strategies for PostgreSQL and MySQL systems.

Core Features & Use Cases

  • Performance Analysis: Diagnose slow queries and identify bottlenecks using explain plans and metrics.
  • Index Design: Create and maintain effective indexing strategies to improve query efficiency.
  • Database Tuning: Adjust configuration parameters for optimal memory, I/O, and concurrency settings.
  • Use Case: A large e-commerce site experiencing sluggish report generation can utilize this Skill to analyze query plans, add indexing, and fine-tune server settings for faster response times.

Quick Start

Load your database diagnostics, then run queries analyzing slow SQL statements or examine existing index usage to identify improvements.

Frequently Asked Questions about database-optimizer

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

FAQPage Schema
How do I tune slow PostgreSQL and MySQL queries to reduce latency?▼

You can optimize database query performance by analyzing explain plans to identify bottlenecks, then applying actionable index recommendations and configuration tuning guidance to minimize query latency and maximize throughput for PostgreSQL and MySQL.

What is the best way to design indexes for improving database query performance?▼

Designing effective indexes involves examining existing index usage and query patterns to create and maintain indexing strategies that improve query efficiency and reduce latency in PostgreSQL and MySQL systems.

How do I adjust database configuration parameters for optimal memory and I/O?▼

You adjust database tuning configurations by modifying server parameters for memory, I/O, and concurrency settings based on tuning guidance, which maximizes throughput and minimizes query latency.

Does database query tuning work with both PostgreSQL and MySQL systems?▼

Yes, database query optimization supports both PostgreSQL and MySQL systems by providing detailed analysis and optimization strategies to enhance query speed and scalability across both platforms.

Why is my database report generation sluggish and how can I speed it up?▼

Sluggish database report generation is typically caused by query bottlenecks and inefficient indexing. You can speed it up by analyzing query plans, adding effective indexing, and fine-tuning server settings for faster response times.

Related Skills

Explore More Software Engineering Skills→
archibatearchibate
6

sql-optimization-patterns

Analyze EXPLAIN plans and recommend indexes for PostgreSQL and MySQL queries.

Community
Advanced
deadhearth01deadhearth01

supabase-postgres-best-practices

Analyze and optimize PostgreSQL performance using Supabase best practices.

Community
Advanced
januarfontijanuarfonti
10

database-design

Design schemas, indexes, migrations, and query optimizations for PostgreSQL, MySQL, and NoSQL databases.

Community
Advanced
vuralserhat86vuralserhat86
43

redis_expert

Optimize Redis data storage with caching strategies, Pub/Sub, and Streams.

Community
Intermediate