database-mysql
- Repo stars 613
- Author updated Live
- Author repo incidentfox
- Domain
- Data
- Compatible agents
-
- Claude Code
- Cursor
- Cline
- Codex
- Windsurf
- Gemini CLI
- +20
- Trust score
- 88 / 100 · community maintained
- Author / version / license
- @incidentfox · no license declared
- Token usage
- Lean
- Setup complexity
- Guided setup
- External API key
- Not required
- Operating systems
- Unspecified (assume cross-platform)
- Runtime requirements
- Python
- Permissions
-
- Read-only
- Shell exec
- Env read
- Write / modify
- Network behavior
- Local-only
- Install commands
- 26 variants
Profile is derived at build time from SKILL.md and install vectors. Subject to drift from author intent.
Heads up: 未限定 allowed-tools,默认拥有全部工具权限。
---
name: database-mysql
description: MySQL/MariaDB database inspection and queries. Use when investigating table schemas, running que…
category: data
runtime: Python
---
# database-mysql output preview
## PART A: Task fit
- Use case: MySQL/MariaDB database inspection and queries. Use when investigating table schemas, running queries, checking processlist, replication status, InnoDB engine status, or lock contention..
- Inputs: target material, constraints, expected output, and acceptance criteria.
- Evidence boundary: follow “Authentication / MANDATORY: Schema-First Investigation / Available Scripts” and do not present inference as author intent.
## PART B: Execution result
- **01** The card summarizes the use case; runtime output centers on “MySQL/MariaDB database inspection and queries. Use when investigating table schemas, running queries, checking processlist, replication status, InnoDB engine status, or lock contention.”.
- **02** When the source has headings, the agent prioritizes “Authentication / MANDATORY: Schema-First Investigation / Available Scripts” so the result follows the author’s structure.
- **03** Typical output includes task judgment, concrete steps, required commands or file edits, validation, and follow-up options.
- **04** Risk context follows the fingerprint: read files, run shell commands, read environment variables, write/modify files; mostly runs locally; usually needs no extra API key.
## Running Rules
- read files, run shell commands, read environment variables, write/modify files; mostly runs locally; usually needs no extra API key.
- Validate with a small sample before expanding scope.
- Return the result, validation criteria, and next iteration options. The source does not require a stable slash command. After installation, invoke the skill by name and describe the task.
Name target files or source material, expected output, forbidden changes, and whether network or shell access is allowed. Permission fingerprint: read files, run shell commands, read environment variables, write/modify files.
Start with a small task and check whether the result follows “Authentication / MANDATORY: Schema-First Investigation / Available Scripts”. Inspect diffs, logs, previews, or tests before expanding scope.
Confirm the final output includes a concrete result, evidence, and next action. If it stays generic, tighten inputs, boundaries, and acceptance criteria.
---
name: database-mysql
description: MySQL/MariaDB database inspection and queries. Use when investigating table schemas, running que…
category: data
source: incidentfox/incidentfox
---
# database-mysql
## When to use
- MySQL/MariaDB database inspection and queries. Use when investigating table schemas, running queries, checking process…
- Use it when the task has clear inputs, repeatable steps, and validation criteria.
## What to provide
- Target material, scope, expected result, and forbidden changes.
- Whether network, commands, file writes, or external services are allowed.
## Execution rules
- Organize steps around “Authentication / MANDATORY: Schema-First Investigation / Available Scripts” and keep inference separate from source facts.
- read files, run shell commands, read environment variables, write/modify files; mostly runs locally; usually needs no extra API key.
- Validate with a small sample before expanding the task.
## Output requirements
- Return the deliverable, key evidence, validation method, and next action.
- Mark missing information as unknown; do not invent commands, platforms, or dependencies. The author source anchors workflow facts; repository files anchor sources and commands; Fluxly only adds fit, limitations, and quality judgment.
skill "database-mysql" {
input -> user goal + target files + boundaries + acceptance criteria
context -> Authentication / MANDATORY: Schema-First Investigation / Available Scripts
rules -> SKILL.md triggers / order / output contract
runtime -> Python | read files, run shell commands, read environment variables, write/modify files | mostly runs locally
guardrails -> usually needs no extra API key + small-sample validation + diff/log review
output -> copyable result + checklist + next iteration
} 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 hostMYSQL_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)
Decide Fit First
Design Intent
How To Use It
Boundaries And Review