sql
- Repo stars 316
- Author repo WordPress-Simple-History
Run SQL Queries
Run SQL queries against the WordPress development database.
Security: Development database only. Always confirm UPDATE/DELETE with user first.
Command Pattern
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
# 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 tablewp_simple_history_contexts- Event context/metadata
Workflow
- Read credentials from
CLAUDE.local.md - Ask user for query (if not specified)
- Run query and display results
- For UPDATE/DELETE: Always confirm with user first
- Fluxly category
- 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
- Author / version / license
- @bonny · no license declared
- Fluxly token estimate
- Lean
- Fluxly setup estimate
- Manual integration
- External API key
- No requirement detected
- Detected OS requirements
- Docker
- Runtime requirements
- Docker
- Detected file/system behavior
-
- Read-only
- Write / modify
- Shell exec
- 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,默认拥有全部工具权限。
The current SKILL.md does not define a fixed output example. Credentials are in CLAUDE.local.md under "Database Access".
Common Queries
Prefix · Installation wp · Main install wpnightly · Nightly build
wpsimplehistory - Main events table wpsimplehistorycontexts - Event context/metadata
Read credentials from CLAUDE.local.md Ask user for query (if not specified) Run query and display results
# 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 Author text anchors workflow facts; Fluxly only indexes current sections, terms, files, and commands.
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 · wpnightly · wpmultisite · wpsimplehistory · wpsimplehistorycontexts
body sha256 -> 31d38c4388e6
Decide Fit First
Design Intent
How To Use It
Boundaries And Review