database mysql
- Repo stars 613
- Author repo incidentfox
- Domain
- 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
- Runtime evidence
- Not run; no isolated runtime test evidence is currently recorded
- 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
- Detected file/system behavior
-
- Read-only
- Shell exec
- Env read
- Network behavior
- Local-only
- Install commands
- None (reference only)
Heads up: Tool permissions are not declared; actual access depends on the runtime.
# 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
```
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)
```
Sections and files
Listed in source order.
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 -> MYSQL_PASSWORD · MYSQL_HOST · MYSQL_PORT · MYSQL_DATABASE · .claude/skills/database-mysql/scripts/
body sha256 -> 9e1d5e4286bd
Authentication
IMPORTANT: Credentials are injected automatically by a proxy layer. Do NOT check for
MYSQL_PASSWORDin 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 nameMANDATORY: Schema-First Investigation
Understand the schema before running queries.
Available Scripts
All scripts are in
.claude/skills/database-mysql/scripts/