ClickUp Connector
ClickUp is a versatile cloud-based project management and productivity platform, widely used for task tracking, team collaboration, and workflow optim
ClickUpYour warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
ClickUp
Data source
ClickUp in your warehouse.
Ready for your agents.
ClickUp is a versatile cloud-based project management and productivity platform, widely used for task tracking, team collaboration, and workflow optim Weld's ClickUp connector is fully managed: it extracts data from ClickUp, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.
ClickUp data schema.
The map your agents read.
Every table, field and relationship Weld syncs from ClickUp is served to agents as context over MCP, so they pick the right tables and join on the right keys.
- tables
- 14
- fields
- 217
- relationships
- 8
ClickUp models.
What the numbers mean.
Open-source SQL that turns the raw ClickUp tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- 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.
- 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
- 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.
- 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)
- 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.
Ask your agent.
It already knows ClickUp.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the ClickUp context, finds the tables it needs and queries your warehouse.
- Agent contextClickUp tables, fields and joins
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
How many task rows do we have per team? Use our ClickUp data.
Reading the ClickUp context first, so the query uses the right tables and keys.
Load ClickUp into any warehouse.
Set up in minutes, no code.
Everything you need.
To get started.
ClickUp setup guide
Step-by-step instructions to configure and start syncing.
MCP serverConnect your agents
Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.
Weld Connect APIBuild custom connectors
Use the Weld Connect API to build and publish your own connector.
FAQCommon questions
Answers to frequently asked questions about Weld connectors.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create ClickUp connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your ClickUp data to work.
Connect ClickUp, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
