database-advanced-optimization
CommunitySupercharge database performance, eliminate bottlenecks.
Data & Analytics#caching#indexing#database#optimization#sql#nosql#performance-tuning#data-analytics#query-tuning
Authorwilliamzujkowski
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This skill provides advanced techniques to optimize database performance, eliminating bottlenecks and ensuring your applications run at peak efficiency. It automates the process of identifying slow queries, implementing effective indexing, and configuring connection pooling, saving you countless hours of manual tuning.
Core Features & Use Cases
- Query Tuning: Guides on rewriting inefficient SQL queries for faster execution.
- Indexing Strategies: Teaches how to design and implement optimal indexes for various workloads.
- Connection Pooling: Provides configurations and scripts for tools like PgBouncer to manage database connections efficiently.
- Use Case: Analyze a slow PostgreSQL query using the provided profiling script, then use the skill to suggest optimal indexes and query rewrites to drastically improve its performance.
Quick Start
Generate a PostgreSQL query optimization script, including common indexing and query rewrite suggestions.
Dependency Matrix
Required Modules
None requiredComponents
scripts
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: database-advanced-optimization Download link: https://github.com/williamzujkowski/standards/archive/main.zip#database-advanced-optimization Please download this .zip file, extract it, and install it in the .claude/skills/ directory.