isdaniel

Detects and remediates table and index bloat in PostgreSQL using pgstattuple analysis. Identifies fragmentation, dead tuples, and wasted space with prioritized maintenance actions including VACUUM, REINDEX, and pg_repack recommendations.

Guides PostgreSQL configuration tuning based on hardware profile, workload type, and current settings. Covers memory, WAL, checkpoints, autovacuum, planner, and connection settings with specific ALTER SYSTEM recommendations. Teaches the agent to use review_settings with individual categories and understand restart vs reload requirements.

Analyzes PostgreSQL connection utilization patterns including active, idle, and idle-in-transaction sessions. Diagnoses connection leaks, saturation, and provides PgBouncer pooling recommendations. Guides the agent to use get_active_queries with targeted filters and health resources for connection monitoring.

Performs comprehensive PostgreSQL database health assessments covering connections, cache performance, locks, replication, wait events, active queries, and configuration review. Produces a scored health report with prioritized recommendations.

Performs comprehensive PostgreSQL index optimization including unused index cleanup, duplicate detection, missing index recommendations, and hypothetical index testing with HypoPG. Provides actionable CREATE/DROP INDEX statements with estimated impact.

Deep-dive investigation of PostgreSQL I/O patterns using targeted analysis types (buffer pool, tables, indexes, temp files, checkpoints). Covers pg_stat_io for PG16+, correlates I/O patterns with slow queries, and guides diagnosis of cache misses, temp file spills, and checkpoint storms.

Diagnoses PostgreSQL lock contention including blocking lock chains, deadlock patterns, idle-in-transaction problems, and wait event analysis. Guides the agent through identifying blockers, understanding lock types, and recommending transaction and configuration changes.

Generates a comprehensive PostgreSQL performance baseline report capturing health metrics, query workload patterns, table statistics, configuration settings, index utilization, and I/O patterns. Designed for before/after comparison when making changes.

Find high-value SEO keywords: search volume, difficulty, intent classification, topic clusters. 关键词研究/内容选题

Create a new blog post for this Hexo blog. Handles research, writing, frontmatter metadata, and file placement in source/_posts/. Use when the user wants to write, draft, or create a new blog post or article. Supports topics like Rust, PostgreSQL, C#, system design, databases, and any technical subject. Can research via web if a URL or topic is provided.

Orchestrate an automatic code↔review loop using two SEPARATE sub-agents — one writes code and tests, a different one reviews and scores it — iterating until the reviewer approves or a round budget is exhausted. Use this whenever the user wants code written with independent review, mentions "code review agent", "review loop", asks for "code with review", wants a coding agent and review agent to collaborate, asks to "implement with review", or describes a workflow where coding and review must be done by different agents. Even if the user just says "implement X carefully" or "implement X and double-check it", strongly consider this skill — it produces higher-quality code than a single agent reviewing its own work.