Automated summary

MySQL expert for ndestates-io, specializing in schema design, query optimization, migrations, and safety, with DDEV-based execution.

Strengths

Delivers concrete analysis with EXPLAIN, SHOW CREATE, and file paths
Uses a recovery-first approach to prevent destructive changes
Runs a security checklist automatically after each schema change
Leverages project cache and existing migrations for consistency

Limitations

Tied to the ndestates-io project and its DDEV environment
Does not work with databases other than MySQL
Requires prior execution of /load-project-cache-first

When to use it

When optimizing MySQL queries, designing or reviewing a schema, or performing migrations within the ndestates-io project.

When not to use it

For tasks outside ndestates-io or involving non-MySQL databases.

Security analysis

Caution

Quality score85/100

The skill focuses on MySQL database operations with explicit safety guards (never destructive on live db, use test DB, recovery-first). No destructive or exfiltrating commands are included, but its purpose inherently involves powerful database tools, warranting caution.

Findings

•Involves database schema manipulation and migration execution, which could impact data integrity if used incorrectly.
•Depends on external instructions file (.grok/agents/mysql-database-expert.md) which may contain further commands.

How this analysis is made

Examples

Optimize valuation queries

/mysql-database-expert optimize valuation queries

Review PropertySalesRecord schema

/mysql-database-expert review PropertySalesRecord schema

Run security checklist after schema change

/mysql-database-expert run security checklist after schema change

name: mysql-database-expert description: > MySQL expert (8 + Eloquent + Python) for ndestates-io. Schema, optimization, safety, migrations. Use on /mysql-database-expert or DB tasks. argument-hint: "Scope, e.g. 'optimize valuation queries', 'review PropertySalesRecord schema'" user-invocable: true disable-model-invocation: false

MySQL Database Expert

Name: MySQL Database Expert
Author: Skills Guide Bot

Run /load-project-cache-first (CONVENTIONS, TESTING, CONCERNS).
Read and embody the full instructions in .grok/agents/mysql-database-expert.md.
All via DDEV; confirm test DB for checks.
Never destructive on live db; follow recovery-first.
After schema work run security checklist.
Cite cache + migrations.

Output with concrete EXPLAIN, SHOW CREATE, paths.

From the file to a first result

The download contains exactly the content displayed on this page. This copy may differ from the latest version in the source repository.

View the source and supporting files

This download contains SKILL.md only. Any scripts, references, templates and dependencies are not included. Get the required files from the source, preserving their directory structure, before continuing.

1. Download the file

Download SKILL.md

From the root of a test project, save the file as .skill-downloads/mysql-database-expert-mrwakg0y/SKILL.md, or use the command below. This folder is for inspecting the skill before installation.

Command for macOS/Linux or WSL: requires a POSIX shell and curl. On Windows without WSL, use the download button and create the folder manually.

mkdir -p '.skill-downloads/mysql-database-expert-mrwakg0y' && curl --fail --show-error --location 'https://skills-guides.com/api/skills/mysql-database-expert-mrwakg0y/download' --output '.skill-downloads/mysql-database-expert-mrwakg0y/SKILL.md.part' && mv '.skill-downloads/mysql-database-expert-mrwakg0y/SKILL.md.part' '.skill-downloads/mysql-database-expert-mrwakg0y/SKILL.md'

2. Check prerequisites

Read SKILL.md before using it. If it references scripts or external services, inspect them and prepare the required access in your test environment.

No recognized prerequisites section in this file. This does not mean it is self-contained: libraries, tools and access requirements may be mentioned elsewhere in the content or source repository.

The platforms on this page are catalog indications. The paths below follow tool documentation; they do not prove this skill has been run in those tools. No minimum tool version is confirmed for this listing.

3. Load the skill

After inspection, copy the complete folder into your project using one of the commands below, then open a new tool session. The command stops if a folder with the same name already exists: compare the files before replacing it.

Claude Code

test -f '.skill-downloads/mysql-database-expert-mrwakg0y/SKILL.md' && test -s '.skill-downloads/mysql-database-expert-mrwakg0y/SKILL.md' && mkdir -p '.claude/skills' && test ! -e '.claude/skills/mysql-database-expert' && cp -R '.skill-downloads/mysql-database-expert-mrwakg0y' '.claude/skills/mysql-database-expert'

OpenSkills

OpenSkills must already be installed. The local install/read procedure is checked with OpenSkills 1.5.0, which requires Node.js ≥ 20.6.0. Catalog slugs are not resolved automatically.

Official OpenSkills installation

openskills install './.skill-downloads/mysql-database-expert-mrwakg0y'

openskills read 'mysql-database-expert-mrwakg0y'

Reading should display the installed file content and its base directory. It does not run the skill or install its dependencies.

For an agent that reads AGENTS.md, then sync the index. This command changes AGENTS.md: review the diff before using it.

openskills sync

Manual method or another tool: attach SKILL.md to a conversation, or open it in an agent that can read files. Include any required supporting resources. No universal folder is recognized by every tool.

4. Try a first task

Use a short, synthetic input: an API endpoint, a small document or an interface brief. In a new conversation, attach the file or give the agent its path, then adapt this request:

Read .skill-downloads/mysql-database-expert-mrwakg0y/SKILL.md and apply its instructions to this example: [describe a test input]. Identify any missing files, dependencies or access. Produce the result requested by the skill without inventing data or running unreviewed scripts.

Expected result: output matching the skill instructions, or a precise list of missing prerequisites. A read confirmation alone does not validate a first use. If an external resource is unavailable, that path remains untested.

Related skills

Create Interactive Maps with kepler.gl

Data & AI

Create interactive map visualizations and export standalone HTML using the keplergl Python package. Use to plot geospatial data from DataFrames, GeoJSON, or CSV.

Claude CodeCursorCodexintermediateSafe 11,995

Skills Guide Bot