PlanetScale is a serverless database platform that is easy to spin up and can scale as your volume of data grows. It is based on MySQL. It is straightforward to connect to PlanetScale with the Arctype SQL Client.
From the Overview Page, select the Connect dropdown to view your credentials. You can follow PlanetScale’s guide on connection strings to set these up.
The first time you generate your password you will need to copy it. If you do not you will need to regenerate your password.
Add a connection to Arctype with these credentials. Make sure to select Connect with SSL as Planetscale uses a certificate to secure your connection.
Select the CA Cert SSL option to open a file upload dialogue. Note that this certificate is never saved to Arctype servers, only locally. For Mac, the certificate is located in
/etc/ssl/cert.pem. When you select ‘CA Cert’ you will need to navigate to the top level of your Mac harddrive and then press Command + Shift + . to show hidden folders. Select the
private folder and navigate to
/ect/ssl/cert.pem from there, as shown below.
Click Test Connection and Save to view your PlanetScale database!
When you connect to your database through this method, you connect on the
main branch which is locked from allowing schema, or DDL, changes. This means that SQL commands like CREATE TABLE, ALTER COLUMN, and DELETE TABLE will not work. Similarly, Arctype features like the table editor will not have any effect. Instead you can make these changes on a separate branch in PlanetScale and deploy them to main. Data manipulation such as INSERT rows, DELETE rows, and other non-schema SQL commands all work perfectly.