Desktop app for Mac, Windows & Linux

TimescaleDBTimescaleDB GUI Client

Browse hypertables, run time-series queries, edit data inline, and manage your TimescaleDB database visually. Connect to TimescaleDB on localhost, self-hosted, or cloud (Timescale Cloud).

7-day free trial · No sign-up required

10x Your TimescaleDB Productivity

Stop switching between CLI and code. Manage everything visually.

SQL Query Execution

Write and run time-series queries with syntax highlighting. Use TimescaleDB functions like time_bucket() and view results instantly.

Schema Discovery

Automatically discover and browse all schemas in your TimescaleDB database. Switch between them with a click.

Table & Hypertable Discovery

Browse regular tables and hypertables side by side. View column details, row counts, and table statistics at a glance.

Column Information

Inspect column names, data types, and constraints for any table or hypertable in your TimescaleDB database.

Data Viewer with Pagination

Browse time-series data with built-in pagination and sorting. Handle large hypertables without loading everything at once.

Column Sorting

Sort query results and table data by any column — including time columns — to quickly find the rows you need.

Inline Data Editing

Edit cell values directly in the table view and save changes back to TimescaleDB with a single action.

Row Insertion

Insert new rows into tables and hypertables through a visual form. No need to write INSERT statements manually.

Table Operations

Truncate or drop tables with confirmation dialogs to prevent accidental data loss in production.

Export to SQL, CSV & JSON

Export time-series query results and table data to SQL, CSV, or JSON for analysis, reporting, or sharing.

Data Import

Import data into TimescaleDB tables from external files without writing COPY commands manually.

SSH Tunnel Support

Connect securely to remote TimescaleDB instances through SSH tunnels. Ideal for private or firewalled deployments.

Multiple Tabs

Work across databases and connections in parallel with a tabbed interface.

Keyboard Shortcuts

Navigate and execute queries without reaching for the mouse.

Dark & Light Mode

Switch between dark and light themes to match your preference and reduce eye strain.

Frequently Asked Questions

What is TimescaleDB and why would I use it?
TimescaleDB is a PostgreSQL extension optimized for time-series data. It introduces hypertables that automatically partition data by time, making inserts and time-range queries significantly faster than plain PostgreSQL for time-series workloads. It's used for IoT data, metrics, financial data, and event logging.
What is the best TimescaleDB GUI client?
1bench provides a native TimescaleDB GUI for Mac (Apple Silicon and Intel), Windows, and Linux. Since TimescaleDB is a PostgreSQL extension, 1bench connects via the PostgreSQL wire protocol and supports browsing hypertables, running time-series queries, editing data inline, and exporting results. Other options include DBeaver and pgAdmin.
Can I use regular PostgreSQL tools with TimescaleDB?
Yes. TimescaleDB is a PostgreSQL extension, so any PostgreSQL-compatible GUI client works with it. 1bench uses its PostgreSQL adapter to connect, giving you full access to both standard PostgreSQL tables and TimescaleDB hypertables. Time-series functions like time_bucket() work in the query editor.
How do I connect a GUI client to Timescale Cloud?
In the Timescale Cloud console, find your service's connection details — host, port (default 5432), database name, and credentials. Enter these in 1bench to connect. Timescale Cloud uses TLS by default. For services in a VPC, you can use 1bench's SSH tunnel support to connect securely.
Can I browse hypertables and run time-series queries in a GUI?
Yes. In 1bench, hypertables appear alongside regular tables in the table browser. You can view their data with pagination, sort by time columns, edit rows inline, and run time-series queries using TimescaleDB functions like time_bucket(), first(), and last() in the SQL editor.

Not Just TimescaleDB

One tool for all your databases. No more juggling apps.

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDB
YugabyteDBYugabyteDB
NeonNeon
SupabaseSupabaseAmazon RedshiftAmazon Redshift
GreenplumGreenplum
ValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBSQL ServerSQL ServerCassandraCassandraNeo4jNeo4jQdrantQdrantTypesenseTypesenseMilvusMilvus

Ready to manage TimescaleDB visually?

1bench connects to TimescaleDB Cloud and self-hosted instances. Start your 7-day free trial today.

View Pricing

1bench is not affiliated with or endorsed by Timescale, Inc.. TimescaleDB is a trademark of Timescale, Inc..