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​

Premium Team Workspaces

Next - Getting Started

Creating and Running a Query

Last modified 1yr ago