sql
- Repo stars 316
- Author updated Live
- Author repo WordPress-Simple-History
- Domain
- Other
- Compatible agents
-
- Claude Code
- Cursor
- Cline
- Codex
- Windsurf
- Gemini CLI
- +20
- Trust score
- 88 / 100 · community maintained
- 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
- Permissions
-
- Read-only
- Write / modify
- Shell exec
- Network behavior
- Local-only
- Install commands
- 26 variants
Profile is derived at build time from SKILL.md and install vectors. Subject to drift from author intent.
Heads up: 未限定 allowed-tools,默认拥有全部工具权限。
---
name: sql
description: Runs SQL queries against the WordPress development database. Use when inspecting tables, checkin…
category: other
runtime: Docker
---
# sql output preview
## PART A: Task fit
- Use case: Runs SQL queries against the WordPress development database. Use when inspecting tables, checking event data, or debugging database issues. Run SQL queries against the WordPress development database. runs entirely locally; runs on Docker. Works with Claude Code, Cursor, Cline and 23 more..
- Inputs: target material, constraints, expected output, and acceptance criteria.
- Evidence boundary: follow “Command Pattern / Common Queries / Table Prefixes” and do not present inference as author intent.
## PART B: Execution result
- **01** The card summarizes the use case; runtime output centers on “Runs SQL queries against the WordPress development database. Use when inspecting tables, checking event data, or debugging database issues. Run SQL queries against the WordPress development database. runs entirely locally; runs on Docker. Works with Claude Code, Cursor, Cline and 23 more.”.
- **02** When the source has headings, the agent prioritizes “Command Pattern / Common Queries / Table Prefixes” so the result follows the author’s structure.
- **03** Typical output includes task judgment, concrete steps, required commands or file edits, validation, and follow-up options.
- **04** Risk context follows the fingerprint: read files, write/modify files, run shell commands; mostly runs locally; usually needs no extra API key.
## Running Rules
- read files, write/modify files, run shell commands; mostly runs locally; usually needs no extra API key.
- Validate with a small sample before expanding scope.
- Return the result, validation criteria, and next iteration options. The source does not require a stable slash command. After installation, invoke the skill by name and describe the task.
Name target files or source material, expected output, forbidden changes, and whether network or shell access is allowed. Permission fingerprint: read files, write/modify files, run shell commands.
Start with a small task and check whether the result follows “Command Pattern / Common Queries / Table Prefixes”. Inspect diffs, logs, previews, or tests before expanding scope.
Confirm the final output includes a concrete result, evidence, and next action. If it stays generic, tighten inputs, boundaries, and acceptance criteria.
---
name: sql
description: Runs SQL queries against the WordPress development database. Use when inspecting tables, checkin…
category: other
source: bonny/WordPress-Simple-History
---
# sql
## When to use
- Runs SQL queries against the WordPress development database. Use when inspecting tables, checking event data, or debug…
- Use it when the task has clear inputs, repeatable steps, and validation criteria.
## What to provide
- Target material, scope, expected result, and forbidden changes.
- Whether network, commands, file writes, or external services are allowed.
## Execution rules
- Organize steps around “Command Pattern / Common Queries / Table Prefixes” and keep inference separate from source facts.
- read files, write/modify files, run shell commands; mostly runs locally; usually needs no extra API key.
- Validate with a small sample before expanding the task.
## Output requirements
- Return the deliverable, key evidence, validation method, and next action.
- Mark missing information as unknown; do not invent commands, platforms, or dependencies. The author source anchors workflow facts; repository files anchor sources and commands; Fluxly only adds fit, limitations, and quality judgment.
skill "sql" {
input -> user goal + target files + boundaries + acceptance criteria
context -> Command Pattern / Common Queries / Table Prefixes
rules -> SKILL.md triggers / order / output contract
runtime -> Docker | read files, write/modify files, run shell commands | mostly runs locally
guardrails -> usually needs no extra API key + small-sample validation + diff/log review
output -> copyable result + checklist + next iteration
} 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
Decide Fit First
Design Intent
How To Use It
Boundaries And Review