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. Arctype has a native integration with PlanetScale which you can read about in the Arctype <> PlanetScale Docs. To connect to only the main branch, read on below.

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.

Get help on databases and SQL. Join our Discord community.