activitywatch_run_query

Execute queries on ActivityWatch time tracking data to analyze application usage, browsing history, and productivity patterns using a structured query language.

Instructions

Run a query in ActivityWatch's query language

Input Schema

Name	Required	Description
`name`	No	Optional name for the query (used for caching)
`query`	Yes	MUST BE A SINGLE STRING containing all query statements separated by semicolons. DO NOT split into multiple strings.
`timeperiods`	Yes	Time periods to query. Format: ['2024-10-28/2024-10-29'] where dates are in ISO format and joined with a slash

Input Schema (JSON Schema)

{
  "properties": {
    "name": {
      "description": "Optional name for the query (used for caching)",
      "type": "string"
    },
    "query": {
      "description": "MUST BE A SINGLE STRING containing all query statements separated by semicolons. DO NOT split into multiple strings.",
      "examples": [
        "events = query_bucket('aw-watcher-window_UNI-qUxy6XHnLkk'); RETURN = events;"
      ],
      "items": {
        "description": "Complete query with all statements in one string separated by semicolons",
        "type": "string"
      },
      "maxItems": 1,
      "minItems": 1,
      "type": "array"
    },
    "timeperiods": {
      "description": "Time periods to query. Format: ['2024-10-28/2024-10-29'] where dates are in ISO format and joined with a slash",
      "examples": [
        "2024-10-28/2024-10-29"
      ],
      "items": {
        "description": "Time period in format 'start-date/end-date'",
        "pattern": "^[0-9]{4}-[0-9]{2}-[0-9]{2}/[0-9]{4}-[0-9]{2}-[0-9]{2}$",
        "type": "string"
      },
      "maxItems": 10,
      "minItems": 1,
      "type": "array"
    }
  },
  "required": [
    "timeperiods",
    "query"
  ],
  "type": "object"
}

ActivityWatch MCP Server

activitywatch_run_query

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from ActivityWatch MCP Server

Related Tools