sql
Runs SQL queries against the WordPress development database. Use when inspecting tables, checking event data, or debugging database issues.
Source facts
- Repository
- bonny/WordPress-Simple-History
- Last source activity
- August 29, 2026 at 19:37
- Detected SKILL.md language
- English
- Stars
- 317
- Forks
- 74
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Showing SKILL.md
SKILL.md
Source instructions · Read-only preview- name
- sql
- description
- Runs SQL queries against the WordPress development database. Use when inspecting tables, checking event data, or debugging database issues.
- disable-model-invocation
- false
- allowed-tools
- Read, Bash
# Run SQL Queries
Run SQL queries against the WordPress development database.
**Security:** Development database only. Always confirm UPDATE/DELETE with user first.
## Command Pattern
```bash
docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "YOUR_SQL_HERE"
```
Credentials are in `CLAUDE.local.md` under "Database Access".
## Common Queries
```bash
# Show all tables
docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "SHOW TABLES;"
# Recent Simple History events
docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "SELECT * FROM wp_simple_history ORDER BY id DESC LIMIT 10;"
# Describe table structure
docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "DESCRIBE wp_simple_history;"
```
## Table Prefixes
| Prefix | Installation |
| --------------- | ------------- |
| `wp_` | Main install |
| `wp_nightly_` | Nightly build |
| `wp_multisite_` | Multisite |
## Simple History Tables
- `wp_simple_history` - Main events table
- `wp_simple_history_contexts` - Event context/metadata
## Workflow
1. Read credentials from `CLAUDE.local.md`
2. Ask user for query (if not specified)
3. Run query and display results
4. **For UPDATE/DELETE:** Always confirm with user first
View on GitHub