SkillsAdd

smithery/mirxa27

mysql-php-fixer

Update and fix remote MySQL for PHP websites

Installation

$ npx skills add smithery/mirxa27 --skill mysql-php-fixer
View on skills.sh ↗ Website ↗

Similar popular skills

Related neighbors and high-traction skills in the same topics — useful to compare before installing.

azure-storage Same topic
microsoft/azure-skills

Azure Storage Services including Blob Storage, File Shares, Queue Storage, Table Storage, and D…

567.1K installs
azure-kusto Same topic
microsoft/azure-skills

Query and analyze data in Azure Data Explorer (Kusto/ADX) using KQL for log analytics, telemetr…

566.2K installs
supabase-postgres-best-practices Same topic
supabase/agent-skills

Postgres best practices maintained by Supabase, for Postgres running anywhere. Load this skill …

391.6K installs
prisma-database-setup Same topic
prisma/skills

Guides for configuring Prisma with different database providers (PostgreSQL, MySQL, SQLite, Mon…

269.8K installs
prisma-client-api Same topic
prisma/skills

Prisma Client API reference covering model queries, filters, operators, and client methods. Use…

269.3K installs
prisma-cli Same topic
prisma/skills

Prisma ORM CLI commands reference covering init, generate, migrate, db, dev, complete, studio, …

267K installs
More details

Agent compatibility

Declared targets from SKILL.md / docs. Unmarked agents are not listed — the skill may still install via the CLI.

Claude Code Not declared
Cursor Not declared
Codex Not declared
GitHub Copilot Not declared
Windsurf Not declared
Gemini CLI Not declared
Cline Not declared
OpenCode Not declared

Package contents

Files included with this skill beyond the listing page.

  • skill md SKILL.md 2,266 B
  • docs SUMMARY.md 67 B

History

  1. First recorded snapshot · 0 installs

SKILL.md

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