home / Database / Mysql Skill by @BagelHole

Mysql Skill by @BagelHole

FREE

github stars★ 1,180updatedMar 2026repo@BagelHole

$git clone https://github.com/BagelHole/DevOps-Security-Agent-Skills

The skill is the infrastructure/databases/mysql folder inside that repository. Copy it into the folder your agent loads skills from; check your agent's documentation for where that is.

about Mysql Skill by @BagelHole

Administer MySQL/MariaDB databases. Configure replication and optimize performance.

our take

Administers MySQL and MariaDB: installation, initial users and databases, replication and performance tuning, with a command-line reference.

when to use it

You set up a MySQL or MariaDB server
You configure replication
You tune a slow instance

before you install

Take and test backups before changing configuration
Do not expose database ports to the internet without strict access control

what's inside

The original SKILL.md is organised into these sections:

When to Use
Prerequisites
Installation and Setup
Initial User and Database Setup
mysql CLI Reference
Configuration Tuning
Backup and Restore
Logical Backups with mysqldump
Physical Backups with Percona XtraBackup
Incremental Backup with XtraBackup
Source-Replica Replication
Source (Primary)

source and license

Written and maintained by @BagelHole. It is published under the MIT license, which allows reuse with attribution. SkillDirectory does not claim authorship: this page adds our own review and links back to the original, and the skill's text belongs to its author.

View the full SKILL.md on GitHub ↗

Read the opening of the original SKILL.md

# MySQL / MariaDB

Administer, optimize, and secure MySQL and MariaDB databases in development and production environments.

## When to Use

- You need a mature, widely supported relational database.
- Your stack depends on MySQL-specific features or compatibility (WordPress, Magento, many PHP frameworks).
- You are setting up source-replica replication for read scaling.
- You want to tune InnoDB for high-throughput transactional workloads.

## Prerequisites

- Linux server (Debian/Ubuntu or RHEL-based) or Docker.
- Root or sudo access for package installation.
- Familiarity with SQL fundamentals.

## Installation and Setup

```bash
# Debian / Ubuntu — MySQL 8
sudo apt update
sudo apt install -y mysql-server

# RHEL / Amazon Linux
sudo dnf install -y mysql-server
sudo systemctl enable --now mysqld

# Run the secure installation wizard
sudo mysql_secure_installation
# Prompts: set root password, remove anonymous users, disable remote root, remove test db

# Verify
mysql --version
…

Excerpt only, quoted from the author's repository. Open the repository for the complete file.

↓ download .zip