To get answers from your database, you first need to connect your database with Draxlr. The process and very simple and in a few minutes you can get started.

1. Select Your Database Type

First, you need to select your database type. It can be PostgreSQL, MySQL, MariaDB, MongoDB or something else. The List will show all the supported databases. And the ones we are working on.

Once you have selected your database, hit next.

2. Select Hosting Type

If you have selected a database type that can be hosted by various hosting providers, you will be asked to choose the hosting provider. If you have hosted your database somewhere not available in the list. You can choose Other and Hit the next button. For databases like Planetscale and YugabyteDB, the hosting provider is already known. In that case, you will go through hosting provider selection.

3. Whitelisting

If you have chosen a hosting provider where whitelisting is mandatory, you will get an additional step where you will be given the information to whitelist Draxlr’s IP Address. Or If you have chosen a database where the hosting provider is known and requires Whitelisting. Just copy the Draxlr’s IP Address and hit the Next button.

4. Add Credentials

Now you will have to add the credentials of your database. You need to provide a name for the connection. The remaining options might vary depending on the database you’re trying to connect:

  1. MongoDB - You need to provide a connection URL for your MongoDB database.
  2. BigQuery - You need to upload your JSON key file.
  3. Other - For other databases, you need to provide details like host, port, user, password, database name, etc. You can also connect to your database with SSH. If connecting with SSH, enable SSH options and enter the SSH connection details. In the case of SSH Connection. The host field will be optional.

Once you have entered your credentials. Hit the next button. It will test your connection and if everything is correct you will be redirected to the next page.

5. Schema Selection.