This is a Pro data source. If not available on your plan please upgrade or contact our support team.

Our Databases data source currently supports MySQL/MariaDB, PostgreSQL, Amazon Redshift, Snowflake and Microsoft SQL Server databases. If you're looking for another type of database, request support for it.

Database requirements

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

  • Connections between Geckoboard and your database will be encrypted so your database must have TLS encryption enabled. For MariaDB TLS is disabled by default. Check if it's enabled by running the command SHOW VARIABLES LIKE '%ssl%';. Learn more about how to enable TLS for MariaDB.

  • Geckoboard only allows SELECT queries, but for extra security, we only accept connections from users that have read-only access to the DB.

If your database doesn't allow SSL connections or is not accessible online, you can 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.

  2. Type in the Connection name. Give it a memorable name that helps you remember this connection.

  3. Type in the Host (this could be your Public IP) and Port. By default the port is set to 5432.

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

    For Snowflake databases, enter your Account and Warehouse.

  4. Type in the Database name.

  5. Type in the database Username and Password.

  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

Did this answer your question?