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.