skills.rest
chaterm
chatermCOMMUNITY
Explore all skills by this author →
Website𝕏@Chaterm_aiGitHub

mysql

Manage MySQL and MariaDB databases via SQL and bash commands.

50|13|Updated Jan 19, 2026
Search Tags:#performance#database#backup#sql#administration#mysql#mariadb
One-click install
npx skills add https://github.com/chaterm/terminal-skills --skill mysql-chaterm
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mysql
Source: https://github.com/chaterm/terminal-skills/tree/main/database/mysql
Command: npx skills add https://github.com/chaterm/terminal-skills --skill mysql-chaterm

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides comprehensive guidance and commands for managing MySQL/MariaDB databases, covering daily operations, backup and recovery, and performance tuning.

Core Features & Use Cases

  • Connection Management: Connect to local or remote MySQL instances and execute SQL commands.
  • User and Permissions: Create, manage, and revoke user privileges.
  • Database and Table Operations: Perform standard CRUD operations on databases and tables.
  • Backup and Restore: Utilize mysqldump for reliable database backups and restoration.
  • Performance Monitoring: Analyze process lists, status variables, and slow queries.
  • Troubleshooting: Address common issues like slow queries, lock waits, and replication lag.

Quick Start

Use the mysql skill to connect to your local database as the root user and show all databases.

Frequently Asked Questions about mysql

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

FAQPage Schema
How do I back up and restore a MySQL database using mysqldump?▼

To back up a MySQL database, use the mysqldump command to generate a reliable SQL dump file, then restore it by executing the dump file's SQL statements against your local or remote database instance.

What's the best way to optimize slow queries and monitor MySQL performance?▼

To optimize slow queries and monitor MySQL performance, analyze the process list, check status variables, and identify slow queries to troubleshoot issues like lock waits and replication lag.

How do I manage user permissions and privileges in a MariaDB database?▼

You can manage MariaDB user permissions by executing SQL commands to create new users, grant specific privileges, and revoke access rights directly on your local or remote database instance.

Does this Skill support troubleshooting replication lag and lock waits in MySQL?▼

Yes, this Skill supports troubleshooting MySQL replication lag and lock waits by executing SQL and bash commands to analyze process lists and status variables for operational database administration.

How do I connect to a remote MySQL instance and execute SQL commands?▼

You can connect to a remote MySQL instance by providing your connection credentials, allowing you to directly execute SQL commands and perform standard CRUD operations on databases and tables.

Related Skills

Explore More Software Engineering Skills→
zangjeicyzangjeicy

pinggy-tunnel

Expose local network services via SSH-based reverse tunneling.

Community
Intermediate
ryukyagamilightryukyagamilight
1

cloud-backup

Manage data backups and synchronization to AWS S3, Alibaba OSS, and Azure Blob Storage.

Community
Advanced
billyfranklim1billyfranklim1

performance-profiling

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

Community
Advanced
chef0111chef0111
1

databases

Manage MongoDB and PostgreSQL databases with schema design, CRUD, indexing, and migrations.

Community
Advanced