mysql

Query and manage MySQL databases from the command line.

2|1|Updated Jul 19, 2024
One-click install
npx skills add https://github.com/TeamDay-AI/agents --skill mysql-teamday-ai
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: mysql
Source: https://github.com/TeamDay-AI/agents/tree/main/skills/teamday/mysql
Command: npx skills add https://github.com/TeamDay-AI/agents --skill mysql-teamday-ai

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Many teams need to query and administer MySQL databases across cloud providers and self-hosted instances without a GUI, consolidating connectivity, query execution, and basic maintenance into a single command-line skill.

Core Features & Use Cases

  • Connect to MySQL-compatible services (PlanetScale, AWS RDS, Google Cloud SQL) or any MySQL instance using host/user/password or a URL.
  • Execute ad-hoc queries, describe schemas, show tables, and export results for reporting.
  • Automate common tasks like listing databases, exporting data to CSV/JSON, and validating connections in CI/CD pipelines.

Quick Start

Connect to your MySQL host using the provided credentials and run a sample query to verify connectivity.

Frequently Asked Questions about mysql

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

FAQPage Schema
How do I query a MySQL database from the command line?▼

You can query a MySQL database from the command line by providing credentials via MYSQL_URL or separate host variables, then executing SQL statements directly in a Bash environment to retrieve results.

Can I connect to AWS RDS or Google Cloud SQL using CLI?▼

Yes, you can connect to AWS RDS, Google Cloud SQL, PlanetScale, or self-hosted MySQL instances via CLI by supplying the appropriate connection credentials to execute queries and manage schemas.

How do I export MySQL query results to CSV or JSON?▼

You can export MySQL query results to CSV or JSON formats by running export recipes through the command line, which facilitates reporting and data extraction for external CI/CD pipelines.

Do I need a GUI client to manage MySQL schemas?▼

No, you do not need a GUI client to manage MySQL schemas. You can describe schemas, show tables, and administer databases entirely from the command line using Bash.

What credentials are required to connect to a MySQL instance?▼

To connect to a MySQL instance, you need to provide credentials either as a single MYSQL_URL string or as separate MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD, and MYSQL_DATABASE environment variables.

Can I validate MySQL database connections in a CI/CD pipeline?▼

You can validate MySQL database connections in a CI/CD pipeline by executing a sample query from the command line using Bash, ensuring the provided credentials successfully reach the target database.