Mysql
Connects to and queries MySQL databases using SQL, providing data retrieval and manipulation capabilities.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add g1joshi-mysql npx -- -y @trustedskills/g1joshi-mysql
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"g1joshi-mysql": {
"command": "npx",
"args": [
"-y",
"@trustedskills/g1joshi-mysql"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows AI agents to interact with and manipulate MySQL databases. It can execute SQL queries, retrieve data, and perform database operations based on natural language instructions. The agent can be used for tasks like generating reports, updating records, or querying specific information stored within a MySQL database.
When to use it
- Data Reporting: Generate summaries of data stored in your MySQL database (e.g., "Show me the total sales for each product category").
- Record Updates: Modify existing data based on specified criteria (e.g., "Update all customer records with a status of 'inactive' to 'pending'").
- Data Extraction: Retrieve specific information from your database based on complex queries (e.g., "Find all orders placed after January 1st, 2023, and sort them by order date.").
- Database Schema Exploration: Get details about tables and columns in a MySQL database (e.g., "Describe the 'customers' table").
Key capabilities
- SQL query execution
- Data retrieval from MySQL databases
- Database operation support
- Natural language processing for SQL generation
Example prompts
- "Get me all customers who live in California."
- "What is the average order value?"
- "Create a new table called 'products' with columns for name, price, and description."
Tips & gotchas
- Requires access to a MySQL database and appropriate credentials.
- The agent’s SQL generation capabilities may require refinement depending on the complexity of your database schema.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.