@pipeworx/jodi

Connect: https://gateway.pipeworx.io/jodi/mcp · Install: one-click buttons

Tools: 5

Monthly oil and natural gas production, consumption, imports, exports and closing stocks by country — the JODI-Oil and JODI-Gas World Databases, self-reported to the Joint Organisations Data Initiative (APEC/Eurostat/GECF/IEA/IEF/OLADE/OPEC/UNSD). Global coverage (~100+ countries), including every Gulf producer (Saudi Arabia, UAE, Kuwait, Qatar, Oman, Bahrain, Iraq, Iran).

Tools

• jodi_oil_series(country, product?, flow?, months?, end_month?) — one country’s monthly oil series (crude/NGL/other/total-crude, or a refined product), with reporting gaps marked explicitly.
• jodi_gas_series(country, flow?, months?, end_month?) — same for natural gas (production, imports/exports split LNG vs pipeline, demand, stocks).
• jodi_oil_compare(countries?, product?, flow?, months_back?, end_month?) — rank countries by change in a series between the latest reported month and N months earlier. Defaults to the Gulf producer set. Answers both “which Gulf producers raised output most this quarter” (months_back: 3) and “Saudi exports vs a year ago” (countries: ["Saudi Arabia"], months_back: 12) — the same comparison with a different country list.
• jodi_gas_compare(countries?, flow?, months_back?, end_month?) — same for gas.
• jodi_countries(commodity?) — which countries JODI-Oil/Gas cover, and each one’s earliest/latest reported month.

Auth

Keyless. There is no upstream key to bring.

Data sources

• https://www.jodidata.org/oil/database/data-downloads.aspx — JODI-Oil annual CSVs (primary: crude/NGL/other/total-crude; secondary: refined products), one file per year, 2002-present.
• https://www.jodidata.org/gas/database/data-downloads.aspx — JODI-Gas, one CSV covering its whole 2009-present history, resolved through JODI’s own https://api.publisher.jodidata.org/web/files/gas JSON API rather than a hardcoded filename (the file has already been renamed once).

Ingested monthly by workers/data-pipeline/src/datasets/jodi.ts into jodi_oil_observations / jodi_gas_observations (migration 161). Full design notes — why a non-report is a missing ROW rather than a stored null, and why only one of JODI’s five published units survives ingest per flow — live in the migration file and the dataset config; the short version:

• A missing month is never a zero. JODI is self-reported and coverage is uneven — some countries report late, some skip months, some never report a given series. Every tool here builds the full expected month range and marks gaps {reported: false, value: null} rather than only returning the rows that exist and letting the gap read as silence.
• Units are pre-selected, not user-choosable. JODI publishes every value in 5 units; this pack keeps KBD (thousand barrels/day) for oil rate flows, KBBL (thousand barrels) for the two level flows (closing stocks, stock change — JODI itself marks KBD “not applicable” for both), and M3 (million cubic metres) for everything in gas.
• Country names are ISO 3166-1 alpha-2 codes; JODI’s raw files carry the code only, so this pack keeps its own code→name table (COUNTRY_NAMES in src/index.ts) covering every code seen in either database.

Tools

• jodi_oil_series — Monthly JODI-Oil series for one country — production, imports, exports, direct use, refinery intake, stock change or closing stocks, for crude oil/NGL/other/total-crude or a refined product (LPG, gaso
• jodi_gas_series — Monthly JODI-Gas series for one country — production, imports/exports (total, or LNG vs pipeline split out), demand, stock change or closing stocks, natural gas only. Answers “Qatar LNG exports over t
• jodi_oil_compare — Compare JODI-Oil countries on one series, at the latest reported month AND against N months earlier — ranked by change. This is the tool for “which Gulf producers raised crude output most this quarter
• jodi_gas_compare — Compare JODI-Gas countries on one series, at the latest reported month AND against N months earlier — ranked by change. Answers “which Gulf gas producers grew LNG exports most this year”, “Qatar gas p
• jodi_countries — List the countries JODI-Oil and/or JODI-Gas cover, with each one’s earliest and latest reported month. Use this before jodi_oil_series/jodi_gas_series to confirm a country actually reports the commodi