Connect your SQL database to Geckoboard using Databases

Applicable Pro plans:
Basic (1 DB connection)  Team (2 DB connections)

To connect your Database to Geckoboard, you must be on a Pro plan.

Before you start

Run through this checklist to prepare your database for connecting to Geckoboard:

  • Verify that your database is running correctly.
  • Ensure your database accept connections from these Geckoboard IP addresses:

    23.23.205.140, 50.16.244.16, 54.204.39.96, 54.243.225.101, 54.243.235.136, 54.243.235.173
  • Geckoboard only allows SELECT queries, but for extra security, we only accept connections from users that have read-only access to the DB.
  • Connections between Geckoboard and your database will be encrypted so your database must have TLS encryption enabled.

Otherwise, let us know.

Our Databases data source currently support MySQL, PostgreSQL, and Amazon Redshift databases.We support MySQL, PostgreSQL, and Amazon Redshift

Tip

If your database doesn't allow SSL connections, is not accessible online, you prefer to handle the connection yourself or want to connect to Microsoft SQL Server or a database we don't currently support with Databases, you can use one of these alternative methods.

Connecting your database

To make a new connection to an SQL database, follow these steps.

  1. On the Connect to Database panel, choose a Database type.Choose your database type
  2. Type in the Connection name. Give it a memorable name that helps you remember this connection.Enter your connection name
  3. Type in the Host (this could be your Public IP) and Port. By default the port is set to 5432. Enter your database host and port details

    Note

    We cannot connect to a database on localhost (127.0.0.1). The Host needs to be a publicly accessible address.

  4. Type in the Database name.Enter your database name
  5. Type in the database Username and PasswordEnter your database username and pasword
  6. Click Connect. If successful, skip to running a query.

Having trouble connecting to your database?

Please run through the checklist for preparing your database for connecting to Geckoboard.

Troubleshoot common database connection issues

How do I know if my database is accessible online?

To check if your database is accessible online, run the following command on a computer that’s not logged into your VPN or private network. Replace your_db_host and your_db_port with the host and port of your database:

  • Linux or OSX: nc -v your_db_host your_db_port
  • Windows: telnet your_db_host your_db_port

If the connection succeeds, your database is accessible online. If it fails, it likely isn’t. 

Database connection failed. The permission level of the database user is too high

If you see this error, you are likely connecting with a superuser such as "root". Instead, you should connect using a "read only" user.

Database connection failed. We’re having trouble verifying your connection. Please re-check your details.

This is a generic error, but if you have verified that all connection details provided are correct, it is possible that you are trying to connect an unsupported version of the database. For example, trying to connect a MySQL database that runs on version 5.5.

We currently support MySQL versions 5.6, 5.7, and 8.0.13, PostgreSQL versions 11.1, 10.6, 9.6, 9.5, and 9.4 and the latest version of Redshift.

Suggested next step

Learn how to run your SQL query in Databases.

Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

We're ready to help, 24 hours a day, 5 days a week

Get support
  • Fernanda Customer Success Avatar

    Megan

    USA
  • Hariharan Customer Success Avatar

    Hariharan

    India
  • Fernanda Customer Success Avatar

    Yasmin

    Spain
  • Luis Customer Success Avatar

    Luis

    UK
  • Richard Customer Success Avatar

    Richard

    UK
  • Fernanda Customer Success Avatar

    Fernanda

    Brazil
  • Heather Customer Success Avatar

    Heather

    USA