Connecting to Postgres or MySQL database

If you have data sitting around in a Postgres or MySQL database and you don’t have the tools or know-how to access them, this article is for you. We are going to use Mammoth Analytics, one of favorite data management platforms, for this exercise.

Pre-requisites : You will need access to the publicly accessible host name (url) along with the database name and credentials.

Step 1 : Log into Mammoth Analytics Use either an existing account or sign up for a free trial.

Step 2 : In the Connectors section, select the Postgres or MySQL database

Step 3 : Click on the New Connection and enter the credentials

Step 5 : Select your tables Once you’ve logged in, you’ll see a list of table in the database on the left-hand side. If you select one, a SQL query will automatically be generated for you. For more complex queries, you can do a quick search for SQL queries on the internet.

Step 6 : Set a schedule (or not) You’re given the option to retrieve this data once or on a scheduled interval. In this case, we will select Just once.

You're done! Your data is now ready. You can take further action on it with the platform or just download it as a CSV file (which can be opened with MS Excel) or export into Google Sheets.