Run SQL queries against WordPress development databases via Docker Compose.
npx skills add https://github.com/Microck/ordinary-claude-skills --skill sql-microck
Please help me install this Agent Skill. Skill: sql Source: https://github.com/Microck/ordinary-claude-skills/tree/main/skills_all/sql Command: npx skills add https://github.com/Microck/ordinary-claude-skills --skill sql-microck
Automates SQL queries against the WordPress development database for inspecting tables, viewing history data, and debugging database issues.
docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "SHOW TABLES;"
High-intent search queries and answers about installing and using this skill.
Run SQL queries using Docker Compose with the pattern: docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e 'YOUR_SQL_HERE'. This executes queries directly against your WordPress MariaDB instance and displays results in the terminal.
Yes. You can query core WordPress tables and Simple History events by running SELECT statements against your dev database. Use SHOW TABLES to discover available tables, then target specific queries to inspect user data, posts, or audit logs stored in Simple History.
Prerequisites include running Docker Compose services, storing credentials in CLAUDE.local.md, and executing commands from your docker-compose project directory. Ensure MariaDB is running and you have valid database name and user credentials.
Query each installation's database separately by specifying the correct database name and prefix in your SELECT statements. The docker compose exec pattern lets you run queries against any database and prefix, making it easy to compare data or isolate issues across environments.
Use only SELECT queries and view results with optional \G formatting for vertical output. The read-only query pattern prevents accidental UPDATE or DELETE operations, making inspection and debugging safe for production-adjacent environments.
Yes. Run SHOW TABLES to list all tables in your WordPress database, then use DESCRIBE <TABLE_NAME> to inspect column structure. This enables quick table discovery and schema inspection for debugging database issues.
alannreyesValidate docker-compose configuration, build images, and verify service health.
besoeasyQuery SQLite, PostgreSQL, and MySQL databases and export results to CSV or JSON.
hippocampus-devOrchestrate docker-compose stacks and inspect service logs.
shynlee04Generate secure, optimized SQL queries for PostgreSQL, MySQL, SQLite, Prisma, and Sequelize.
