mysql_connect

Name: mysql_connect
Availability: InStock
Author: marcosgomesebury

Validate MySQL database connectivity using environment-provided credentials.

Updated Mar 17, 2026

Search Tags:#database #mysql #connectivity #dotenv #read-only #pymysql

Ready to run

npx skills add https://github.com/marcosgomesebury/ebb-platform-ia --skill mysql-connect

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: mysql_connect
Source: https://github.com/marcosgomesebury/ebb-platform-ia/tree/main/skills/mysql_connect
Command: npx skills add https://github.com/marcosgomesebury/ebb-platform-ia --skill mysql-connect

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill provides a quick, safe way to verify MySQL database connectivity using environment-provided credentials, enabling teams to confirm access before performing read or write operations.

Core Features & Use Cases

Connection health check to a MySQL server (including Cloud SQL)
Retrieve and display server version to verify compatibility
Simple read-only query execution to validate permissions and data visibility

Quick Start

Configure the .env file with your MySQL credentials, then run the main.py script to perform a connectivity check.

Frequently Asked Questions about mysql_connect

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

FAQPage Schema

How do I test MySQL database connectivity safely using environment credentials?▼

To test MySQL database connectivity safely, you can use environment-provided credentials loaded via python-dotenv to perform a read-only query and verify access without risking data modification. This approach confirms access before executing read or write operations.

Can I run a read-only query to check permissions on a remote MySQL server?▼

Yes, you can run a simple read-only query to validate permissions and data visibility on a remote MySQL server. This checks that your configured credentials have the appropriate access levels before performing broader operations.

Does pymysql work with Cloud SQL for MySQL connection health checks?▼

Yes, pymysql supports connection health checks to Cloud SQL instances. You can identify and validate connectivity to cloud-hosted MySQL databases by running a script that attempts a connection and retrieves the server version.

How do I retrieve and display a MySQL server version to verify compatibility?▼

You can retrieve and display the MySQL server version by establishing a connection and executing a server version check. This verifies compatibility between your pymysql client and the remote or local MySQL database instance.

What do I need to configure in the .env file to validate MySQL access?▼

You need to configure your MySQL credentials in a .env file, which python-dotenv loads as environment variables. Running the main.py script then uses these variables to perform the connectivity check safely.

What is the safest way to verify MySQL access before performing write operations?▼

The safest way to verify MySQL access is to execute read-only queries using environment-provided credentials. This method validates connectivity and permissions without exposing your database to unintended write operations.