database-optimizer

Name: database-optimizer
Availability: InStock
Author: marwan78888

Optimize PostgreSQL and MySQL performance with EXPLAIN ANALYZE validation.

16|Updated Apr 19, 2026

Search Tags:#performance #indexing #database #postgresql #optimization #mysql #execution-plan

Ready to run

npx skills add https://github.com/Marwan78888/Neuron-Cli --skill database-optimizer-marwan78888

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/Marwan78888/Neuron-Cli/tree/main/scratch/claude-skills-main/skills/database-optimizer
Command: npx skills add https://github.com/Marwan78888/Neuron-Cli --skill database-optimizer-marwan78888

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Optimizes database queries and improves performance across PostgreSQL and MySQL systems.

Core Features & Use Cases

Analyzing slow queries and execution plans
Designing indexes and partitioning strategies
Tuning database configuration and memory usage
Reducing lock contention and deadlocks
Monitoring performance and validating improvements
Use Case: Improve report generation speed by redesigning indexes and adjusting planner settings on a large legacy schema

Quick Start

Run a baseline performance assessment, implement incremental optimizations, and validate results with EXPLAIN ANALYZE.

Frequently Asked Questions about database-optimizer

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

FAQPage Schema

How do I optimize slow database queries using execution plans in PostgreSQL?▼

Database query optimization is achieved through structured slow-query analysis and EXPLAIN ANALYZE validation. This Skill enforces reproducible, benchmark-driven changes by guiding index design and configuration tuning incrementally to ensure measurable performance improvement.

What's the best way to design indexes and partitioning strategies for a large legacy schema?▼

The best way to design indexes is through incremental validation with safety checks. This Skill guides index design and partitioning strategies to reduce lock contention, validating improvements with EXPLAIN ANALYZE to ensure benchmark-driven changes across PostgreSQL and MySQL.

Can I tune database configuration and memory usage across both MySQL and PostgreSQL?▼

Yes, database configuration tuning is supported for both PostgreSQL and MySQL. This Skill guides memory usage adjustments and planner setting modifications, enforcing reproducible, benchmark-driven changes validated with EXPLAIN ANALYZE across development, staging, and production environments.

Why does my database optimizer require baseline performance assessments before making changes?▼

Database optimization requires baseline assessments to enforce reproducible, benchmark-driven changes. This Skill mandates incremental validation and safety checks, using EXPLAIN ANALYZE to ensure measurable performance improvement and prevent regressions across development, staging, and production environments.

When do I need to use EXPLAIN ANALYZE for database performance tuning?▼

You need EXPLAIN ANALYZE for database performance tuning when validating incremental optimizations. This Skill enforces benchmark-driven changes and safety checks by analyzing execution plans, ensuring measurable improvement during slow-query analysis and index design across PostgreSQL and MySQL systems.