Skill UI

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 expert guidance for modern, multi-cloud database administration. It covers comprehensive knowledge across AWS, Azure, and GCP platforms, spanning relational, NoSQL, and graph databases. Key areas include Infrastructure as Code (Terraform, Flyway), achieving high availability, disaster recovery, advanced performance optimization, and ensuring strict regulatory compliance (HIPAA, GDPR). It is essential for managing complex, highly reliable cloud data architectures.

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.

A comprehensive, multi-phase workflow for developing professional WordPress plugins. Covers foundational architecture, hooks, admin UI, database design, and REST API implementation. Crucially, it incorporates advanced WordPress 7.0 features, including Real-Time Collaboration (RTC) compatibility, AI Connector integration (OpenAI, Claude, etc.), and the Abilities API, ensuring modern, scalable, and secure plugins.

This guide details how to use Shopify Metafields and Metaobjects via the GraphQL Admin API. Metafields allow attaching key-value custom data to existing resources (like products or orders), while Metaobjects enable defining entirely new, structured content types. Together, they provide a powerful way for developers to model complex custom data, often eliminating the need for external databases to extend e-commerce functionality.

Manage Azure MySQL Flexible Server deployments with the .NET Resource Manager SDK: create servers, databases, firewall rules, tune configurations, and set up Entra ID admins.

Manage Azure Database for PostgreSQL Flexible Server using the .NET Resource Manager SDK. Create servers and databases, configure firewall rules, settings, backups, and Entra ID administrators.

This skill covers provisioning and managing Azure SQL Database and Cosmos DB instances. It includes configuring security settings, setting up backups, and implementing geo-replication strategies. Users will learn to create servers, databases, and elastic pools using Azure CLI commands. It also addresses firewall rules, network security, failover groups, and performance tuning for production environments. Ideal for DevOps engineers and cloud administrators deploying managed databases on Azure.

This skill covers expert-level database administration for modern cloud environments. It includes managing AWS, Azure, and Google Cloud databases, implementing Infrastructure as Code, ensuring high availability and disaster recovery, optimizing performance, and securing data. Suitable for automating maintenance, handling migrations, and managing containerized databases.

Implement comprehensive automated database backup strategies for PostgreSQL, MySQL, and MongoDB. Configure retention policies, schedule backups using cron or systemd, and upload to S3-compatible storage. Includes scripts for logical and physical backups, point-in-time recovery, and disaster recovery testing. Essential for DevOps and database administration roles to ensure data safety and business continuity.

Administer, optimize, and secure MongoDB NoSQL databases in development and production. Covers installation, user setup, CRUD operations, indexing, aggregation pipelines, replica sets, and backup/restore.

Administer and optimize MySQL/MariaDB databases in production environments. Covers installation, configuration tuning, security hardening, backup strategies using mysqldump or XtraBackup, and source-replica replication setup. Essential for managing relational database deployments and ensuring high availability.