database-optimizer

Analyze queries, indexes, and configurations to optimize database performance.

Updated Feb 24, 2026

Search Tags:#performance #caching #indexing #database #partitioning #optimize #query-tuning

Ready to run

npx skills add https://github.com/chicanoandres702/SentientAIBrowser --skill database-optimizer-chicanoandres702

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: database-optimizer
Source: https://github.com/chicanoandres702/SentientAIBrowser/tree/main/.agents/workflows/database-optimizer
Command: npx skills add https://github.com/chicanoandres702/SentientAIBrowser --skill database-optimizer-chicanoandres702

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill identifies and eliminates database performance bottlenecks across systems, enabling scalable, cost-efficient data access and smoother user experiences.

Core Features & Use Cases

Advanced Query Optimization: Analyze execution plans, rewrite queries, and optimize complex patterns across relational and NoSQL databases.
Modern Indexing & Partitioning: Design and maintain effective indexing strategies and partition schemes to reduce latency and improve throughput.
Performance Monitoring & Migration: Establish baselines, monitor regressions, and plan zero-downtime migrations for large-scale deployments.
Caching Architectures: Implement multi-tier caching to drastically reduce repetitive query loads and latency.
Cloud & Cross-Database Tuning: Optimize for cloud-native databases and cross-database workloads with scalable architectures.

Quick Start

Provide a comprehensive database optimization plan for a PostgreSQL deployment with slow queries and table bloat.

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 PostgreSQL queries and reduce table bloat?▼

To optimize slow PostgreSQL queries, analyze execution plans, rewrite complex patterns, and apply indexing strategies. Reducing table bloat involves partitioning schemes and configuration tuning to improve throughput and lower latency for scalable data access.

When do I need database partitioning and multi-tier caching for my production system?▼

Database partitioning and multi-tier caching are needed when production systems experience high latency and repetitive query loads. Implementing these architectures drastically reduces latency and scales data access efficiently across OLTP and OLAP workloads.

Can I use database query tuning for both single-node and distributed cloud databases?▼

Yes, database query tuning applies to systems ranging from single-node PostgreSQL deployments to distributed cloud databases. It optimizes cross-database workloads and cloud-native configurations for scalable architectures and smoother user experiences.

What is the best way to plan zero-downtime database migrations for large-scale deployments?▼

The best way to plan zero-downtime database migrations is establishing performance baselines and monitoring regressions. This approach ensures scalable data access during large-scale deployment transitions without interrupting user experiences.

Why does my database performance bottleneck during OLAP workloads and how do I fix it?▼

Database performance bottlenecks during OLAP workloads often stem from poor indexing or inefficient queries. Fix them by analyzing execution plans, maintaining effective indexing strategies, and implementing partition schemes to improve throughput.