mysql-tools

Community

Manage MySQL databases with ease.

Authorhuangzt
Version1.0.0
Installs0

System Documentation

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'.

Dependency Matrix

Required Modules

pymysql

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: mysql-tools
Download link: https://github.com/huangzt/my-agent-skills/archive/main.zip#mysql-tools

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.