skills.rest
wojons
wojonsCOMMUNITY
Explore all skills by this author →
Website𝕏@WojonsTechGitHub

database-optimization

Analyze and optimize database queries, indexes, and schema configurations.

4|2|Updated Feb 26, 2026
Search Tags:#performance#indexing#database#optimization#sql#nosql#query tuning
One-click install
npx skills add https://github.com/wojons/skills --skill database-optimization-wojons
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: database-optimization
Source: https://github.com/wojons/skills/tree/main/skills/database-optimization
Command: npx skills add https://github.com/wojons/skills --skill database-optimization-wojons

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill addresses slow database performance, inefficient schema designs, and poorly optimized queries, ensuring your applications run smoothly and cost-effectively.

Core Features & Use Cases

  • Query Performance Analysis: Identifies and optimizes slow-running SQL and NoSQL queries.
  • Index Optimization: Analyzes and recommends improvements for database indexing strategies.
  • Schema Design: Provides guidance on optimizing database schema and normalization.
  • Configuration Tuning: Adjusts database parameters for peak performance.
  • Use Case: When your e-commerce site experiences slow load times during peak hours, this Skill can analyze query performance, identify missing indexes, and suggest configuration changes to speed up product searches and order processing.

Quick Start

Use the database-optimization skill to analyze and optimize the performance of your PostgreSQL database.

Frequently Asked Questions about database-optimization

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

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

To optimize slow database queries, this Skill analyzes query execution plans across PostgreSQL and MySQL, identifies missing indexes, and recommends schema design improvements to resolve performance bottlenecks.

Does this database optimization approach work with NoSQL systems like MongoDB and Cassandra?▼

Yes, this database optimization approach supports NoSQL systems including MongoDB, Cassandra, and Redis, providing detailed analysis and actionable recommendations for query tuning and configuration adjustments.

What is the best way to analyze and improve database indexing strategies?▼

The best way to improve database indexing is by analyzing existing indexes and query patterns to identify inefficiencies, then applying actionable recommendations for schema design and configuration tuning.

How do I tune database configuration parameters for peak performance during high traffic?▼

To tune database configuration for peak performance, this Skill analyzes suboptimal parameters and suggests configuration changes to handle high traffic loads, ensuring applications run smoothly and cost-effectively.

When do I need database schema design optimization for my e-commerce application?▼

You need database schema design optimization when your e-commerce site experiences slow load times during peak hours, which can be resolved by analyzing query performance and identifying missing indexes.

Related Skills

Explore More Software Engineering Skills→
v1bh0rv1bh0r

nw-query-optimization

Analyze execution plans and design indexes for SQL and NoSQL queries.

Community
Intermediate
safzanpiranisafzanpirani
1

supabase-postgres-best-practices

Optimize Postgres query performance with indexing and execution plan analysis.

Community
Advanced
giadaf-booshagiadaf-boosha
10

testing-patterns

Analyze application performance using established testing patterns and metrics.

Community
Advanced
Fantasia1999Fantasia1999

database-designer

Analyzes SQL DDL schemas and generates zero-downtime migration scripts.

Community
Advanced