Geckoboard

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, <a href="https://www.geckoboard.com/about/contact/" rel="nofollow noopener noreferrer" target="_blank">request support for it</a>.

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

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

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 <code>your_db_host</code> and <code>your_db_port</code> with the host and port of your database: 
 1. Linux or OSX: <code>nc -v your_db_host your_db_port</code> 
 2. Windows: <code>telnet your_db_host your_db_port</code>

Ensure your database accepts connections from these Geckoboard IP addresses:

1. <code>23.23.205.140</code>
2. <code>50.16.244.16</code>
3. <code>54.204.39.96</code>
4. <code>54.243.225.101</code>
5. <code>54.243.235.136</code>
6. <code>54.243.235.173</code>

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 <code>SHOW VARIABLES LIKE '%ssl%';</code>. <a href="https://www.osradar.com/configure-mariadb-with-ssl-to-secure-connections/" rel="nofollow noopener noreferrer" target="_blank">Learn more about how to enable TLS for MariaDB</a>.

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

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 <code>your_db_host</code> and <code>your_db_port</code> with the host and port of your database: 
 1. Linux or OSX: <code>nc -v your_db_host your_db_port</code> 
 2. Windows: <code>telnet your_db_host your_db_port</code>
2. Ensure your database accepts connections from these Geckoboard IP addresses:
 1. <code>23.23.205.140</code>
 2. <code>50.16.244.16</code>
 3. <code>54.204.39.96</code>
 4. <code>54.243.225.101</code>
 5. <code>54.243.235.136</code>
 6. <code>54.243.235.173</code>
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 <code>SHOW VARIABLES LIKE '%ssl%';</code>. <a href="https://www.osradar.com/configure-mariadb-with-ssl-to-secure-connections/" rel="nofollow noopener noreferrer" target="_blank">Learn more about how to enable TLS for MariaDB</a>.
4. Ensure the user account being connected has read-only permissions. Geckoboard only allows <code>SELECT</code> 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 <a href="https://support.geckoboard.com/en/articles/6055592-more-ways-to-get-data-from-your-database">these alternative methods</a>.

To create a connection to your database, follow these steps:

On the Connect to Database panel, choose a Database type.

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

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 (<code>127.0.0.1</code>).

For Snowflake databases, enter your Account and Warehouse.

Type in the database Username and Password.

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 (<code>127.0.0.1</code>). 
 
 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.

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

Database requirements checklist

How to connect a database