技能檔案

Sql

Name: Sql
Author: Microck

Run SQL queries against the WordPress development database. Use when querying database tables, inspecting Simple History events, checking WordPress data, or debugging database issues.

Microck172 星標2025年12月2日

職業
分類: SQL 數據庫

技能內容

Run SQL Queries

You are tasked with running SQL queries against the WordPress development database.

Prerequisites

Database credentials are stored in CLAUDE.local.md under "Database Access"
Docker compose services must be running
Commands must be run from the docker-compose project directory

Command Pattern

docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "YOUR_SQL_HERE"

Refer to CLAUDE.local.md for the actual credentials and connection details.

Examples

Show all tables

相關技能

Sql | Skills Pool

docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "SHOW TABLES;"

docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "SELECT * FROM wp_simple_history ORDER BY id DESC LIMIT 10;"

docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "DESCRIBE wp_simple_history;"

docker compose exec mariadb mysql -u<USER> -p<PASSWORD> <DATABASE> -e "SELECT COUNT(*) FROM wp_posts;"

Prefix	Installation
`wp_`	Main install (wordpress_mariadb)
`wp_nightly_`	Nightly build
`wp_6_0_` to `wp_6_6_`	Version-specific installs
`wp_multisite_`	Multisite install
`wp_php74_`	PHP 7.4 install
`wp_subfolder_`	Subfolder install

Sql

Run SQL Queries

Prerequisites

Command Pattern

Examples

Show all tables

Sql

Run SQL Queries

Prerequisites

Command Pattern

Examples

Show all tables

Query Simple History events

Describe a table structure

Count records

Table Prefixes

Simple History Tables

Instructions

Notes

Postgres Patterns

Postgres Patterns

Database Migrations

Postgres Patterns

Postgres Patterns

Jpa Patterns