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

•

데이터베이스 관리

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.

주요 기능

Specialized support for Simple History event tracking and metadata
Support for Docker-based MariaDB execution environments
Seamless querying across multiple WordPress table prefixes
81 GitHub stars
Automated credential retrieval from local configuration files
Interactive query confirmation for sensitive update or delete operations

사용 사례

Debugging data inconsistencies across multiple WordPress versions and installations
Rapidly inspecting table structures and record counts within containerized environments
Monitoring Simple History events to track administrative changes during development

소개

주요 기능

Specialized support for Simple History event tracking and metadata
Support for Docker-based MariaDB execution environments
Seamless querying across multiple WordPress table prefixes
81 GitHub stars
Automated credential retrieval from local configuration files
Interactive query confirmation for sensitive update or delete operations

사용 사례

Debugging data inconsistencies across multiple WordPress versions and installations
Rapidly inspecting table structures and record counts within containerized environments
Monitoring Simple History events to track administrative changes during development