1bench, modern TimescaleDB GUI client

TimescaleDBTimescaleDB GUI client

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

Apple Silicon. Also available for 7-day free trial · No credit card required

Your data stays yours

1bench runs entirely on your machine. Nothing is ever sent to us.

100% Local

Credentials and data never leave your machine.

Zero Telemetry

No usage tracking, no query logging, no analytics.

Direct Connection

Straight to your database, nothing in between.

Built for TimescaleDB

1

Server Overview

Instant on-connect snapshot: PostgreSQL version, TimescaleDB version, installed extensions, per-database sizes, chunk counts. All in one view.

2

Hypertables & Continuous Aggregates

Browse regular tables, hypertables, and continuous aggregates side by side. Hypertable metadata (partitioning, chunks, compression) surfaced inline.

3

Row-Level Editing

Browse time-series data as a paginated grid or as row-detail cards. Cells edit inline, changes stage before commit, even on hypertables.

4

Time-Series Query Editor

SQL editor with autocomplete for time_bucket(), first(), last(), continuous aggregate views, and all TimescaleDB functions inline.

10x your TimescaleDB productivity

Stop switching between CLI and code. Manage everything visually.

SQL Query Execution

Write time-series queries with syntax highlighting. Use time_bucket, first, last, and CAgg functions.

Table Browser

Browse regular tables and hypertables side by side. Row counts, chunks, and compression status inline.

Data Viewer with Pagination

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

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. Respects defaults, FKs, and constraints.

Table Operations

Truncate or drop tables with confirmation dialogs and dependency warnings to prevent accidental data loss.

Export to SQL, CSV & JSON

Export time-series query results or table data to SQL, CSV, or JSON. Filter and project from the dialog.

Data Import

Import data into TimescaleDB tables from CSV, JSON, or SQL files with field mapping and preview.

Cloud Support

Connect to Timescale Cloud, self-hosted TimescaleDB, or via SSH tunnels with TLS enabled by default.

Query History

Every query you run is saved per connection. Search, filter, and re-run previous queries instantly.

Autocomplete

Smart suggestions for tables, columns, TimescaleDB functions, and SQL keywords as you type.

Production Safe

Read-only mode, destructive-action confirmations, and per-connection ACL checks keep production safe.

Multiple Tabs

Work across TimescaleDB databases and connections in parallel. Each tab keeps its own browsing state.

Keyboard Shortcuts

Navigate tables, run queries, switch tabs, and manage connections without ever reaching for the mouse.

Not just TimescaleDB

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

PostgreSQLPostgreSQLRedisRedisElasticsearchElasticsearchClickHouseClickHouseSQLiteSQLiteCockroachDBCockroachDBSupabaseSupabaseQdrantQdrantTypesenseTypesenseMongoDBMongoDBMySQLMySQLMariaDBMariaDBDuckDBDuckDBMilvusMilvusYugabyteDBYugabyteDBNeonNeonValkeyValkeyDragonflyDragonflyOpenSearchOpenSearchMeilisearchMeilisearchWeaviateWeaviateChromaChromaTursoTursoEloqKVEloqKVTiDBTiDB

Don't see yours? Request it →

Frequently asked questions

What is a TimescaleDB GUI?
A TimescaleDB GUI is a visual desktop client that lets you browse hypertables, run time-series queries, and manage continuous aggregates without using psql. 1bench is a modern TimescaleDB GUI for Mac, Windows, and Linux.
Does TimescaleDB have a GUI?
TimescaleDB is a PostgreSQL extension. It inherits the psql command line but ships no built-in graphical interface. For a visual experience, you install a third-party TimescaleDB GUI like 1bench, a desktop app that surfaces hypertables, chunks, and continuous aggregates alongside regular tables.
What is the best TimescaleDB GUI for Mac, Windows, or Linux?
A good TimescaleDB GUI should run natively on your OS, speak the PostgreSQL wire protocol, and surface hypertables, chunks, and time-series functions like time_bucket() in the editor. 1bench delivers all of this with a single download for Mac, Windows, and Linux.
Can a TimescaleDB GUI connect to Timescale Cloud and self-hosted instances?
Yes. Any TimescaleDB GUI that speaks the PostgreSQL wire protocol works with Timescale Cloud and self-hosted TimescaleDB. 1bench connects using your host, port, and credentials, with TLS enabled by default for Cloud and SSH tunnel support for databases inside private networks.
Can a TimescaleDB GUI browse hypertables and run time-series queries?
Yes. A full-featured TimescaleDB GUI surfaces hypertables alongside regular tables, lets you sort by time columns, inspect chunks, and run queries using time_bucket(), first(), last(), and continuous aggregate views. 1bench includes all of this in the SQL editor and table browser.

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..