Tag: query-optimization

Type: All Skills Tools
Tags: mcp automation llm cli code-review unity typescript genomics game-development bioinformatics debugging documentation cloudbase ai-agents agentic-workflow devops llm-agent workflow-automation encode code-analysis
skill ★ 23

PostgreSQL Slow Query Diagnosis

Provides a systematic workflow for diagnosing and optimising slow PostgreSQL queries by analysing execution plans, index opportunities, and table statistics. It utilises pgtuner-mcp tools to identify resource-intensive queries and recommend…

isdaniel/pgtuner_mcp postgresql query-optimization database-performance mcp
skill ★ 23

PostgreSQL Query Optimization and Rewrite Patterns

This skill provides a structured workflow for analysing PostgreSQL execution plans and applying restructuring patterns to improve query performance. It covers techniques such as converting subqueries to joins, managing CTE materialisation, …

isdaniel/pgtuner_mcp postgresql query-optimization sql-performance database-tuning