skills.rest
williamzujkowski
williamzujkowskiCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

Database Optimization Analyzer

Analyze SQL and NoSQL queries, indexing, and schema design for PostgreSQL, MySQL, MongoDB, and Redis.

6|Updated Oct 25, 2025
Search Tags:#performance#indexing#database#postgresql#optimization#mongodb#query-tuning
One-click install
npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill database-optimization-analyzer
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: Database Optimization Analyzer
Source: https://github.com/williamzujkowski/cognitive-toolworks/tree/main/skills/database-optimization-analyzer
Command: npx skills add https://github.com/williamzujkowski/cognitive-toolworks --skill database-optimization-analyzer

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Database performance often drags down applications due to slow queries, missing indexes, and poorly designed schemas across SQL and NoSQL systems.

Core Features & Use Cases

  • Query-plan analysis and index recommendations for PostgreSQL, MySQL, MongoDB, and Redis.
  • Schema design review, denormalization guidance, and implementation planning for production systems.
  • End-to-end optimization workflow from discovery to actionable changes.

Quick Start

Provide a targeted optimization pass on your database cluster to accelerate queries and improve schema design.

Frequently Asked Questions about Database Optimization Analyzer

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

FAQPage Schema
How do I analyze and optimize slow PostgreSQL or MongoDB queries?▼

To optimize slow PostgreSQL or MongoDB queries, you analyze query text, execution plans, and schema definitions. This identifies missing indexes and schema flaws to deliver actionable performance improvements.

What database performance metrics are needed for query tuning?▼

Query tuning requires structured input data including the specific query text, database type, optional execution plans, and schema definitions to produce precise, prioritized optimization recommendations.

Does database optimization work for both OLTP and OLAP systems?▼

Database optimization applies to production databases across PostgreSQL, MySQL, MongoDB, and Redis in both OLTP and OLAP contexts for small and large-scale systems to accelerate queries.

What is the best way to review schema design for database performance?▼

The best way to review schema design for database performance is analyzing denormalization guidance and implementation planning alongside query plan analysis to ensure production databases operate at peak performance.

Can I use this approach to tune Redis workloads?▼

Yes, you can tune Redis workloads alongside SQL and NoSQL databases. The optimization process analyzes queries, indexing, and schema design to deliver actionable performance improvements for Redis production systems.

Related Skills

Explore More Software Engineering Skills→
XSpoonAiXSpoonAi
17

Database Operations Manager

Analyze SQL/NoSQL queries and generate optimization recommendations with structured JSON output.

Official
Advanced
2025Emma2025Emma
22.7k

postgresql

Provide PostgreSQL development and administration guidance for SQL, schemas, and performance tuning.

Community
Advanced
v1bh0rv1bh0r

nw-query-optimization

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

Community
Intermediate
samChang72samChang72
1

database-specialist

Analyze and optimize SQL database queries with EXPLAIN ANALYZE and indexing strategies.

Community
Intermediate