MySQL

Connect to MySQL databases from Airplane tasks and runbooks.
The MySQL resource allows tasks to connect to a MySQL database. For a high-level introduction to resources, see the resources page.

Creating a MySQL resource

To create a new MySQL resource, visit resources for your team, click the "New" button, and select the MySQL resource type. Enter your connection details in the form:
Name should be a human-readable name for your resource.
Host should be the IP address or DNS name of your database. Unless you're connecting to this database behind a self-hosted agent (see Private Networking below), this should be the public IP address and/or the public DNS name of the database.

IP whitelisting

If your database has restrictions on incoming network connections, you'll need to ensure the Airplane IP addresses are whitelisted:
  • 34.121.89.145
  • 34.68.100.27
  • 34.72.182.225

Private networking

To connect to a database inside a private VPC, you can self-host the agent and run the agent within your own VPC. Since tasks and SQL queries run on agents, these tasks will run from within your network and be able to connect.

Accessing from tasks

You can issue SQL queries against your MySQL resource from tasks by using the SQL SDK. See SQL SDK reference for more information.

Field reference

When this resource is attached to a task, its fields are available in the JSON environment variable AIRPLANE_RESOURCES under the alias it was attached with. For more information, see the MySQL field reference.