Our Databases data source currently supports MySQL, MariaDB, PostgreSQL, Amazon Redshift and Microsoft SQL Server databases.
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.14050.16.244.1654.204.39.9654.243.225.10154.243.235.13654.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
SELECTqueries, 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:
- 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.
We cannot connect to a database on localhost (127.0.0.1). The Host needs to be a publicly accessible address. - Type in the Database name.
- Type in the database Username and Password
- Click .
- 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:
- 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.
- 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.14050.16.244.1654.204.39.9654.243.225.10154.243.235.13654.243.235.173