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. To check, run the following command on a computer not logged into your VPN or private network. Replace
your_db_host
andyour_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 will be accessible online. If it fails, it likely isn’t.
Ensure your database accepts 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 with 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.
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.
Type in the Database name.
Type in the database Username and Password.
Click Connect. If you run into any connection issues, see our troubleshooting article.
🚀 Create visualizations from SQL queries: With your database connected, it's time to write (or copy) SQL queries to fetch the metrics in your database you wish to visualize.