@pipeworx/fuel-prices

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

Tools: 4

What petrol, diesel and LPG cost across Europe — 28 countries, weekly, back to 2005.

Tools

Auth

None. No key, no account.

Data sources

The European Commission’s Weekly Oil Bulletin:

• Landing page: https://energy.ec.europa.eu/data-and-analysis/weekly-oil-bulletin_en
• Series: Weekly_Oil_Bulletin_Prices_History_maticni_4web.xlsx

EU Member States report retail prices into it every week under Council Decision 1999/280/EC, and the Commission publishes the consolidated series. Coverage is the 27 EU states plus the United Kingdom, plus an EU-wide aggregate under the code EU.

Reading the numbers

• Prices are per 1000 litres in the source. Petrol, diesel, heating oil and LPG are quoted that way; a raw 2143 is €2.143 per litre. Every response carries price_per_litre_eur already converted, and the raw figure alongside it with its unit.
• The two heavy fuel oils are quoted per tonne, so they have no per-litre price at all. price_per_litre_eur is null for those rather than a fabricated conversion.
• It is a national average for a week, not a live station price. The newest week is a few days behind and any individual filling station will differ. Every response states its week_ending so a figure cannot be quoted as “today” by accident.
• EU is an aggregate, not a country. It is available to ask for directly but is excluded from compare_fuel_prices rankings.
• Comparisons are pinned to one week. A country that reports late would otherwise win a “cheapest” ranking on an older, lower figure.
• Not covered: the United States, Switzerland, Norway, Turkey, and everywhere else outside the EU and the UK. Asking for one returns an explicit country_not_covered refusal naming the reason rather than an empty result.

Refreshing

Weekly, when the Commission republishes the bulletin:

node scripts/ingest-eu-oil-bulletin.mjs              # full history
node scripts/ingest-eu-oil-bulletin.mjs --weeks 8    # just the recent tail

The script parses the workbook with no dependencies — xlsx is a zip of XML, and node ships zlib — and upserts by (country_code, week_ending, fuel), so a week that stops being republished keeps its last known value.

It refuses to load rather than warn in two cases, because both would otherwise produce a plausible series that is wrong:

• the newest week it parses is more than 45 days old (the source is newest-first, so a layout change silently yields January 2005);
• any record loses its unit.

Tools

• fuel_price — What does petrol cost in a European country right now — the current pump price per litre for petrol, diesel or LPG in any of 28 countries. Answers “how much is petrol in Portugal”, “what does diesel c
• compare_fuel_prices — Where is fuel cheapest or most expensive in Europe — every country ranked by pump price for one fuel in the same week. Answers “which European country has the cheapest diesel”, “where is petrol most e
• fuel_price_history — How fuel prices have moved in one European country over time — a weekly series of pump prices with the change over the period. Answers “how much has petrol gone up in Germany this year”, “diesel price
• fuel_price_coverage — Which countries and weeks this fuel-price data covers, and how fresh it is: the list of countries, the newest and oldest week available, the total number of weekly observations, and which fuels are ca