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.