Agent context
ClickUp models
5 SQL models that turn the raw ClickUp tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions behind every number.
How the set is built
- 7Raw tables
- 5Core
- 5Analytics
Staging cleans each raw table once, core holds the logic, and analytics is the table dashboards and agents read.
- Team Overview ReportGenerates a team overview report by retrieving data from the ClickUp integration. It calculates the total number of tasks, total time spent, task status, and task count for each team. The report includes team ID, name, color, total tasks, total time spent, task status, and tasks in each status. The results are ordered by team ID.3 raw tables
- Task Dependency AnalysisPerforms a task dependency analysis in ClickUp. It retrieves information about task dependencies, including task names, statuses, and dependent task details. It also calculates the total number of dependencies for each task and determines if a task is a potential blocker based on its status and the status of its dependent tasks. The results are sorted by task ID and dependent task ID.grain: task x task it depends on · 2 raw tables
- User Activity and Performance ReportGenerates a user activity and performance report by integrating with ClickUp. It retrieves information such as the total number of tasks, tasks completed, tasks overdue, total time spent, task priority, task status, and task count by priority and status for each user. The results are ordered by user ID.4 raw tables
- Monthly Time Tracking and Billing ReportGenerates a monthly time tracking and billing report using data from ClickUp. It calculates the billable and non-billable time for each user, as well as the total time spent. The report also includes the billable amount, calculated based on a hypothetical rate of $50 per hour.grain: month x user, by the time entry's start (UTC) · 1 raw table
- Task Checklist ProgressGenerates a report on the progress of task checklists in ClickUp. It retrieves the total number of checklist items, resolved items, and unresolved items for each task. It calculates the completion percentage based on the resolved items and total checklist items. The results are sorted by completion percentage and task ID.2 raw tables
- Weld or dbt
- The same SQL in both dialects. Sync the folder with GitHub Sync, or copy the dbt models into your project.
- Check before you rely on it
- Reconcile a month against ClickUp's own reports first. Each model's notes say what the synced data can and can't support.
Connect ClickUp.
Your agents start with context.
Sync ClickUp to your warehouse, deploy these models, and query them from Claude, Cursor or ChatGPT over MCP. Free for 14 days, no credit card.