Harvest Connector

Intuitive time tracking software for teams. Harvest makes it easy to track time to help manage both your projects and workload.

Start for free View documentation

4.8 on G2

Weld · Data Sources

Harvest

HarvestYour warehouseLive

project27 columnsSynced

client9 columnsSynced

user22 columnsSynced

time_entry48 columnsSyncing

expense35 columnsQueued

Lands in

snowflake

bigquery

databricks

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

Harvest

Harvest

Data source

Authenticating...

Ready to connect

Overview

Harvest in your warehouse.
Ready for your agents.

Intuitive time tracking software for teams. Harvest makes it easy to track time to help manage both your projects and workload. Weld's Harvest connector is fully managed: it extracts data from Harvest, 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.

Agent context

Harvest data schema.
The map your agents read.

Every table, field and relationship Weld syncs from Harvest is served to agents as context over MCP, so they pick the right tables and join on the right keys.

tables: 35
fields: 520
relationships: 36

Loading diagram…

user_project_assignment

wants_timestamp_timers

estimate_item_category

estimate_message

parent_estimate_id

sent_from_email

estimate_line_items

expense_category

expense_categories_report

expense_category_id

expense_category_name

billable_amount

expense_clients_report

billable_amount

expense_projects_report

billable_amount

expense_team_report

billable_amount

expense_category_id

invoice_item_category

invoice_message

send_reminder_on

invoice_payment

recorded_by_email

payment_gateway_id

payment_gateway_name

invoice_line_items

project_budget_report

budget_is_monthly

budget_remaining

project_task_assignment

project_user_assignment

is_project_manager

use_default_rates

billable_by_default

default_hourly_rate

time_clients_report

billable_amount

hours_without_timer

time_projects_report

billable_amount

time_tasks_report

billable_amount

time_team_report

weekly_capacity

billable_amount

uninvoiced_report

uninvoiced_hours

uninvoiced_expenses

uninvoiced_amount

user_billable_rate

user_project_assignment

is_project_manager

use_default_rates

user_project_assignment_task_assignments

user_project_assignment_id

weekly_capacity

has_access_to_all_future_projects

Open the schema explorer Open the full schema explorer

Models

Harvest models.
What the numbers mean.

Open-source SQL that turns the raw Harvest tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.

Open the models

Weld MCP server

Ask your agent.
It already knows Harvest.

Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It reads the Harvest context, finds the tables it needs and queries your warehouse.

Agent contextHarvest tables, fields and joins
QuerySQL against your warehouse
OperateCheck, rerun and refresh syncs

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextHarvesttables35fields520joins36

>

How many project rows do we have per client? Use our Harvest data.

Reading the Harvest context first, so the query uses the right tables and keys.

●weld·search_available_references

⎿raw.harvest.project

raw.harvest.client

+ 33 more Harvest tables

●weld·get_reference_schema

⎿project · 27 columns

joins client on client_id

●weld·run_query

⎿select c.id, count(*) from {{raw.harvest.project}} p

join {{raw.harvest.client}} c on p.client_id = c.id

group by 1

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from Harvest data in your warehouse

>Ask about your Harvest dataMCP

Destinations

Load Harvest into any warehouse.
Set up in minutes, no code.

Resources

Everything you need.
To get started.

Harvest setup guide

Step-by-step instructions to configure and start syncing.

Connect your agents

Set up Claude, Cursor, ChatGPT or Codex against your Weld workspace.

Weld Connect API

Build custom connectors

Use the Weld Connect API to build and publish your own connector.

Common questions

Answers to frequently asked questions about Weld connectors.

Weld Connect API

Set it up in code.
One REST API.

Use the Weld Connect REST API to create Harvest connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Harvest ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "harvest",
    "destination_schema_name": "harvest_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQ

Common questions.
About connectors.

Something not covered here? A data engineer can walk through your setup with you.

Put your Harvest data to work.

Connect Harvest, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.

Harvest

Source

Weld

MCPAgents

Start for free Talk to us

Connectors

Explore more connectors.
300+ and counting.

View all connectors