Use This Skill

Put this line at the very top of your prompt: @mysql-php-fixer

Then describe your MySQL/PHP issue below it.

What This Skill Does

This skill handles MySQL database issues for PHP websites including:

• Connection Testing: Test remote MySQL connectivity and credentials
• Database Updates: Apply schema changes and migrations safely
• Performance Optimization: Optimize queries, indexes, and database configuration
• Security Fixes: Patch vulnerabilities and secure database access
• Backup & Recovery: Create backups before changes and restore if needed
• Error Resolution: Diagnose and fix common MySQL/PHP connection issues
• Version Compatibility: Handle MySQL version upgrades and PHP compatibility

Safety Features

• Backup First: Always creates database backups before modifications
• Test Environment: Validates changes in staging before production
• Rollback Support: Maintains rollback scripts for all changes
• Connection Verification: Tests connectivity before operations
• Change Logging: Records all modifications for audit trail

Common MySQL/PHP Tasks

Connection Issues

@mysql-php-fixer
Fix MySQL connection errors in PHP, test remote connectivity, update credentials

Database Updates

@mysql-php-fixer
Apply database schema updates, run migrations safely, update table structure

Performance Optimization

@mysql-php-fixer
Optimize slow queries, add missing indexes, tune MySQL configuration for PHP

Security Fixes

@mysql-php-fixer
Secure MySQL access, update credentials, patch vulnerabilities, fix SQL injection risks

Version Upgrade

@mysql-php-fixer
Upgrade MySQL version, ensure PHP compatibility, test application functionality

Requirements

• PHP 7.4+ or 8.x
• MySQL 5.7+ or 8.x
• Database admin credentials
• SSH access to server (for remote operations)
• Backup storage location

Output

Provides detailed reports on:

• Connection test results
• Database changes applied
• Performance improvements
• Security fixes implemented
• Backup locations and status
• Recommendations for ongoing maintenance