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