sql

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	true
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

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 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