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

Connect to PlanetScale on Linux

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 Ubuntu, the certificate is located in the /ect/ssl/certs folder and is called ca-certificates.crt.

filebrowser import SA certificate Arctype

For other linux distributions, see PlanetScales’s guide on secure connections to find their location in the filesystem.

Click Test Connection and Save to view your PlanetScale database!

Limitations

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.