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.

Provides Node.js/TypeScript guidance for connecting to Azure Database for PostgreSQL Flexible Server with the pg package, covering password and Microsoft Entra ID auth, pool management, parameterized queries, and transaction helpers.

Azure Resource Manager SDK for .NET that automates deployment and management of PostgreSQL Flexible Server instances, including server creation, databases, firewall rules, and configuration tuning within Azure subscriptions.

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.

Automates generating Markdown data dictionaries and ER summaries by introspecting PostgreSQL/MySQL schemas, capturing tables, columns, constraints, indexes, views, stats, and stored procedures for up-to-date documentation.

Capture production-grade migration workflows, rollback safeguards, and tooling tips (PostgreSQL, Prisma, Drizzle, Django, TypeORM, golang-migrate) to evolve schemas and data safely without disrupting live traffic.

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.