Skip to main content

Connect your SQL database to Geckoboard using Databases

Connect to your MySQL, MariaDB, PostgreSQL, Redshift, Snowflake, and MSSQL databases in seconds.

Updated over 2 months ago

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.

Geckoboard's Databases data source supports MySQL/MariaDB, PostgreSQL, Amazon Redshift, Snowflake and Microsoft SQL Server databases

Database requirements checklist

Prepare your database for connecting to Geckoboard by running through each step below:

  1. Verify that your database is running correctly and is accessible online. To do so, run the following command on a computer not logged into your VPN or private network. If the connection succeeds, your database will be accessible online. If it fails, it will not be.

    1. Replace your_db_host and your_db_port with the host and port of your database:

      1. Linux or OSX: nc -v your_db_host your_db_port

      2. Windows: telnet your_db_host your_db_port

  2. Ensure your database accepts connections from these Geckoboard IP addresses:

    1. 23.23.205.140

    2. 50.16.244.16

    3. 54.204.39.96

    4. 54.243.225.101

    5. 54.243.235.136

    6. 54.243.235.173

  3. Ensure that TLS encryption is enabled. Connections between Geckoboard and your database will be encrypted, so TLS encryption must be enabled.

    1. 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.

  4. Ensure the user account being connected has read-only permissions. Geckoboard only allows SELECT queries, however, for extra security, we only accept connections from users with read-only access to your database.

If your database doesn't allow TLS connections or is not accessible online, we recommend these alternative methods.

How to connect a database

To create a connection to your 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.

Related Articles
Troubleshoot SQL database connections
MariaDB: 'database connection failed'
More ways to get data from your database
Troubleshoot Snowflake database connections
Geckoboard security
Did this answer your question?