App overview screenshotSQL and Database Guides
Try our free SQL Client
Connecting to MySQL
Connecting to drivers
Installing MySQL
Setting up MySQL
MySQL   >   
Setting up MySQL   >   
PlanetScale on Mac

Connect to PlanetScale on Mac

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.

Obtain Credentials

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.

planetscale credentials connection string

The first time you generate your password you will need to copy it. If you do not you will need to regenerate your password.

Enter your Credentials in the SQL Client

Add a connection to Arctype with these credentials. Make sure to select Connect with SSL as Planetscale uses a certificate to secure your connection.

arctype connection page

Import the CA Certificate into Arctype

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.

finder import SA certificate Arctype

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.

Want to ask for help on databases or SQL? Join our Discord community.