OpenWeather Connector
OpenWeather is a service providing weather-related data. It offers detailed weather forecasts, historical weather data, and real-time weather information.
OpenWeatherYour warehouseLive
Agent context over MCPSet up in minutes.
No code, no maintenance.
OpenWeather
Data source
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.
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
OpenWeather models.
What the numbers mean.
Open-source SQL that turns the raw OpenWeather tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Daily forecastThe 3-hourly forecast rolled up to local days per location: the next five days of weather in the same shape as core.openweather.daily_weather, for staffing and ordering decisions.grain: local date x location (city, country)
- Daily weatherDaily weather per location, shaped for joining to sales, covers or footfall on date: temperatures, rain, wind, and a few plain-language flags.grain: date x location (city, country)
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
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.
Load OpenWeather into any warehouse.
Set up in minutes, no code.
Everything you need.
To get started.
OpenWeather 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 OpenWeather connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your OpenWeather data to work.
Connect OpenWeather, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
