OpenWeather Connector

OpenWeather is a service providing weather-related data. It offers detailed weather forecasts, historical weather data, and real-time weather information.

Start for free View documentation

4.8 on G2

Weld · Data Sources

OpenWeatherYour warehouseLive

weather_forecast26 columnsSynced

daily_aggregation19 columnsSynced

Lands in

Agent context over MCP

How it works

Set up in minutes.
No code, no maintenance.

OpenWeather

Data source

Authenticating...

Ready to connect

Overview

OpenWeather in your warehouse.
Ready for your agents.

OpenWeather is a service providing weather-related data. It offers detailed weather forecasts, historical weather data, and real-time weather information. Weld's OpenWeather connector is fully managed: it extracts data from OpenWeather, 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

OpenWeather data schema.
The map your agents read.

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

tables: 2
fields: 45

cloud_cover_afternoon

Open the schema explorer Open the full schema explorer

Weld MCP server

Ask your agent.
It already knows OpenWeather.

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

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

Set up the MCP server

Claude CodeOpus 5

ConnectedWeld MCPAgent contextOpenWeathertables2fields45

How many weather_forecast rows do we have in our OpenWeather data?

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

●weld·search_available_references

⎿raw.openweather.weather_forecast

+ 1 more OpenWeather tables

●weld·get_reference_schema

⎿weather_forecast · 26 columns

dt, city

●weld·run_query

⎿select count(*) from {{raw.openweather.weather_forecast}}

submitted

●weld·get_query_status

⎿DONE

●weld·get_query_result

⎿rows returned

✓Answered from OpenWeather data in your warehouse

>Ask about your OpenWeather dataMCP

Destinations

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

Resources

Everything you need.
To get started.

Documentation

OpenWeather setup guide

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

MCP server

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.

FAQ

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 OpenWeather 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 OpenWeather ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "openweather",
    "destination_schema_name": "openweather_data",
    "sync_interval": "0 * * * *"
  }'
▌