SelfSync

Explore your database with TablePlus

TablePlus is a native database client for macOS and Windows, known for its clean interface. It supports DuckDB since version 6.1: open your database like any other connection, browse tables as spreadsheets and write SQL in a tabbed editor.

Runs on
macOS, Windows
Price
Free trial with limits, paid licence
Website
tableplus.com

Get started

  1. Install TablePlus

    Download it from tableplus.com, or on macOS with brew install --cask tableplus.

  2. Add a DuckDB connection

    Click “Create a new connection…”, choose DuckDB, then select your selfsync-db.duckdb file and click Connect.

  3. Browse the tables

    The left sidebar lists every table. Double-click one to see its rows, and switch to the Structure tab to see its columns and types.

  4. Run a first query

    Open the SQL editor with Cmd + E (Ctrl + E on Windows), paste the query and run it with Cmd + Enter.

    SELECT z_sport AS sport,
       count(*) AS sessions,
       round(sum(z_total_distance) / 1000, 1) AS km
FROM z_fit_session_mesgs
GROUP BY ALL
ORDER BY km DESC;

Good to know

  • TablePlus bundles its own version of DuckDB. If it fails to open your database, update TablePlus to the latest version.
  • Results can be exported to CSV or JSON from the result grid.

Other tools

Wondering what a table or a column holds? Browse the FIT file reference.