skills.rest
bonny
bonnyCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

sql

Run SQL queries against WordPress development databases to inspect tables and diagnose issues.

316|74|Updated Apr 15, 2013
Search Tags:#database#queries#docker#sql#mysql#wordpress#wp
One-click install
npx skills add https://github.com/bonny/WordPress-Simple-History --skill sql
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: sql
Source: https://github.com/bonny/WordPress-Simple-History/tree/main/.claude/skills/sql
Command: npx skills add https://github.com/bonny/WordPress-Simple-History --skill sql

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a guided approach to running SQL queries against the WordPress development database, aiding debugging and data inspection.

Core Features & Use Cases

  • Direct queries: Run common queries to inspect wp_simple_history and related tables.
  • Environment awareness: Documents prerequisites and the required docker-based connection pattern.
  • Safe exploration: Encourages careful execution with explicit prompts and follow-up options.

Quick Start

  • docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "SHOW TABLES;"
  • docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "SELECT * FROM wp_simple_history ORDER BY id DESC LIMIT 10;"
  • Describe a table, e.g., docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "DESCRIBE wp_simple_history;"

Frequently Asked Questions about sql

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query WordPress database tables to inspect data and diagnose issues?▼

Query WordPress database tables using docker compose exec mariadb mysql with your credentials from CLAUDE.local.md. Run commands like SHOW TABLES, SELECT from wp_simple_history, or DESCRIBE to inspect table structures across WordPress installations with different prefixes (wp_, wp_nightly_, wp_6_0_ through wp_6_6_, wp_multisite_, wp_php74_, wp_subfolder_).

What's the correct way to access the WordPress development database with docker-compose?▼

Access MariaDB via docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> from the docker-compose project directory. Credentials are stored in CLAUDE.local.md. This pattern supports multiple WordPress installations with varying table prefixes for development and debugging.

Can I run SQL queries directly against WordPress development databases with different table prefixes?▼

Yes. This Skill runs SQL queries across multiple WordPress installations with prefixes like wp_, wp_nightly_, wp_6_0_ through wp_6_6_, wp_multisite_, wp_php74_, and wp_subfolder_. Query wp_simple_history, list tables, describe structures, and count records across different installations from one docker-compose environment.

What precautions should I take when running SQL queries against WordPress databases?▼

Exercise caution with UPDATE and DELETE operations against WordPress development databases. Verify table structures and existing data before modifying. Use SELECT queries for safe exploration and inspection before attempting write operations on any WordPress installation.

How do I list and describe WordPress database tables to understand their structure?▼

Run SHOW TABLES to list all tables, and DESCRIBE wp_table_name to inspect column structure and data types. Use these diagnostic queries to understand WordPress schema across installations, then run SELECT queries to inspect wp_simple_history events and related data for debugging.

Do I need special setup to query multiple WordPress installations from one docker-compose environment?▼

Yes. Read credentials from CLAUDE.local.md and run docker compose exec mariadb mysql commands from the docker-compose project directory. The Skill supports multiple WordPress databases with different prefixes (wp_, wp_nightly_, wp_6_0_ through wp_6_6_, wp_multisite_, wp_php74_, wp_subfolder_) within the same MariaDB instance.

Related Skills

Explore More Data & Analytics Skills→
MicrockMicrock
322

sql

Run SQL queries against WordPress development databases via Docker Compose.

Community
Advanced
besoeasybesoeasy
128

database-query-and-export

Query SQLite, PostgreSQL, and MySQL databases and export results to CSV or JSON.

Community
Intermediate
run6270run6270
1

docker-essentials

Manage Docker containers, images, and Compose multi-container applications.

Community
Intermediate
gabi-agentgabi-agent

sql-toolkit

Automate database design, querying, migrations, and optimization across SQLite, PostgreSQL, and MySQL.

Community
Advanced