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.

Automates Neon serverless Postgres workflows via the Composio MCP, letting you list projects and branches, inspect databases, manage roles, and retrieve connection URIs for pipelines and tooling integrations.

This skill provides comprehensive guides and best practices for working with Neon Serverless Postgres. It covers initial setup, various connection methods (TCP, WebSockets), and advanced features like branching, autoscaling, and connection pooling. It offers detailed integration advice for Python, TypeScript, and other languages, making it essential for building scalable, modern database applications.

A comprehensive guide maintained by Supabase for optimizing Postgres performance. It provides critical rules and best practices across query performance, schema design, connection management, and security (including RLS). Use this skill when writing, reviewing, or optimizing complex SQL queries, database schemas, or configurations to ensure optimal database health and performance.