skills.rest
huangzt
huangztCOMMUNITY
Explore all skills by this author →
GitHub

mysql-tools

Execute SQL queries and inspect MySQL database schemas with Python scripts.

17|4|Updated Dec 21, 2025
Search Tags:#automation#database#schema#sql#query#mysql#tables
One-click install
npx skills add https://github.com/huangzt/my-agent-skills --skill mysql-tools
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mysql-tools
Source: https://github.com/huangzt/my-agent-skills/tree/main/skills/mysql-tools
Command: npx skills add https://github.com/huangzt/my-agent-skills --skill mysql-tools

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill provides a comprehensive set of tools to interact with MySQL databases, simplifying common database operations like connection testing, table management, schema inspection, and query execution, thereby reducing the need for manual command-line interactions or separate database clients.

Core Features & Use Cases

  • Database Connectivity: Test and establish connections to MySQL instances with configurable parameters.
  • Schema & Table Management: List all tables, views, and inspect the schema (columns, data types, indexes) of specific tables.
  • Data Querying & Manipulation: Execute arbitrary SQL queries, including SELECT, INSERT, UPDATE, and DELETE statements.
  • Database Information: Retrieve essential database and server information such as version, uptime, and connection status.
  • Use Case: Automatically generate a CSV report of all customer orders placed in the last month by querying the orders and customers tables.

Quick Start

Use the mysql-tools skill to list all tables in the 'mydatabase' database on 'localhost' with user 'root' and password 'mysecretpassword'.

Frequently Asked Questions about mysql-tools

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

FAQPage Schema
How do I inspect a MySQL database schema and list tables using Python?▼

To inspect a MySQL database schema and list tables, this Skill provides Python scripts that connect to your instance and retrieve all table names, views, and column definitions using the pymysql dependency.

Can I execute arbitrary SQL queries like SELECT or INSERT against a MySQL instance?▼

Yes, you can execute arbitrary SQL queries including SELECT, INSERT, UPDATE, and DELETE statements against a MySQL instance using the provided Python scripts for deterministic database operations.

Do I need to install pymysql to test MySQL database connections?▼

Yes, you need to install pymysql because it is the required dependency for all database interactions, enabling you to test connectivity and establish connections with configurable parameters.

What's the best way to automate retrieving MySQL server information like version and uptime?▼

The best way to automate retrieving MySQL server information is using this Skill's scripts to gather essential database details such as version, uptime, and connection status without manual command-line clients.

How do I generate a report by querying MySQL tables for recent customer orders?▼

You can generate a report by querying MySQL tables for recent customer orders by executing SQL SELECT statements across the orders and customers tables to retrieve and extract the needed data.

Related Skills

Explore More Software Engineering Skills→
KatsumitecKatsumitec

extract-channel

Extract payment channel configurations from MySQL into SQL, Markdown, and FTL files.

Official
Advanced
GeneralReasoningGeneralReasoning
4

csv-processing

Read, clean, transform, and export CSV sensor data with pandas.

Official
Intermediate
christopherlouetchristopherlouet
5

ops-database

Design database schemas, indexes, and migrations with SQL and TypeScript scripts.

Community
Advanced
wewetv1987-cellwewetv1987-cell

sql-toolkit

Create, query, migrate, and tune SQLite, PostgreSQL, and MySQL databases.

Community
Advanced