sql
Runs SQL queries against the WordPress development database. Use when inspecting tables, checking event data, or debugging database issues.
来源信息
- 仓库
- bonny/WordPress-Simple-History
- 最近来源活动
- 2026年8月29日 19:37
- 检测到的 SKILL.md 语言
- 英语
- 星标
- 317
- 分支
- 74
安装方式
默认使用会先检查来源的 Prompt；你也可以切换为直接命令，或下载本地副本。
检查来源文件
决定是否安装前，请先阅读 SKILL.md，以及 SkillsMP 当前展示的配套文件。
正在显示 SKILL.md
SKILL.md
来源说明 · 只读预览- 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
在 GitHub 查看