Where should I store my database credentials?

Credentials should be stored in your CLAUDE.local.md file under a 'Database Access' section for the skill to read them automatically.

How does it handle complex query output?

For complex or wide results, the skill can use vertical output formatting (\G) to make the data more readable within the terminal.

Does it support WordPress Multisite installations?

Yes, the skill is configured to handle various table prefixes including those for multisite, nightly builds, and specific WordPress versions.

Does this skill require Docker to function?

Yes, this skill is designed to run SQL commands via 'docker compose exec' against a MariaDB service within your development environment.

Can I run destructive queries like UPDATE or DELETE?

Yes, however, the skill is instructed to always confirm these actions with the user first to prevent accidental data loss.

WordPress SQL Query Manager

Name: WordPress SQL Query Manager
Author: Microck

byMicrock

•

Database Management

Executes SQL queries against WordPress development databases to inspect tables, debug issues, and manage site data.

The WordPress SQL Query Manager skill empowers Claude to interact directly with MariaDB databases within Docker-based WordPress development environments. It streamlines the process of retrieving credentials from local configuration files and executing precise SQL commands across various WordPress installations, including multisite and version-specific environments. This skill is particularly effective for debugging Simple History logs, verifying data integrity, and performing rapid database inspections without needing external database clients.

Key Features

01Specialized support for Simple History event tracking and metadata

02Support for Docker-based MariaDB execution environments

03Seamless querying across multiple WordPress table prefixes

0481 GitHub stars

05Automated credential retrieval from local configuration files

06Interactive query confirmation for sensitive update or delete operations

Use Cases

01Debugging data inconsistencies across multiple WordPress versions and installations

02Rapidly inspecting table structures and record counts within containerized environments

03Monitoring Simple History events to track administrative changes during development

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