Tag: sql-tuning

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 Index Analysis and Optimization

This skill provides a comprehensive workflow for PostgreSQL index optimisation, including identifying unused or duplicate indexes, detecting bloat, and recommending new indexes. It leverages HypoPG for hypothetical index testing to estimate…

isdaniel/pgtuner_mcp postgresql index-optimisation database-performance mcp