mysql-read

Execute read-only MySQL queries to inspect schema and retrieve reference data.

8|1|Updated Mar 1, 2026
One-click install
npx skills add https://github.com/JoeCP17/LLM-Dot-files --skill mysql-read
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: mysql-read
Source: https://github.com/JoeCP17/LLM-Dot-files/tree/main/codex/skills/mysql-read
Command: npx skills add https://github.com/JoeCP17/LLM-Dot-files --skill mysql-read

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires docker, aws, python3, and includes scripts (resource) components.

What problem does it solve?

This Skill lets you validate MySQL schema and quickly look up data without manually managing credentials or risking accidental writes.

Core Features & Use Cases

  • Read-only SQL execution: Runs only safe query types (e.g., SELECT/SHOW/DESCRIBE/EXPLAIN) to prevent mutations.
  • Two target environments: Query local Thomas Docker MySQL or dev Aurora using AWS Secrets Manager credentials.
  • Practical lookup workflows: Supports common business checks like NATION/STATE mapping and lightweight schema inspection.

Quick Start

Use mysql-read to run a read-only query against the local Docker MySQL for database hmmall to inspect schema or counts.

Frequently Asked Questions about mysql-read

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I run read-only MySQL queries against a local Docker database?

Run read-only MySQL queries against local Docker MySQL by validating SQL statements start with SELECT, SHOW, DESCRIBE, DESC, EXPLAIN, or WITH, blocking mutating keywords before execution to prevent accidental writes.

How can I inspect an AWS Aurora MySQL schema using Secrets Manager?

Inspect AWS Aurora dev MySQL schema by connecting through an AWS profile and retrieving credentials via AWS Secrets Manager, enabling safe schema inspection and data retrieval without manual authentication management.

How do I prevent accidental data mutations when executing SQL queries?

Prevent accidental data mutations by enforcing SQL validation that checks queries start with safe types like SELECT or SHOW and blocks mutating keywords before executing docker-based MySQL access.

Can I use this to check NATION and STATE mapping in a MySQL database?

Check NATION and STATE mapping in MySQL by running read-only SELECT queries to retrieve reference data, supporting practical lookup workflows for common business mapping validations.

Do I need Docker and AWS CLI installed to query local and dev MySQL databases?

Docker, AWS, and Python3 are required dependencies to query local Docker MySQL and dev Aurora environments, enabling access to the Thomas repo seed data and AWS Secrets Manager credentials.

What SQL statement types are allowed during MySQL schema inspection?

MySQL schema inspection allows SQL statement types including SELECT, SHOW, DESCRIBE, DESC, EXPLAIN, and WITH, ensuring only safe read-only queries execute while mutating keywords remain blocked.