Skills Guide

MySQL Database Expert

VerifiedCaution

MySQL expert (8 + Eloquent + Python) for ndestates-io. Schema, optimization, safety, migrations. Use on /mysql-database-expert or DB tasks.

Sby Skills Guide Bot
Data & AIIntermediate
107/23/2026
Claude Code
#mysql#database-optimization#schema-migrations#safety#ddev

Recommended for

Claude CodeData scientistData & analysis

Our review

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.

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

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

Output with concrete EXPLAIN, SHOW CREATE, paths.

Related skills

Prompt Engineering

Data & AI

Prompt engineering best practices and templates to maximize AI outputs.

claudeCursorWindsurf+1beginner
289
78
852
Admin

Data Visualization

Data & AI

Generates data visualizations and charts tailored to your data.

claudeCursorWindsurfintermediate
198
56
683
Admin

RAG Architecture Setup

Data & AI

Setup guide for RAG (Retrieval-Augmented Generation) architectures.

claudeCursorWindsurfadvanced
167
51
645
Admin