Skip to content

Integrate DBine with Tiger Cloud

Vendor-provided

Query, browse, and administer your database from a free, open-source desktop database manager

DBine is a free, open-source (Apache 2.0) desktop database manager for Windows, macOS, and Linux. It has a SQL editor, an object explorer, query plans, schema compare, and a server monitor, and it works with 130+ databases and cloud services in the same window.

This page explains how to integrate DBine with your Tiger Cloud service.

In this integration guide, you:

  • Connect DBine to your service with its TimescaleDB connection type.
  • Browse your schema and run queries from the DBine editor.
  • See your hypertables and background jobs in the DBine server monitor.

Prerequisites for this integration guide

To follow these steps, you'll need:

To connect to Tiger Cloud:

  1. Open the connection form

    In DBine, click New connection in the Explorer, then select TimescaleDB from the list of engines.

  2. Configure the connection

    Fill in the connection name and use your connection details for the server, port, database, user, and password. New connections verify the server's certificate by default: the SSL/TLS tab sets sslmode to verify-full, which works with Tiger Cloud as is.

  3. Click Test connection, then Save and connect

    A successful test shows Connection successful and the server version. Save and connect saves the connection and opens it in the Explorer.

    DBine new connection form for TimescaleDB with the server, port, database, user, and password filled in, and Connection successful shown next to the Test connection button

You have successfully integrated DBine with Tiger Cloud.

  1. Browse the schema

    In the Explorer, expand the connection and the database, and then the public schema if your database has more than one. Your hypertables are listed under Tables like regular tables, and continuous aggregates are listed under Views. The internal _timescaledb_* schemas are not shown. Expand a table to see its columns and their types, and its indexes.

  2. Run a query against a hypertable

    Right-click the database and choose New query. Write a SELECT against one of your hypertables, for example:

    SELECT time_bucket('1 day', c.time) AS day,
    d.site,
    round(avg(c.temperature)::numeric, 2) AS avg_temp,
    round(max(c.temperature)::numeric, 2) AS max_temp,
    round(avg(c.humidity)::numeric, 1) AS avg_humidity
    FROM conditions c
    JOIN devices d USING (device_id)
    WHERE c.time >= '2026-10-17'
    GROUP BY day, d.site
    ORDER BY day, d.site;

    Click Run. The results grid shows the rows, and the status bar shows the row count and the execution time.

    DBine with the Explorer showing the conditions hypertable and its columns, and a time_bucket query with its 12-row result grid
  3. Open the server monitor

    Right-click the connection and choose Monitor. Next to the sessions and database sizes, the monitor lists each hypertable with its number of chunks, its compression state, and its estimated size, and the background jobs with their schedule and last run.