database_optimization_guide
Practical strategies for PostgreSQL query optimization, indexing, and performance tuning.
Content Preview
# Database Optimization Guide Practical strategies for PostgreSQL query optimization, indexing, and performance tuning. ## Guide Index 1. [Query Analysis with EXPLAIN](#1-query-analysis-with-explain) 2. [Indexing Strategies](#2-indexing-strategies) 3. [N+1 Query Problem](#3-n1-query-problem) 4. [Connection Pooling](#4-connection-pooling) 5. [Query Optimization Patterns](#5-query-optimization-patterns) 6. [Database Migrations](#6-database-migrations) 7. [Monitoring and Alerting](#7-monitoring-
How to Use
Recommended: Install to project (local)
mkdir -p .claude/skills
curl -o .claude/skills/database_optimization_guide.md \
https://raw.githubusercontent.com/alirezarezvani/claude-skills/main/engineering-team/senior-backend/references/database_optimization_guide.mdSkill is scoped to this project only. Add .claude/skills/ to your .gitignoreif you don't want to commit it.
Alternative: Clone full repo
git clone https://github.com/alirezarezvani/claude-skillsThen reference at engineering-team/senior-backend/references/database_optimization_guide.md
Related Skills
cs-engineering-lead
Engineering Team Lead agent for coordinating QA, security, data engineering, ML, and frontend/backend teams. Orchestrates engineering-team skills for team-level technical decisions. Spawn when users need team coordination, tech stack evaluation, incident response, or cross-functional engineering work.
agentsengineeringleadagent
by alirezarezvani · alirezarezvani-claude-skills
data
Data engineering for Apache Airflow and Astronomer. Author DAGs with best practices, debug pipeline failures, trace data lineage, profile tables, migrate Airflow 2 to 3, and manage local and cloud deployments.
pluginpluginmarketplacedata
by Anthropic · anthropic-official-plugins
feature_engineering_patterns
World-class feature engineering patterns for senior data scientist.
engineering-teamfeatureengineeringpatterns
by alirezarezvani · alirezarezvani-claude-skills
data-engineering
Data engineering patterns for ETL pipelines, data warehousing, Apache Spark, and data quality validation
data-engineeringdataengineering
by rohitg00 · awesome-claude-toolkit