Links

Connecting to a Database

Connect to Postgres, MySQL, and PlanetScale with Arctype.
Arctype makes it easy to connect to all of your Postgres, MySQL, and PlanetScale databases. Here's how:

Creating a Workspace

Start by creating a new workspace. A workspace is a defined space for a given project or similar files.

Choosing a Connection Type

Once you have created a workspace, you'll see a list of connection types. Arctype supports Postgres, MySQL, SQLite and many other types of databases.
A workspace can have multiple connections.

Entering Database Credentials

For details on the inputs of each connection, see below. After entering Host, Username, Password, and Database Name, test your connection and save. Alternatively, you can paste a connection string (provided by Heroku, Railway, and others) into the "Connection URL" input. You're all done!
The Connection screen where you enter your credentials
In Team Workspaces, connections are synced if the toggle Sync to Cloud and Share with Team is selected in the Connection menu.
This toggle can be deselected to prevent the sharing of a Connection. In this case, team members must manually input connection details to connect to databases in the team workspace. SSL certificates and SSH keys are never synced and must be sent separately to each workspace member.
Arctype uses Amazon Web Services (AWS) to host its servers. Arctype databases are on private networks and not accessible from external networks. Connection information is encrypted, backed by AWS Key Management Service. For more information please see the Arctype Security Practices page.

Connecting to PlanetScale

To add your PlanetScale database(s), you must first set up the PlanetScale CLI and run pscale auth login in your command line. Then, in Arctype, select the PlanetScale connection type and click 'Authenticate with PlanetScale CLI', select the desired organization and database and click 'Generate Service Token':

Database Credentials Cheat Sheet

Refer to the Arctype database resource guides for MySQL, Postgres, and SQLite if you need more information.

MySQL

  • Name your connection is primarily for you to keep track of your connections. (optional)
  • Host is the hostname of your database server
  • Port is where it is hosted. The default is 3306
  • User is your username
  • Password is the password for your database
  • For Database, use the name of your database

PostgreSQL

  • Name your connection is primarily for you to keep track of your connections. (optional)
  • Host is the hostname of your database server
  • Port is where it is hosted. The default is 5432
  • User is your username
  • Password is the password for your database
  • For Database, use the name of your database
If you're using a localhost database, download our desktop app from arctype.com