skills.rest
tusosos
tusososCOMMUNITY
Explore all skills by this author →
GitHub

mysql

Execute read-only SQL queries across multiple MySQL databases.

Updated Apr 3, 2026
Search Tags:#database#queries#safety#data-analysis#mysql#read-only
One-click install
npx skills add https://github.com/tusosos/manus-knowledge-base --skill mysql-tusosos
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mysql
Source: https://github.com/tusosos/manus-knowledge-base/tree/main/skills/mysql
Command: npx skills add https://github.com/tusosos/manus-knowledge-base --skill mysql-tusosos

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires mysql-connector-python, and includes scripts (resource) components.

What problem does it solve?

Execute read-only SQL queries against multiple MySQL databases to enable safe data exploration and analysis without risking accidental data modification.

Core Features & Use Cases

  • Read-only query execution across configured MySQL connections
  • Automatic database selection using descriptive matching to user intent
  • Safe operations with enforced read-only mode and query validation
  • Use Case: Inspect production data by quickly listing key tables and sampling rows

Quick Start

Query the configured production database to retrieve the first 10 rows from the users table.

Frequently Asked Questions about mysql

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

FAQPage Schema
How do I run read-only MySQL queries to safely explore production data?▼

Read-only MySQL queries safely explore production data by enforcing read-only sessions and validating queries to prevent accidental data modification. This allows you to retrieve rows and inspect tables without write risks.

Can I connect to multiple MySQL databases and auto-select the right one?▼

Yes, you can connect to multiple MySQL databases with descriptive auto-selection. The system matches your query intent against configured connections to automatically select the correct database for your data analysis.

What Python version and dependencies do I need to execute MySQL queries?▼

Executing MySQL queries requires Python 3.8 or higher and the mysql-connector-python dependency. You must install this connector to enable the script components to interface with your configured databases.

How does query validation work for safe data analysis in MySQL?▼

Safe data analysis query validation works by enforcing read-only mode on the MySQL session, ensuring that any SQL statements executed are restricted to data retrieval and cannot alter the underlying database structure or records.

What are the limitations of using read-only sessions for database queries?▼

The limitation of read-only sessions for database queries is the inability to execute INSERT, UPDATE, or DELETE statements. This approach restricts operations strictly to data exploration and retrieval, preventing any data modifications.

Related Skills

Explore More Data & Analytics Skills→
wfukatsuwfukatsu
12

analyze-mysql-schema

Extract MySQL database schema details and generate Markdown reports.

Community
Advanced
gman-roboticsgman-robotics

data-analysis

Analyze Excel and CSV files with DuckDB SQL queries and export results.

Official
Intermediate
lukegob10lukegob10

schema-exploration

Automate schema discovery and relationship mapping in relational databases.

Community
Intermediate
Interstellar-codeInterstellar-code
17

sql-cli

Execute SQL queries against MySQL and PostgreSQL databases from the command line.

Community
Advanced