Can I use this skill on a production database?

No, this skill is designed for development environments using Docker Compose to ensure safety and prevent accidental data loss in live environments.

Which WordPress table prefixes are supported?

It supports standard prefixes like wp_, as well as wp_nightly_ for nightly builds and wp_multisite_ for multisite installations.

Does Claude require confirmation before modifying data?

Yes, the skill is programmed to always ask for explicit user confirmation before running any UPDATE or DELETE SQL queries.

How does the skill handle database credentials?

The skill reads database access credentials directly from your local CLAUDE.local.md file to maintain a secure and automated workflow.

WordPress SQL Query Manager

Name: WordPress SQL Query Manager
Author: bonny

bybonny

•

315

•

データベース管理

Executes SQL queries against WordPress development databases to inspect audit logs, debug table structures, and manage activity data.

This skill enables Claude to interact directly with WordPress development databases, specifically optimized for the Simple History plugin ecosystem. It allows users to run SQL queries, inspect table schemas, and analyze activity logs through Docker-based MariaDB commands. By providing direct access to the wp_simple_history and wp_simple_history_contexts tables, it streamlines the debugging of audit events and database states. For security, it focuses on development environments and enforces mandatory user confirmation before executing any data-modifying operations like UPDATE or DELETE.

主な機能

01Support for standard, nightly, and multisite table prefixes

02315 GitHub stars

03Inspect WordPress and Simple History table structures

04Execute raw SQL queries via Docker Compose MariaDB

05Safety-first workflow with confirmation for destructive commands

06Analyze audit log events and contextual metadata

ユースケース

01Verifying database schema changes during plugin development

02Debugging missing or incorrect activity log entries in WordPress

03Extracting specific user event history for auditing and troubleshooting

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bonny/wordpress-simple-history sql

For use in Claude.ai and ChatGPT

Download Skill