mysql

Name: mysql
Availability: InStock
Author: ryukyagamilight

Administer MySQL and MariaDB databases with commands for backup, monitoring, and troubleshooting.

1|Updated Jan 31, 2026

Search Tags:#performance #database #backup #sql #administration #mysql #mariadb

Ready to run

npx skills add https://github.com/ryukyagamilight/terminal-skills --skill mysql-ryukyagamilight

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: mysql
Source: https://github.com/ryukyagamilight/terminal-skills/tree/main/database/mysql
Command: npx skills add https://github.com/ryukyagamilight/terminal-skills --skill mysql-ryukyagamilight

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill simplifies the complex and time-consuming tasks of managing, operating, and troubleshooting MySQL/MariaDB databases.

Core Features & Use Cases

Connection Management: Connect to local or remote MySQL instances and execute SQL scripts.
User & Permission Control: Create, grant, and manage user access and privileges.
Database & Table Operations: Perform standard CRUD operations on databases and tables.
Backup & Recovery: Implement robust backup strategies and restore data efficiently.
Performance Monitoring & Tuning: Diagnose and resolve performance bottlenecks, slow queries, and locking issues.
Use Case: Quickly troubleshoot a slow-running application by identifying and optimizing a problematic SQL query using EXPLAIN and checking SHOW PROCESSLIST.

Quick Start

Use the mysql skill to create a new database named 'analytics_db' with utf8mb4 character set.

Frequently Asked Questions about mysql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I troubleshoot slow queries in MySQL using EXPLAIN and process lists?▼

MySQL backup and recovery can be performed using the mysqldump utility to create logical backups of your databases. This Skill outlines the procedures to implement robust backup strategies and efficiently restore your data when needed.

How do I create a MySQL database with a specific character set like utf8mb4?▼

You can create a MySQL database with a specific character set by executing a standard database creation command specifying utf8mb4. This Skill guides you through performing standard CRUD operations and database operations with proper character set configuration.

What is the best way to manage user privileges and access control in MariaDB?▼

Managing user privileges in MariaDB involves using specific SQL commands to create users, grant permissions, and manage access control. This Skill provides comprehensive procedures for user and privilege control across your database instances.

Can I use this to analyze MySQL status variables for performance monitoring?▼

Yes, you can analyze MySQL status variables for performance monitoring. This Skill provides commands to check status variables and process lists, enabling you to diagnose performance issues, resolve bottlenecks, and analyze locks effectively.

Does this Skill support connecting to remote MySQL instances and executing SQL scripts?▼

Yes, this Skill supports connection management for both local and remote MySQL instances, allowing you to execute SQL scripts directly. It covers the necessary procedures to establish connections and perform database administration tasks.