mysql

Savant verdict: Review advised

Security analysis or source-hub review identified patterns requiring attention.

Live evaluation

Not evaluated yet. Workspaces can request a live evaluation.

Security assessment

Scan pending.

Structure

• Ships 1 executable scriptscripts/validate.py. Review what they do before enabling the skill for agents with tool access.
• No license declaredConfirm you may reuse this skill before importing it into your repository.
• The source hub's security checks flagged this skillRunlayer: warn (3/6 files flagged)

SKILL.md

---
name: mysql
description: MySQL database administration and development
sasmp_version: "1.3.0"
bonded_agent: 02-postgresql-dba
bond_type: PRIMARY_BOND
---

# MySQL Skill

## Overview
Master MySQL database administration, optimization, and development for production environments.

## Topics Covered

### MySQL Basics
- Installation and configuration
- User management
- Database creation
- Storage engines (InnoDB, MyISAM)
- Character sets

### Query Development
- SELECT statements
- JOINs and subqueries
- INSERT, UPDATE, DELETE
- Stored procedures
- Triggers and events

### Performance
- EXPLAIN analysis
- Index optimization
- Query cache (8.0+ changes)
- Slow query log
- Performance Schema

### Administration
- Backup with mysqldump
- Binary log management
- Replication setup
- User privileges
- Configuration tuning

### High Availability
- MySQL replication
- Group replication
- MySQL Router
- ProxySQL
- Failover strategies

## Prerequisites
- SQL fundamentals
- Linux basics
- Networking concepts

## Learning Outcomes
- Administer MySQL servers
- Optimize queries
- Set up replication
- Manage backups