In this tutorial, you'll learn how to connect to a PlanetScale database using a MySQL GUI. While this tutorial uses Sequel Ace as a demonstration, many applications that connect to MySQL databases will support connecting to and querying a PlanetScale database as long as the applicaton supports connecting over SSL.
To connect to a PlanetScale database, you'll need four pieces of information:
- The database name
- Host name
The easiest way to gather this information is by accessing the branch of the database you wish to connect to and selecting the "Connect" button from the "Overview" tab.
In the Connect modal, select "General" under the Connect with options. This will display the connection details as a list instead of a language or framework-specific connection string.
As a security best practice, passwords are only displayed when they are created. If you do not know the password, you may generate a new credential set by clicking the "New password" button in the Connect modal.
In the application you are using, enter the access information you gathered in the previous step into the appropriate fields. Make sure to check "Require SSL" as SSL is required to connect to a PlanetScale database. Click "Connect" once you are finished.
If the connection is successful, you should be able to query your database and perform other supported operations.
While many standard MySQL statements are supported, there are a few caveats worth calling out:
- Each branch of a PlanetScale database is considered an isolated MySQL database. You'll need separate connection details per branch.
- Production branches with safe migrations enforce the use of branching and deploy requests to safely make schema changes and do not support direct DDL as a result. However, DDL is supported on development branches and production branches without safe migrations enabled (not recommended).
- Creating new databases is not supported using any GUI tool.
The following MySQL GUI applications have been tested and confirmed to work with PlanetScale databases: