SelfSyncAnalytics tools
Explore your database with the tool you like
Your SelfSync database is a single selfsync-db.duckdb file. Any tool that speaks DuckDB opens it: an AI assistant, a desktop app, your terminal or a few lines of code. Here are 9 of them, with the steps to get started.
One file, no server
DuckDB runs inside the tool that opens it: nothing to install besides the tool itself, nothing to keep running, and your data never leaves your computer.
Not sure where to start? Ask Claude your questions in plain words. Prefer to see your tables? Open them in the DuckDB UI or TablePlus.
- Read-only
- Open the database in read-only mode whenever the tool allows it. The steps below show how.
- One writer at a time
- DuckDB lets a single program open a file in read-write mode. If a tool reports the file is locked, close the other one, or open both in read-only mode.
- Documented columns
- Every column carries a comment, readable with
FROM duckdb_columns(). The FIT file reference explains each of them.
All the tools
AI assistant
- ClaudeRequires a Claude account
Ask questions about your training in plain words, Claude writes and runs the SQL.
Visual apps
- DuckDB UIFree
A notebook in your browser, started with one command, with a catalog of your tables.
- TablePlusFree trial with limits, paid licence
A polished native client to browse your tables like spreadsheets and write SQL.
- DBeaverFree (Community edition)
A free, open-source database IDE with diagrams, exports and charts.
Terminal
- DuckDB CLIFree, open source
The official command-line shell: one binary, nothing to configure.
- HarlequinFree, open source
A full SQL IDE in your terminal: catalog, editor and results grid.
Code
- PythonFree, open source
Query with SQL, get pandas or Polars DataFrames, plot in Jupyter.
- RFree, open source
Standard DBI and dplyr access, ready for ggplot2 and your statistics.
- JavaScriptFree, open source
The official Node.js client, to script analyses or build your own dashboard.