Auto Tracker Data

Feedback
12

For anyone following this, the clockify team has made this possible, now. The auto tracker entries are available in an SQLite database file.

C:\\Users\\<your username>\\AppData\\Local\\Clockify\\ClockifyDB_v2.db is the correct location under windows, or short: %LocalAppData%\\Clockify\\ClockifyDB_v2.db in the table AutoTrackerItems.

Here’s an R script I had a good fellow of mine “generate” to get started

library(DBI)
library(RSQLite)
library(tidyverse)

# Build path dynamically for any Windows user
db_path <- file.path(Sys.getenv("LOCALAPPDATA"), "Clockify", "ClockifyDB_v2.db")

if (!file.exists(db_path)) {
  stop("Clockify database not found at: ", db_path)
}

con <- dbConnect(SQLite(), dbname = db_path)

# Fetch tables
auto_tracker_items <- dbReadTable(con, "AutoTrackerItems") |> as_tibble()
time_entries       <- dbReadTable(con, "TimeEntries")      |> as_tibble()

dbDisconnect(con)

# Preview
glimpse(auto_tracker_items)
glimpse(time_entries)

and then do with that chaos whatever you will.

I am also posting this answer to How can I export data from auto-tracker?