How does the skill handle database credentials?

The skill securely reads database credentials and connection details from your local CLAUDE.local.md file under the Database Access section.

Can I use this for the Simple History plugin?

Absolutely. The skill includes specific patterns for querying wp_simple_history and wp_simple_history_contexts tables to track site changes.

What environment is required for this skill?

This skill requires a Docker Compose-based development environment where the database service is named 'mariadb' and the project directory is accessible.

Is it safe to run destructive SQL commands?

The skill includes safety protocols that require it to confirm any UPDATE or DELETE queries with the user before execution to prevent accidental data loss.

Does it support multiple WordPress versions?

Yes, it is pre-configured to handle various table prefixes including nightly builds, version-specific installs (6.0 to 6.6), multisite, and PHP-specific environments.

WordPress SQL Manager

Name: WordPress SQL Manager
Author: Microck

byMicrock

•

Database Management

Executes SQL queries against WordPress Docker environments to inspect data, debug issues, and manage database tables.

About

This skill enables Claude to interact directly with WordPress development databases hosted in Docker containers. It automates the process of fetching credentials from local configuration files, constructing complex Docker Compose commands, and executing SQL for tasks like inspecting Simple History events, auditing table prefixes across multiple versions, and debugging data integrity issues. By streamlining the bridge between the AI and MariaDB containers, it allows developers to perform deep database introspection without manually switching contexts or typing verbose command strings.

Key Features

Direct SQL execution via Docker Compose MariaDB containers
Safe execution with mandatory user confirmation for UPDATE and DELETE queries
81 GitHub stars
Automated credential retrieval from CLAUDE.local.md
Specialized querying for Simple History event logs and metadata
Support for multiple WordPress table prefixes and versioned installs

Use Cases

Performing quick table schema inspections and record counts during plugin or theme development
Debugging data inconsistencies across different WordPress core versions in a local environment
Auditing audit logs and event history within the Simple History plugin database tables

About

Key Features

Direct SQL execution via Docker Compose MariaDB containers
Safe execution with mandatory user confirmation for UPDATE and DELETE queries
81 GitHub stars
Automated credential retrieval from CLAUDE.local.md
Specialized querying for Simple History event logs and metadata
Support for multiple WordPress table prefixes and versioned installs

Use Cases

Performing quick table schema inspections and record counts during plugin or theme development
Debugging data inconsistencies across different WordPress core versions in a local environment
Auditing audit logs and event history within the Simple History plugin database tables