sql
- Repo stars 316
- Author repo WordPress-Simple-History
- Domain
- Other
- 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
- @bonny · no license declared
- Token usage
- Lean
- Setup complexity
- Manual integration
- External API key
- Not required
- Operating systems
- Docker
- Runtime requirements
- Docker
- Detected file/system behavior
-
- Read-only
- Write / modify
- Shell exec
- Network behavior
- Local-only
- Install commands
- None (reference only)
Heads up: Tool permissions are not declared; actual access depends on the runtime.
# 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
Sections and files
Listed in source order.
sections -> Command Pattern → Common Queries → Table Prefixes → Simple History Tables → Workflow
terms -> Security · For UPDATE/DELETE · Run SQL queries against the WordPress development database. · Security: Development database only. · Credentials are in CLAUDE.local.md under "Database Access". · 1. Read credentials from CLAUDE.local.md 2.
files/cmd -> CLAUDE.local.md · wp_ · wp_nightly_ · wp_multisite_ · wp_simple_history · wp_simple_history_contexts
body sha256 -> 31d38c4388e6
Command Pattern
Credentials are in
CLAUDE.local.mdunder "Database Access".Table Prefixes
Prefix · Installation
wp_· Main installwp_nightly_· Nightly buildwp_multisite_· MultisiteSimple History Tables
wp_simple_history- Main events tablewp_simple_history_contexts- Event context/metadataWorkflow
Read credentials from
CLAUDE.local.mdAsk user for query (if not specified) Run query and display results For UPDATE/DELETE: Always confirm with user first