Analyze EXPLAIN plans and optimize SQLAlchemy database performance bottlenecks.
npx skills add https://github.com/CybLow/pypaginate --skill perf-database
Please help me install this Agent Skill. Skill: perf-database Source: https://github.com/CybLow/pypaginate/tree/main/.opencode/skills/perf-database Command: npx skills add https://github.com/CybLow/pypaginate --skill perf-database
Database performance bottlenecks can throttle modern applications. This Skill provides a structured approach to analyze, tune, and optimize SQL workloads, connection pools, and ORM usage to improve latency and throughput.
Run perf-database to profile your app's database workload and generate optimization recommendations.
High-intent search queries and answers about installing and using this skill.
Optimize SQLAlchemy queries by using EXPLAIN analysis to identify execution plan bottlenecks, configuring connection pools, and applying batch operations to minimize N+1 query data access costs for lower latency.
Analyzing database performance bottlenecks involves profiling query workloads with EXPLAIN, tuning connection pool engine configuration, and optimizing data access patterns to maximize throughput in high-traffic web apps and microservices.
Fix N+1 query problems in ORM-heavy workloads by applying SQLAlchemy optimization patterns like batch operations and streaming large results, which minimize data access costs and reduce redundant database round-trips.
This database optimization approach works with both raw SQL workflows and ORM-heavy workloads, supporting EXPLAIN-based analysis, connection pooling configuration, and batch operations across SQLAlchemy-based apps and direct SQL interactions.
Tune connection pooling for database throughput when high-traffic web apps, data processing pipelines, or microservices experience latency throttling, requiring engine configuration adjustments to maximize connection reuse and overall throughput.
seb1nAnalyze EXPLAIN plans and rewrite slow SQL queries for better performance.
codeApe-7Analyze PostgreSQL and MySQL query performance and recommend index and configuration tuning.
garochee33Optimize PostgreSQL query performance, indexing, and migration safety in Drizzle ORM projects.
FabienDehopreOptimizes Entity Framework Core queries by analyzing SQL generation and reducing inefficient database access patterns.
