sql

Other Community

Skill notes

Command Pattern

Credentials are in CLAUDE.local.md under "Database Access".

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

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 profile Runtime and permissions are inferred by Fluxly static checks, not author declarations or runtime test results.
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.

Author source file SKILL.md

# 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

Discussion

Powered by GitHub Discussions. Sign in with GitHub to comment, react, or subscribe.