database-mysql

Data Community

Repo stars 613
Author repo incidentfox

Interpretation is structured for decision-making; original keeps the upstream SKILL.md unchanged.

Decide Fit First

Core job: MySQL/MariaDB database inspection and queries. Use when investigating table schemas, running queries, checking processlist, repl…
Best fit: Use it when the task has reusable inputs, steps, and validation criteria rather than a one-off answer.
Avoid forcing it: If the source lacks commands, platform support, or external-service evidence, keep those fields unknown instead of guessing.

Design Intent

Structure: The skill is organized around “Authentication”, “MANDATORY: Schema-First Investigation”, “Available Scripts”, “listtables.py - List Tables (START HERE)”, showing how the author expects the agent to judge fit, collect context, and produce verifiable output.
Trigger evidence: Prioritize the author’s wording around when to use it, what context to collect, and what output shape to produce.
Evidence boundary: Author text states facts, repository files prove commands and paths, and Fluxly only adds fit, limits, and usage judgment.

How To Use It

Inputs: Provide target material, scope, expected result, forbidden changes, and validation method.
Invocation: Name database-mysql directly; if the source includes slash commands, start with the command and then add task context.
Validation: Start small and check whether the result follows “Authentication / MANDATORY: Schema-First Investigation / Available Scripts” before expanding.

Boundaries And Review

Dependencies: It usually needs no extra API key, so start with a small validation task.
Permissions: Declared permissions include read / shell-exec / env-read; ask the agent to state file, command, and rollback boundaries before acting.
Quality bar: A useful result names the deliverable, evidence, and next action. Generic prose means the task needs tighter context.

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)

Fluxly profile Author and license come from source; runtime, permissions, and network are Fluxly detections or estimates

Fluxly category: Data
Author-declared agents: No explicit declaration found; this is not inferred or tested compatibility
Static check: 88 / 100 · heuristic scan, not runtime safety proof
Author / version / license: @incidentfox · no license declared
Fluxly token estimate: Lean
Fluxly setup estimate: Guided setup
External API key: No requirement detected
Detected OS requirements: Unspecified
Runtime requirements: Python
Detected file/system behavior: Read-only
Shell exec
Env read
Detected network behavior: Local-only
Install commands: None (reference only)

Profile is derived at build time from SKILL.md and install vectors. Subject to drift from author intent.

Heads up: 未限定 allowed-tools，默认拥有全部工具权限。

Output preview database-mysql.preview

The current SKILL.md does not define a fixed output example.

SKILL.md SKILL.md

# 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)
```bash
python .claude/skills/database-mysql/scripts/list_tables.py [--database DB]
```

### describe_table.py - Table Schema Details
```bash
python .claude/skills/database-mysql/scripts/describe_table.py --table TABLE_NAME [--database DB]
```

### execute_query.py - Run SQL Queries
```bash
python .claude/skills/database-mysql/scripts/execute_query.py --query "SELECT * FROM users LIMIT 10" [--limit 100]
```

### show_processlist.py - Active Connections
```bash
python .claude/skills/database-mysql/scripts/show_processlist.py [--full]
```

### show_replica_status.py - Replication Health
```bash
python .claude/skills/database-mysql/scripts/show_replica_status.py
```

### show_engine_status.py - InnoDB Engine Status
```bash
python .claude/skills/database-mysql/scripts/show_engine_status.py [--engine innodb]
```

### get_table_locks.py - Lock Contention
```bash
python .claude/skills/database-mysql/scripts/get_table_locks.py
```

---

## Investigation Workflow

### Slow Query Investigation
```

…

Evidence boundary and execution chain

Author text anchors workflow facts; Fluxly only indexes current sections, terms, files, and commands.

sections -> Authentication → MANDATORY: Schema-First Investigation → Available Scripts → listtables.py - List Tables (START HERE) → describetable.py - Table Schema Details → executequery.py - Run SQL Queries
terms    -> IMPORTANT · Understand the schema before running queries. · IMPORTANT: Credentials are injected automatically by a proxy layer.
files/cmd -> MYSQLPASSWORD · MYSQLHOST · MYSQLPORT · MYSQLDATABASE · .claude/skills/database-mysql/scripts/
body sha256 -> 9e1d5e4286bd