mysql

MySQL Skill

Execute MySQL queries and manage databases through a containerized MySQL client.

Overview

This skill provides AI agents with MySQL database access through a Docker-based mysql CLI client. Run queries, manage schemas, export data, and monitor database health.

When to Use This Skill

• Execute SQL queries against MySQL databases
• Manage database schemas and tables
• Export query results
• Monitor database connections and status
• Perform database administration tasks

Prerequisites

• Docker installed and running
• Network access to target MySQL server
• MySQL user credentials with appropriate permissions

Configuration

Add to your .skill-engine.toml:

[skills.mysql]
source = "docker:mysql:8"
runtime = "docker"
description = "MySQL database client"

[skills.mysql.docker]
image = "mysql:8"
entrypoint = "mysql"
network = "bridge"
memory = "256m"
rm = true
environment = [
  "MYSQL_PWD=${MYSQL_PASSWORD}"
]

Configuration Explained

Setting	Value	Description
image	mysql:8	Official MySQL 8 image with mysql client
entrypoint	mysql	Use the mysql command-line client
network	bridge	Bridge network to connect to external databases
memory	256m	Memory limit for the container
rm	true	Auto-remove container after execution

Usage

Arguments after -- are passed directly to the mysql client:

skill run mysql -- [mysql options]

Common Operations

Connect and Run Query

# Simple query
skill run mysql -- -h localhost -u myuser -e "SELECT * FROM users LIMIT 10" mydb

# With explicit password (not recommended - use env var)
skill run mysql -- -h localhost -u myuser -p'password' -e "SHOW DATABASES"

# Using environment variable for password
MYSQL_PASSWORD=secret skill run mysql -- -h localhost -u myuser -e "SHOW TABLES" mydb

List Databases and Tables

# List all databases
skill run mysql -- -h localhost -u root -e "SHOW DATABASES"

# List tables in a database
skill run mysql -- -h localhost -u root -e "SHOW TABLES" mydb

# Describe table structure
skill run mysql -- -h localhost -u root -e "DESCRIBE users" mydb