Connect your SQL database to Geckoboard using Databases

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

Before you begin, run through this checklist to prepare your database for connecting to Geckoboard.

  • Verify that your database is running correctly and is accessible online. You can run a check for this.
  • 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.

If your database doesn't allow SSL connections, is not accessible online, or you want to connect to Microsoft SQL Server or a database we don't currently support, why not try these alternative methods.

Connect your SQL 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 detailsWe 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.
  7. If successful, you can start to create visualizations from your SQL queries. If you run into any issues, see our troubleshooting article.

How can I check 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. 

Can I use SSH tunneling to connect with Databases?

No, Geckoboard doesn't currently support SSH tunneling (also known as post forwarding) for connections to the Database integration. You can either:

  1. Use SQL-Datasets: a command line app that enables you to connect your database data to Geckoboard via our Datasets API. Or check out other ways to get data from your database.
  2. Ensure all incoming connections to your database server are disallowed, with the exception of Geckoboard connections. You can do this by whitelisting the following Geckoboard server 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
Was this article helpful?

Awesome! 👍 Thanks so much for your feedback!

Sorry about that! Start a conversation now.

Ready to create your own dashboard?

Get started for free

Still have questions? Get in touch.