---
title: Integrate Mode Analytics with Tiger Data | Tiger Data Docs
description: Connect Mode Analytics to Tiger Cloud or self-hosted TimescaleDB to explore, query, and visualize your data.
---

[Mode Analytics](https://mode.com/) is a collaborative analytics platform that lets you query, visualize, and share data through SQL, notebooks, and dashboards.

This page shows you how to connect Mode to Tiger Data as a data connection, so that you can explore and visualize the data in your service or database.

In this integration guide, you:

- Add your service or database to Mode as a data connection.
- Verify that Mode can query your data.

## Prerequisites for this integration guide

To follow these steps, you'll need:

- A [Tiger Cloud service](/get-started/quickstart/create-service/index.md), or a running instance of [self-hosted TimescaleDB](/get-started/choose-your-path/install-timescaledb/index.md).

* Your [connection details](/integrate/find-connection-details/index.md).

- A [Mode](https://mode.com/) workspace, with permissions to add a database connection.

## Add your service or database to Mode

Mode's `Direct Connect` option connects to publicly accessible databases over an encrypted connection. Tiger Cloud services are publicly accessible by default. For self-hosted TimescaleDB, make sure your instance accepts connections from the public internet, or use Mode's Bridge agent instead if it's only reachable over a private network or virtual private network (VPN).

1. **Open the database connection settings in Mode**

   In Mode, click your name in the top-left corner, then select `Connect a Database`.

2. **Choose Direct Connect**

   Select `Direct Connect`, the option for databases reachable over the public internet. If your database isn't publicly reachable, for example a self-hosted instance behind a firewall or VPN, use Mode's Bridge agent instead.

3. **Enter your connection details**

   Select `PostgreSQL` as the database type, then enter your [connection details](/integrate/find-connection-details/index.md):

   - **Host** and **Port**: your `host` and `port`.
   - **Database name**: your `dbname`.
   - **Username** and **Password**: your `user` and `password`.

   Turn on SSL. Tiger Cloud rejects unencrypted connections; for self-hosted TimescaleDB, turn it on if your instance is configured to require SSL.

4. **Allowlist Mode's IP addresses**

   Direct Connect reaches your database from a fixed set of Mode IP addresses. Add the current list from [Mode's connection documentation](https://mode.com/help/articles/connecting-mode-to-your-database) to your database's network or firewall allow list. In Tiger Cloud, add them to your service's IP allow list under `Security` in the console.

5. **Test and save the connection**

   Click `Connect`. Mode tests the connection and reports whether it succeeded; if it fails, Mode shows whether the problem is SSL, network access, or credentials.

## Verify the integration

To confirm Mode is working with your service or database:

1. **Open a new query**

   In Mode, click `+ New` > `Query`, then select your connection from the data source list.

2. **Run a query**

   Run a simple query against one of your tables:

   ```
   SELECT * FROM <table_name> LIMIT 10;
   ```

   You see rows from your service or database in the results pane, confirming that Mode can read your data.

You have successfully integrated Mode Analytics with Tiger Data.

## Troubleshooting

- **Connection fails with an SSL error:** confirm SSL is turned on in the connection settings. Tiger Cloud requires encrypted connections; for self-hosted TimescaleDB, confirm your instance is configured for SSL if you enabled it.
- **Connection times out:** confirm Mode's IP addresses are added to your database's allow list, and that the host and port are correct. If your database isn't publicly reachable, use Mode's Bridge agent instead of Direct Connect.
- **Authentication failed:** confirm the username and password match your [connection details](/integrate/find-connection-details/index.md) exactly.

For other connectivity and authentication issues, see [Troubleshoot Tiger Cloud integrations](/integrate/troubleshooting/index.md).

## Next steps

[Find your connection details](/integrate/find-connection-details/index.md)

[Locate the host, port, database, user, and password for your service.](/integrate/find-connection-details/index.md)

[Integrate Tableau with Tiger Data](/integrate/bi-vizualization/tableau/index.md)

[Connect Tableau to your service or database to build dashboards.](/integrate/bi-vizualization/tableau/index.md)