Skill UI

Automates database archival workflows by identifying historical records in PostgreSQL or MySQL, applying retention policies, and migrating data to archive tables or cold storage (S3/Azure Blob/GCS) with compression and compliance tracking.

Automates database archival workflows by identifying historical records in PostgreSQL or MySQL, applying retention policies, and migrating data to archive tables or cold storage (S3/Azure Blob/GCS) with compression and compliance tracking.

Automates database backups by generating compression/encryption scripts, scheduling cron jobs, and documenting restore procedures for PostgreSQL, MySQL, MongoDB, and SQLite whenever backup automation or disaster recovery planning is requested.

Automates database backups by generating compression/encryption scripts, scheduling cron jobs, and documenting restore procedures for PostgreSQL, MySQL, MongoDB, and SQLite whenever backup automation or disaster recovery planning is requested.

This SDK provides comprehensive programmatic management capabilities for Azure MySQL Flexible Server deployments using C# and the .NET framework. Developers can automate the entire database lifecycle, including server creation, database provisioning, configuring firewall rules, updating server parameters, and managing Entra ID administrators, all through Azure Resource Manager APIs. Ideal for DevOps pipelines and cloud infrastructure automation.

This skill provides comprehensive guidance on using LibreOffice Base for full-cycle database management. Users can create ODB databases, define schemas, manage tables, and establish relationships. It supports connecting to various external databases (MySQL, PostgreSQL, etc.), performing complex data operations, and automating professional reports and forms using SQL and Python scripting (UNO). Ideal for building data-driven applications.

Compares PostgreSQL or MySQL schemas using the database-diff-tool, produces transaction-safe migration scripts and rollback procedures, and outlines synchronization steps for staging/production deployments.

This skill automates the creation of comprehensive documentation for relational databases (PostgreSQL/MySQL). By introspecting live schemas, it extracts detailed metadata including table structures, column descriptions, primary/foreign key relationships, indexes, views, and stored procedures. The output provides a data dictionary, entity-relationship map, and schema statistics, crucial for knowledge transfer and database lifecycle management.

A comprehensive guide covering best practices for database migrations. It addresses schema changes, data migrations, and rollbacks for major databases (PostgreSQL, MySQL) and modern ORMs (Prisma, Drizzle, etc.). Learn how to implement safe, reversible, and zero-downtime schema updates for production environments.

Specializes in generating production-grade SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, and SQL Server. Provides comprehensive plans covering data integrity, detailed rollback procedures, performance optimization, and validation checks for critical schema changes.

Actionable guidance for analyzing plans, indexing, connection pooling, partitioning, and detecting N+1 queries to keep PostgreSQL and MySQL workloads fast and reliable.

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.