Back to Skills
Skill

azure-database-mysql

Expert knowledge for Azure Database for MySQL development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when building, debugging, or optimizing Azure Database for MySQL applications. Not for Azure Database for MariaDB (use azure-database-mariadb), Azure Database for PostgreSQL (use azure-database-postgresql), Azure SQL Database (use azure-sql-database), SQL Server on Azure Virtual Machines (use azure-sql-virtual-machines).

From azure
Install
1
Run in your terminal
$
npx claudepluginhub atc-net/atc-agentic-toolkit --plugin azure
Tool Access

This skill uses the workspace's default tool permissions.

Skill Content

Azure Database for MySQL Skill

This skill provides expert guidance for Azure Database for MySQL. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick-reference content with remote documentation fetching capabilities.

How to Use This Skill

IMPORTANT for Agent: This file may be large. Use the Category Index below to locate relevant sections, then use read_file with specific line ranges (e.g., L136-L144) to read the sections needed for the user's question This skill requires network access to fetch documentation content. Use mcp_microsoftdocs:microsoft_docs_fetch to retrieve full articles.

  • Fallback: Use the built-in WebFetch tool if the Microsoft Learn MCP server is not available.

Category Index

CategoryLinesDescription
TroubleshootingL37-L53Diagnosing and fixing MySQL Flexible Server issues: connectivity, performance (CPU/memory/queries), errors, corruption, capacity, replication lag, CLI problems, and using logs/self-heal tools
Best PracticesL54-L71Best practices for monitoring, performance tuning, troubleshooting, safe operations, BCDR, and end-to-end migration/optimization for Azure Database for MySQL Flexible Server
Decision MakingL72-L88Guidance on sizing, HA/BCDR, performance features, and planning/choosing methods for migrating and upgrading MySQL workloads to Azure Database for MySQL Flexible Server
Architecture & Design PatternsL89-L98Patterns for connecting AKS to MySQL Flexible Server, designing backup/restore, data-in/out replication, high availability (zone-redundant), and read-replica-based scaling.
Limits & QuotasL99-L107Limits, quotas, and performance caps for MySQL Flexible Server: compute/storage/IOPS limits, quota increase process, restore retention limits, and stop/start duration constraints.
SecurityL108-L134Securing Azure Database for MySQL Flexible Server: network isolation (Private Link, firewalls), TLS and cert rotation, encryption, Entra auth, users, and audit logging before/after migration.
ConfigurationL135-L165Configuring MySQL Flexible Server: parameters, HA, networking (VNet/firewall), replication, logs/slow queries, monitoring/metrics, alerts, scaling, maintenance, backups, and read replicas.
Integrations & Coding PatternsL166-L176Connecting to Azure Database for MySQL Flexible Server via CLI, Java/JDBC, Power BI, managing connection strings with Key Vault, and migrating data from RDS, on-prem, VMs, or Workbench
DeploymentL177-L187Automating MySQL Flexible Server deployments and maintenance: CI/CD with Azure Pipelines/GitHub Actions, backups/geo-restore, major version upgrades, and scheduled/automated management tasks.

Troubleshooting

TopicURL
Use MySQL Flexible Server error logs for troubleshootinghttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-error-logs
Resolve database corruption in Azure MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-fix-corrupt-database
Use self-heal to automatically repair MySQL flexible server issueshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-self-heal
Troubleshoot Azure CLI issues for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-cli-errors
Diagnose and fix MySQL flexible server connection issueshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-connection-issues
Troubleshoot common migration and usage errors in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-common-errors
Troubleshoot connectivity issues and connection handling in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-connectivity-issues
Troubleshoot high CPU utilization in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-high-cpu-utilization
Troubleshoot low memory issues in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-low-memory-issues
Troubleshoot query performance issues in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-query-performance-new
Resolve capacity errors when deploying or scaling MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/resolve-capacity-errors
Use Query Performance Insight to diagnose Azure MySQL querieshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-query-performance-insights
Troubleshoot replication latency on MySQL flexible server read replicashttps://learn.microsoft.com/en-us/azure/mysql/how-to-troubleshoot-replication-latency

Best Practices

TopicURL
Implement monitoring best practices for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-monitor-best-practices
Apply operational best practices for Azure Database for MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-operation-excellence-best-practices
Run performance benchmarks on Azure MySQL flexible server effectivelyhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-perf-benchmark-best-practices
Optimize performance of Azure MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-performance-best-practices
Use Azure Monitor and Advisor for MySQL business continuityhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity-advisor-monitor
Apply troubleshooting best practices for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-troubleshooting-best-practices
Prevent and recover accidental deletion of MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-prevent-recover-accidental-delete
Restart Azure MySQL Flexible Server safely via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restart-server-portal
Profile and optimize MySQL flexible server queries using EXPLAINhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-query-performance
Use sys_schema to diagnose performance issues in MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-troubleshoot-sys-schema
Execute data migration from on-premises MySQL to Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/08-data-migration
Manage Azure Database for MySQL after migrationhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/10-post-migration-management
Optimize Azure Database for MySQL performance after migrationhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/11-optimization
Design BCDR for Azure Database for MySQL migrationshttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/12-business-continuity-and-disaster-recovery

Decision Making

TopicURL
Choose and purchase MySQL Flexible Server reserved capacityhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concept-reserved-pricing
Use accelerated logs for high-performance MySQL workloadshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-accelerated-logs
Plan business continuity for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-business-continuity
High availability FAQ and choices for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-high-availability-faq
Select MySQL Flexible Server service tiers and storagehttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-service-tiers-storage
Perform minimal-downtime MySQL migration to Azure flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-migrate-online
Decide and plan major version upgrades for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade-faq
Use mydumper/myloader to migrate large MySQL databases to Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/concepts-migrate-mydumper-myloader
Plan and execute on-premises MySQL migration to Azure Database for MySQLhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/01-mysql-migration-guide-intro
Assess on-premises MySQL for migration to Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/03-assessment
Plan Azure Database for MySQL migration landing zonehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/04-planning
Choose migration methods to Azure Database for MySQLhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/05-migration-methods
Establish performance baselines for MySQL migration to Azurehttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/07-performance-baselines

Architecture & Design Patterns

TopicURL
Connect Azure Kubernetes Service to MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-aks
Backup and restore strategy for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-backup-restore
Design data-in replication into MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-data-in-replication
Design data-out replication from MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-data-out-replication
Design zone-redundant high availability for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-high-availability
Use read replicas to scale MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-read-replicas

Limits & Quotas

TopicURL
Service limitations for Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-limitations
Storage IOPS performance characteristics for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-storage-iops
Request quota increases for Azure MySQL flexible server resourceshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-request-quota-increase
Restore deleted Azure MySQL flexible servers within retention limitshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-dropped-server
Restart, stop, and start MySQL flexible server with stop-duration limitshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-restart-stop-start

Security

TopicURL
Use Private Link with Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-private-link
Configure public network access for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-public
Configure private network access for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-networking-vnet
Configure Azure MySQL Private Link using Azure CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-azure-cli
Deny public network access for Azure MySQL via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-deny-public-access
Secure Azure MySQL with Private Link using portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-networking-private-link-portal
Create and connect to MySQL Flexible Server with private accesshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-create-connect-server-vnet
Configure audit logging for MySQL flexible server via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-audit-logs
Use customer-managed keys for MySQL Flexible Server encryptionhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-customer-managed-key
Understand Microsoft Entra authentication for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-entra-authentication
Create and manage MySQL Flexible Server users securelyhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-create-users
Configure data encryption for MySQL Flexible Server using Azure CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-data-encryption-cli
Configure data encryption for MySQL Flexible Server in Azure portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-data-encryption-portal
Set up Microsoft Entra authentication for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-entra
Manage MySQL Flexible Server firewall rules via Azure CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-manage-firewall-cli
Manage MySQL Flexible Server firewall rules in Azure portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-how-to-manage-firewall-portal
Secure Azure Database for MySQL Flexible Server deploymentshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-overview
TLS requirements and configuration for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls
Connect securely to MySQL Flexible Server using TLShttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-how-to-connect
Handle root certificate rotation for Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-root-certificate-rotation
FAQ on root certificate rotation for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/security-tls-root-certificate-rotation-faq
Configure and analyze audit logs for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-configure-audit
Secure Azure Database for MySQL during and after migrationhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/13-security

Configuration

TopicURL
Use built-in stored procedures in MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-built-in-store-procedure
Configure monitoring and alerts for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-monitor-mysql
Monitoring metrics and logs reference for MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-monitor-mysql-reference
Configure MySQL Flexible Server parameters effectivelyhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-server-parameters
Set up metric-based alerts for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-alert-on-metric
Enable or disable zone redundant high availability via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-high-availability
Configure zone redundant high availability for Azure MySQL via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-high-availability-cli
Configure MySQL flexible server parameters via Azure CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-server-parameters-cli
Configure MySQL Flexible Server parameters in Azure portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-configure-server-parameters-portal
Configure data-in replication into Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-data-in-replication
Configure data-out replication from Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-data-out-replication
Configure scheduled maintenance windows for Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-maintenance-portal
Configure private VNet connectivity for Azure MySQL via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-manage-virtual-network-cli
Configure private VNet connectivity for Azure MySQL via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-manage-virtual-network-portal
Create and manage Azure MySQL read replicas using CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-read-replicas-cli
Create and manage Azure MySQL read replicas via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-read-replicas-portal
List and download Azure MySQL server logs using CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-server-logs-cli
Enable and download Azure MySQL server logs via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-server-logs-portal
List and modify MySQL flexible server parameters via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-change-server-parameters
Create MySQL flexible server with VNet private access via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-create-connect-private-access
Configure public access and firewall for MySQL flexible server via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-create-connect-public-access
Monitor and scale MySQL flexible server compute, storage, and IOPShttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-monitor-and-scale
Create and manage MySQL flexible server read replicas via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-read-replicas
Restore Azure MySQL flexible server to a point in time via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-restore-server
Configure same-zone high availability for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-same-zone-ha
Configure slow query logging for MySQL flexible server via CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-slow-query-logs
Configure zone-redundant high availability for MySQL flexible serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/scripts/sample-cli-zone-redundant-ha

Integrations & Coding Patterns

TopicURL
Use Azure CLI commands to connect to MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-azure-cli
Connect Java applications to MySQL Flexible Server with JDBChttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-java
Connect Azure MySQL Flexible Server to Power BI Desktophttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/connect-with-powerbi-desktop
Migrate Amazon RDS MySQL to Azure flexible server using data-in replicationhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-migrate-rds-mysql-data-in-replication
Store MySQL Flexible Server connection strings in Azure Key Vaulthttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/tutorial-add-mysql-connection-in-key-vault
Migrate on-premises or VM MySQL to Azure flexible server using Import CLIhttps://learn.microsoft.com/en-us/azure/mysql/migrate/migrate-external-mysql-import-cli
Migrate MySQL data to Azure using MySQL Workbenchhttps://learn.microsoft.com/en-us/azure/mysql/migrate/mysql-on-premises-azure-db/09-data-migration-with-mysql-workbench

Deployment

TopicURL
Configure Azure Pipelines task for Azure MySQL deploymentshttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/azure-pipelines-deploy-database-task
Plan for scheduled maintenance on MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-maintenance
Create Azure Automation tasks for MySQL Flexible Server managementhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/create-automation-tasks
Move Azure MySQL Flexible Server between regions using geo-restorehttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-move-regions
Restore Azure MySQL Flexible Server from backup using CLIhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-cli
Restore Azure MySQL Flexible Server from backup via portalhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-restore-server-portal
Perform major version upgrades for Azure MySQL Flexible Serverhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/how-to-upgrade
Use GitHub Actions to deploy changes to Azure MySQLhttps://learn.microsoft.com/en-us/azure/mysql/flexible-server/quickstart-mysql-github-actions
Similar Skills
Stats
Parent Repo Stars0
Parent Repo Forks1
Last CommitMar 19, 2026
Actions
View SourceView PluginView on GitHubView README