Tag: performance-tuning
Systematic OpenClaw Test and Runtime Optimization
This skill guides developers through systematically optimizing OpenClaw's test suite and runtime performance while maintaining full coverage. It involves establishing performance baselines, identifying hotspots like expensive imports or fix…
PostgreSQL Database Health Check
Performs a comprehensive health assessment of PostgreSQL databases by evaluating connections, cache performance, locks, and configuration settings. It generates a scored report with prioritised recommendations and actionable remediation ste…
PostgreSQL Connection Usage Analysis
This skill enables the analysis of PostgreSQL connection patterns to diagnose leaks, saturation, and idle session overhead. It provides actionable recommendations for connection pooling and configuration optimisation using MCP resources and…
PostgreSQL Configuration Tuning and Optimization
Provides systematic PostgreSQL configuration tuning by analysing hardware profiles, workload types, and current settings to generate hardware-aware ALTER SYSTEM recommendations.
PostgreSQL Table and Index Bloat Analysis
This skill provides a workflow for detecting and remediating table and index bloat in PostgreSQL databases. It identifies fragmentation, dead tuples, and wasted space, recommending specific maintenance actions such as VACUUM, REINDEX, or pg…
.NET Memory Profiling and Leak Detection
An agentic skill to analyse .NET application memory usage and identify leaks. It leverages dotMemory to capture snapshots, compare states, and suggest actionable code fixes.