mysql
Manage MySQL databases via the mysql CLI.
Works with
--- name: mysql description: Manage MySQL databases via the mysql CLI. license: MIT --- # mysql Use `mysql` to interact with MySQL databases. ## Setup The `mysql` client is installed in `.codebuddy/bin/`. You can execute it directly or add it to your PATH. ## Common Commands ### Connection - Connect: `.codebuddy/bin/mysql -h <host> -P <port> -u <user> -p` - Connect (Docker example): `.codebuddy/bin/mysql -h 127.0.0.1 -P 3306 -u root -p` ### Quick Alias To make it easier to run, you can alias it in your shell: `alias mysql="./.codebuddy/bin/mysql"` ### Operations - Show databases: `SHOW DATABASES;` - Use database: `USE <dbname>;` - Show tables: `SHOW TABLES;` - Describe table: `DESCRIBE <table_name>;` - Execute query: `SELECT * FROM table LIMIT 10;` - Quit: `exit` ## Notes - The binary is located at: `.codebuddy/bin/mysql` - Password can be supplied via `MYSQL_PWD` environment variable (careful!) or typically prompted interactively.
More Database skills
prisma-mongodb-upgrade
prisma/skills
Decision and migration guide for Prisma ORM MongoDB projects on v6, which have no upgrade path to v7. Use when a MongoDB project asks about upgrading Prisma, when "upgrade to prisma 7" comes up in a project with provider = "mongodb", or when evaluating a move to Prisma Next. Triggers on "upgrade prisma mongodb", "prisma 7 mongodb", "mongodb prisma migration", "prisma next mongodb".
azure-upgrade
microsoft/azure-skills
Assess and upgrade Azure workloads between plans, tiers, or SKUs, or modernize Azure SDK dependencies in source code. WHEN: upgrade Consumption to Flex Consumption, upgrade Azure Functions plan, change hosting plan, function app SKU, migrate App Service to Container Apps, modernize legacy Azure Java SDKs (com.microsoft.azure to com.azure), migrate Azure Cache for Redis (ACR/ACRE) to Azure Managed Redis (AMR).
azure-cost-optimization
microsoft/azure-skills
Identify Azure cost savings from usage and spending data. USE FOR: optimize Azure costs, reduce Azure spending/expenses, analyze Azure costs, find cost savings, generate cost optimization report, identify orphaned resources to delete, rightsize VMs, reduce waste, optimize Redis costs, optimize storage costs, AKS cost analysis add-on, namespace cost, cost spike, anomaly, budget alert, AKS cost visibility. DO NOT USE FOR: deploying resources (use azure-deploy), general Azure diagnostics (use azure-diagnostics), security issues (use azure-security)
