skills.rest
ryukyagamilight
ryukyagamilightCOMMUNITY
Explore all skills by this author →
GitHub

mysql

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
One-click install
npx skills add https://github.com/ryukyagamilight/terminal-skills --skill mysql-ryukyagamilight
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
agents-infrastructureagents-infrastructure
7

alicloud-rds

Manage Alibaba Cloud RDS instances across MySQL, PostgreSQL, SQL Server, and MariaDB.

Official
Advanced
kevinnguyen271090kevinnguyen271090
15

databases

Design and optimize MongoDB and PostgreSQL databases for schema, queries, and performance.

Community
Intermediate
billyfranklim1billyfranklim1

performance-profiling

Profile PHP, Next.js, and MySQL performance bottlenecks with endpoint timing and k6 load tests.

Community
Advanced
wangx7wangx7

cloud-sql-basics

Provision and administer Cloud SQL instances for MySQL, PostgreSQL, and SQL Server.

Community
Intermediate