All Skills Search Tools

|

Loading...

AI Agent Skills Directory with categorization, English/Chinese translation, and script security checks.

Sitemap

Home
All Skills
Search
Tools

About

About Us
Disclaimer
Copyright

Help

FAQ
Privacy
Terms

Contact Us:osulivan147@qq.com

© 2026 Skill4Agent. All rights reserved.

Home/All Skills/Backend Development/mysql

mysql

Original：🇺🇸 English

Translated

1 scriptsChecked / no sensitive code detected

MySQL database administration and development

4installs

Sourcepluginagentmarketplace/custom-plugin-sql

Added on2026-02-04

NPX Install

npx skill4agent add pluginagentmarketplace/custom-plugin-sql mysql

Tags

Translated version includes tags in frontmatter

mysql-administration mysql-development performance-optimization high-availability database-backup

SKILL.md Content

View Translation Comparison →

MySQL Skill

Overview

Master MySQL database administration, optimization, and development for production environments.

Topics Covered

MySQL Basics

Installation and configuration
User management
Database creation
Storage engines (InnoDB, MyISAM)
Character sets

Query Development

SELECT statements
JOINs and subqueries
INSERT, UPDATE, DELETE
Stored procedures
Triggers and events

Performance

EXPLAIN analysis
Index optimization
Query cache (8.0+ changes)
Slow query log
Performance Schema

Administration

Backup with mysqldump
Binary log management
Replication setup
User privileges
Configuration tuning

High Availability

MySQL replication
Group replication
MySQL Router
ProxySQL
Failover strategies

Prerequisites

SQL fundamentals
Linux basics
Networking concepts

Learning Outcomes

Administer MySQL servers
Optimize queries
Set up replication
Manage backups

Download

Download TranslatedIncludes original Skill.md

(5.7 KB)Download Original(4.8 KB)

Related Skills

golang-patterns

Idiomatic Go patterns, best practices, and conventions for building robust, efficient, and maintainable Go applications.

create-auth-skill

Skill for creating auth layers in TypeScript/JavaScript apps using Better Auth.

postgresql-optimization

PostgreSQL-specific development assistant focusing on unique PostgreSQL features, advanced data types, and PostgreSQL-exclusive capabilities. Covers JSONB operations, array types, custom types, range/geometric types, full-text search, window functions, and PostgreSQL extensions ecosystem.

nuget-manager

Manage NuGet packages in .NET projects/solutions. Use this skill when adding, removing, or updating NuGet package versions. It enforces using `dotnet` CLI for package management and provides strict procedures for direct file edits only when updating versions.