How do I install the Database Mysql skill?

Run npx skillmds@latest add incidentfox/database-mysql in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is Database Mysql safe to use?

This skill has not completed SkillMD's automated safety review yet. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with Database Mysql?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is Database Mysql free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published Database Mysql?

incidentfox (@incidentfox) published this skill. Their other Agent Skills are listed on their SkillMD profile.

Database Mysql by incidentfox — Agent Skill

Name: Database Mysql
Author: incidentfox

File contents

MySQL Database

Authentication

IMPORTANT: Credentials are injected automatically by a proxy layer. Do NOT check for MYSQL_PASSWORD in environment variables - it won't be visible to you. Just run the scripts directly; authentication is handled transparently.

Configuration environment variables you CAN check (non-secret):

MYSQL_HOST - Database host
MYSQL_PORT - Database port (default: 3306)
MYSQL_DATABASE - Database name

MANDATORY: Schema-First Investigation

Understand the schema before running queries.

LIST TABLES → DESCRIBE TABLE → EXECUTE QUERY → CHECK HEALTH

Available Scripts

All scripts are in .claude/skills/database-mysql/scripts/

list_tables.py - List Tables (START HERE)

python .claude/skills/database-mysql/scripts/list_tables.py [--database DB]

describe_table.py - Table Schema Details

python .claude/skills/database-mysql/scripts/describe_table.py --table TABLE_NAME [--database DB]

execute_query.py - Run SQL Queries

python .claude/skills/database-mysql/scripts/execute_query.py --query "SELECT * FROM users LIMIT 10" [--limit 100]

show_processlist.py - Active Connections

python .claude/skills/database-mysql/scripts/show_processlist.py [--full]

show_replica_status.py - Replication Health

python .claude/skills/database-mysql/scripts/show_replica_status.py

show_engine_status.py - InnoDB Engine Status

python .claude/skills/database-mysql/scripts/show_engine_status.py [--engine innodb]

get_table_locks.py - Lock Contention

python .claude/skills/database-mysql/scripts/get_table_locks.py

Investigation Workflow

Slow Query Investigation

1. show_processlist.py --full (find active/long queries)
2. show_engine_status.py (check InnoDB lock waits, deadlocks)
3. get_table_locks.py (find lock contention)

Replication Lag

1. show_replica_status.py (check Seconds_Behind_Master)
2. show_processlist.py (check for blocking queries)

---name: database-mysqldescription: MySQL/MariaDB database inspection and queries. Use when investigating table schemas, running queries, checking processlist, replication status, InnoDB engine status, or lock contention.---# MySQL Database## Authentication**IMPORTANT**: Credentials are injected automatically by a proxy layer. Do NOT check for `MYSQL_PASSWORD` in environment variables - it won't be visible to you. Just run the scripts directly; authentication is handled transparently.Configuration environment variables you CAN check (non-secret):- `MYSQL_HOST` - Database host- `MYSQL_PORT` - Database port (default: 3306)- `MYSQL_DATABASE` - Database name---## MANDATORY: Schema-First Investigation**Understand the schema before running queries.**```LIST TABLES → DESCRIBE TABLE → EXECUTE QUERY → CHECK HEALTH```## Available ScriptsAll scripts are in `.claude/skills/database-mysql/scripts/`### list_tables.py - List Tables (START HERE)```bashpython .claude/skills/database-mysql/scripts/list_tables.py [--database DB]```### describe_table.py - Table Schema Details```bashpython .claude/skills/database-mysql/scripts/describe_table.py --table TABLE_NAME [--database DB]```### execute_query.py - Run SQL Queries```bashpython .claude/skills/database-mysql/scripts/execute_query.py --query "SELECT * FROM users LIMIT 10" [--limit 100]```### show_processlist.py - Active Connections```bashpython .claude/skills/database-mysql/scripts/show_processlist.py [--full]```### show_replica_status.py - Replication Health```bashpython .claude/skills/database-mysql/scripts/show_replica_status.py```### show_engine_status.py - InnoDB Engine Status```bashpython .claude/skills/database-mysql/scripts/show_engine_status.py [--engine innodb]```### get_table_locks.py - Lock Contention```bashpython .claude/skills/database-mysql/scripts/get_table_locks.py```---## Investigation Workflow### Slow Query Investigation```1. show_processlist.py --full (find active/long queries)2. show_engine_status.py (check InnoDB lock waits, deadlocks)3. get_table_locks.py (find lock contention)```### Replication Lag```1. show_replica_status.py (check Seconds_Behind_Master)2. show_processlist.py (check for blocking queries)```

Frequently asked questions

Database Mysql