db-mysql

Execute read-only SQL queries against MySQL or MariaDB databases.

520|175|Updated Apr 8, 2026
One-click install
npx skills add https://github.com/evolution-foundation/evo-nexus --skill db-mysql-evolution-foundation
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: db-mysql
Source: https://github.com/evolution-foundation/evo-nexus/tree/main/.claude/skills/db-mysql
Command: npx skills add https://github.com/evolution-foundation/evo-nexus --skill db-mysql-evolution-foundation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pymysql, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps you answer data questions by running read-only SQL against MySQL or MariaDB instances configured in your .env, without manually handling database drivers, connection setup, or result parsing.

Core Features & Use Cases

  • Query MySQL/MariaDB from .env: Select a connection by human label (or numeric index) and execute a single SQL statement.
  • Read-only guardrails: Write verbs are refused unless DB_MYSQL_N_ALLOW_WRITE=true is explicitly enabled for that connection block.
  • Practical exploration tools: List tables and describe table schemas to help form correct queries.

Use case: You need to audit how many new customers were created in the last 7 days and quickly inspect the columns for a relevant table; run a count query, then describe the table to verify column names and types.

Quick Start

Ask your AI to run a read-only query: "Query the orders-dev MySQL database for the number of customers created in the last 7 days."

Frequently Asked Questions about db-mysql

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

FAQPage Schema
How do I run read-only SQL queries against a MySQL database to validate data?

To run read-only SQL queries for data validation, this Skill executes single SQL statements against MySQL or MariaDB databases configured in your .env, returning answer-ready result rows while automatically blocking write operations unless explicitly allowed per connection.

What is the safest way to explore MySQL table schemas for SQL querying?

The safest way to explore MySQL table schemas is by retrieving table lists and column descriptions through labeled read-only connections, which this Skill provides to help you verify names and types before forming SQL queries.

Can I use pymysql to query multiple labeled MySQL connections for different environments?

Yes, you can query multiple labeled MySQL connections for different environments by selecting a connection via human label or numeric index, using pymysql to handle driver execution against each .env configured block.

How do I handle large MySQL query results for database auditing without truncation?

To handle large MySQL query results during database auditing, this Skill enforces a max row cap with truncation handling and can stream full result sets to a CSV file, ensuring you capture complete datasets beyond the JSON return limit.

Does this MySQL querying approach work with MariaDB and enforce single-statement execution?

Yes, this MySQL querying approach works with MariaDB and enforces single-statement execution with a session execution timeout, preventing multi-statement injection and ensuring query isolation for safe data retrieval operations.