Sitemap
TeamSQL

SQL and Database Tutorials using TeamSQL| MySQL, PostgreSQL, Microsoft SQL Server, Amazon Redshift and Redis

TeamSQL Quick Start for macOS

3 min readMar 22, 2017

--

This guide is designed to get you up and running with TeamSQL as quickly as possible.

Installation

  1. Download TeamSQL.
  2. Drag and drop the TeamSQL icon onto the icon for your Applications folder.
Press enter or click to view image in full size

3. Wait for the files to copy to your Applications folder.

Press enter or click to view image in full size

Launch TeamSQL

  1. Once TeamSQL has been installed, you can launch it using its icon located in your Launchpad.
  2. You will be asked to register to use TeamSQL.
Press enter or click to view image in full size

If you already have an account, click Log In and provide your access credentials.

Press enter or click to view image in full size

3. Once you’ve registered and logged in, you will be asked to connect to your database server.

Connect to Your Database Server

Before you can connect to your database server, you’ll need to set up a connection to it in TeamSQL.

Create a New Connection

Currently, TeamSQL integrates with the following services:

  • MySQL
  • PostgreSQL
  • Microsoft SQL Server
  • AWS RedShift

To start using TeamSQL, click Create a connection to launch the Add Connection window.

Press enter or click to view image in full size

Provide the requested details to set up your new connection:

Press enter or click to view image in full size

Database Type
The database type you’re using

Get Can Abacıgil’s stories in your inbox

Join Medium for free to get updates from this writer.

Connection Name
The descriptive name for your connection

Host
The address at which your database can be reached

Port
3306 (populated by default)

User Name
The username you use to log in to your database

Password
The password you use to log in to your database

Default Database
The default database on the server you’re using

Production Server?
The flag that indicates whether your server is used in an Production environment or not

Please note that TeamSQL does not store any of your database server credentials in the cloud. They are only stored locally.

Before saving, you can check your inputs by clicking Test Connection.

When done, click Save.

Connect to Your Database

By default, TeamSQL displays the connections you’ve added in the left-hand navigation panel. To enable the connection, click on the socket icon.

Press enter or click to view image in full size

Once connected, you’ll see a green dot next to your connection name, as well as a list of the databases on your server.

Press enter or click to view image in full size

Congratulations! You are now ready to use TeamSQL.

--

--

TeamSQL

Published in TeamSQL

SQL and Database Tutorials using TeamSQL| MySQL, PostgreSQL, Microsoft SQL Server, Amazon Redshift and Redis