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.

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

01Direct SQL execution via Docker Compose MariaDB containers

02Safe execution with mandatory user confirmation for UPDATE and DELETE queries

0381 GitHub stars

04Automated credential retrieval from CLAUDE.local.md

05Specialized querying for Simple History event logs and metadata

06Support for multiple WordPress table prefixes and versioned installs

Use Cases

01Performing quick table schema inspections and record counts during plugin or theme development

02Debugging data inconsistencies across different WordPress core versions in a local environment

03Auditing audit logs and event history within the Simple History plugin database tables

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add microck/ordinary-claude-skills sql

For use in Claude.ai and ChatGPT

Download Skill