skills.rest
Axel-DaMage
Axel-DaMageCOMMUNITY
Explore all skills by this author →
GitHub

database-optimizer

Analyze and optimize PostgreSQL and MySQL database performance.

2|Updated Jun 29, 2026
Search Tags:#query performance#database optimization#database tuning#index optimization#slow query
One-click install
npx skills add https://github.com/Axel-DaMage/opencode-config --skill database-optimizer-axel-damage
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/Axel-DaMage/opencode-config/tree/main/skills/database-optimizer
Command: npx skills add https://github.com/Axel-DaMage/opencode-config --skill database-optimizer-axel-damage

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses the challenge of optimizing database performance, enabling users to identify and resolve issues such as slow queries, inefficient indexing, and configuration errors.

Core Features & Use Cases

  • Performance Analysis: Identifies slow queries and bottlenecks.
  • Query Optimization: Provides strategies for rewriting and refactoring queries for better performance.
  • Index Management: Recommends and creates indexes for optimal query execution.
  • Configuration Tuning: Assists in adjusting database settings for optimal performance.
  • Use Case: Imagine you have a PostgreSQL database experiencing slow query performance. Use this Skill to analyze the queries, recommend indexes, and adjust configuration settings to improve performance.

Quick Start

Run the 'analyze_queries' command with the database connection details to get a performance analysis report.

Frequently Asked Questions about database-optimizer

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

FAQPage Schema
How do I identify slow queries and optimize database performance in PostgreSQL?▼

To optimize database performance and identify slow queries in PostgreSQL, use this Skill to analyze query execution statistics, recommend index improvements, and tune configuration settings for better throughput. It connects directly to PostgreSQL clients to gather performance data.

Does this database optimization tool support MySQL as well as PostgreSQL?▼

Yes, this database optimization tool supports both MySQL and PostgreSQL systems. It uses mysql-connector-python and psycopg2 dependencies to execute queries, analyze slow performance bottlenecks, and gather statistics across both database platforms.

What's the best way to start tuning index optimization for slow query performance?▼

The best way to start index optimization for slow query performance is running the 'analyze_queries' command with your database connection details. This generates a performance analysis report identifying bottlenecks and recommending optimal indexes.

How does query optimization work for resolving database configuration errors?▼

Query optimization resolves database configuration errors by analyzing query execution plans and adjusting system settings. This Skill evaluates your current configuration, identifies inefficient indexing strategies, and provides tuning recommendations to improve overall query execution.

Do I need specific Python clients installed for database tuning and performance analysis?▼

Yes, you need specific Python clients installed for database tuning and performance analysis. This Skill requires psutil, psycopg2, and mysql-connector-python dependencies to execute queries, monitor system resources, and gather database statistics.

Why does my database experience slow query performance even with indexes configured?▼

Your database experiences slow query performance despite indexes due to inefficient indexing strategies or suboptimal configuration settings. This Skill analyzes query execution to identify bottlenecks, recommends index refactoring, and suggests configuration tuning to resolve performance issues.

Related Skills

Explore More Software Engineering Skills→
VXerysVXerys

database-optimizer

Analyze slow PostgreSQL and MySQL queries and generate index strategies.

Community
Advanced
thehivegroup-aithehivegroup-ai

postgres-standards

Manage PostgreSQL schema design, migrations, and query optimization with psycopg2.

Official
Intermediate
jeremylongshorejeremylongshore
2.6k

monitoring-database-health

Monitor PostgreSQL and MySQL database health with real-time metrics and alerts.

Community
Advanced
Serg28Serg28

database-optimizer

Analyze slow queries and design indexes for PostgreSQL and MySQL databases.

Community
Advanced