Skill UI

A specialized skill for optimizing database performance and scalability across PostgreSQL and MySQL. It guides users through analyzing slow queries, interpreting execution plans (EXPLAIN ANALYZE), designing optimal indexing strategies, tuning configuration parameters, and resolving bottlenecks like lock contention. Essential for DevOps engineers, database administrators, and backend developers.

Comprehensive guide for setting up a complete local development stack for Documenso integrations. It covers project structure, environment variable configuration, running self-hosted services using Docker (PostgreSQL, MailHog), and implementing utility scripts for connection verification and test data cleanup.

Guide for designing, implementing, and scaling event stores in event-sourced systems, covering requirements, technology comparisons, PostgreSQL schemas, and Python persistence patterns.

Manages FairDB PostgreSQL backups via pgBackRest and Wasabi S3, automating scheduling, integrity verification, PITR restores, monitoring, and compliance reporting for resilient disaster recovery.

Generates production-ready stored procedures, functions, and triggers for PostgreSQL, MySQL, or SQL Server by analyzing requirements, using the stored-procedure-generator plugin, and returning optimized SQL code for complex logic, integrity, and transaction safety.

Manages database schema migrations by generating timestamped up/down scripts for PostgreSQL, MySQL, SQLite, or MongoDB, letting you create, apply, or rollback changes safely when handling schema updates.

Automates database replication tasks with the database-replication-manager plugin, covering setup, failover, lag monitoring, and read scaling for PostgreSQL/MySQL clusters.

This comprehensive skill manages the entire lifecycle of database testing, ensuring data integrity and system reliability. It covers setting up isolated test environments (using Docker or in-memory databases), executing migrations, and implementing robust test isolation strategies (such as transaction rollback). Use cases include verifying CRUD operations, validating referential constraints, performance benchmarking (EXPLAIN ANALYZE), and ensuring backward compatibility across multiple databases (PostgreSQL, MySQL, MongoDB) and ORMs.

Monitors PostgreSQL and MySQL health with real-time metrics, predictive alerts, and automated remediation, letting you preempt bottlenecks and respond to production issues quickly.

Provides PostgreSQL optimization advice covering index design, query plan inspection, partitioning, JSONB tweaks, connection pooling, and tuning checkpoints to stabilize OLTP workloads.

Quick reference of PostgreSQL best practices covering indexing cheatsheets, data type choices, security policies, and configuration templates to guide optimization and troubleshooting workflows.

This skill provides comprehensive expertise for senior database administrators to optimize and manage PostgreSQL databases at an advanced level. Use it for deep query analysis via EXPLAIN ANALYZE, implementing advanced features like JSONB indexing, configuring streaming or logical replication, and maintaining database health through VACUUM tuning and monitoring pg_stat views. Ideal for building highly available, high-performance, and resilient system architectures.