@pipeworx/georgia-energy

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

Tools: 8

Georgia’s (the country’s) national electricity system: live grid telemetry from the transmission system operator, and the regulator’s per-power-station monthly generation and price series.

Tools

  • gse_grid_now(...) — the grid as of the latest published 3-minute slot: hydro / thermal / wind / solar generation, total generation, cross-border flow on the Azerbaijan, Armenia, Russia (with the Salkhino, Java and Nakaduli lines broken out) and Turkey tie lines, and total consumption, in MW.
  • gse_grid_at(...) — the same blocks for one explicit past slot, inside the rolling ~30-day retention window.
  • gse_frequency(...) — system frequency in Hz (nominal 50), 1-minute feed. How far it sits from 50 is a direct read on generation-versus-demand balance.
  • gse_demand_forecast(...) — the day-ahead forecast, hour by hour: consumption, supply, thermal, hydro (regulated and seasonal), wind, import and export.
  • gse_publications(...) — the operator’s reports and notices, including the Generation Adequacy Assessment, annual reports and the SESA.
  • gse_tenders(...) — the operator’s procurement tenders with awarded bidders and bid prices where published.
  • gnerc_station_generation(...) — monthly generation for individual power stations (Enguri, the Vardnili cascade, Khrami 1/2, Zhinvali, Gardabani thermal 1/2, the Kartli wind farm, named solar plants) plus national supply, consumption, import, export and named large direct consumers, 2015-2026.
  • gnerc_prices(...) — monthly balancing-electricity price, guaranteed-capacity fee, and the price ESCO paid deregulated stations, 2015-2026.

Auth

Keyless. No token, no cookie, no registration on either publisher.

Data sources

Things that will otherwise be rediscovered the hard way

GSE filenames are in Tbilisi local time (UTC+4), not UTC, with the minute floored to a multiple of 3, and publication lags. Asking for the current minute returns a 404, not an error — so “now” must mean “the newest slot that exists”, which is why every read walks backwards and proves the slot with file-exists first. The lag is not the ~2 minutes the original sample suggested: the 1-minute frequency feed has been observed 9-10 slots behind. That is why the walk probes in concurrent batches — ten sequential round trips to Tbilisi cost about four seconds, most of it waiting.

Every telemetered value carries a QUALITY attribute and most of them are not measurements. ACT is actual telemetry; SUB was substituted by the operator; NRE was not received. A representative live export had 3 ACT, 7 SUB and 3 NRE — national consumption was NRE and the hydro total SUB. So the flag travels with every row and is summarised at the top of the response. Dropping it would return a fill-in as a measurement, which is worse than returning nothing.

The real-time XML needs its preamble stripped before parsing: it declares ISO-8859-1 (the content is ASCII), ships an <?xml-stylesheet?> PI, and carries a <!DOCTYPE ... SYSTEM 'GSE_V1.DTD'> that a strict parser will try to resolve. BLOCK_AREA/@Name is space-padded to a fixed width, so trim before matching.

The day-ahead forecast really is an Excel 97 file (D0 CF 11 E0 magic), not an HTML table wearing an .xls extension, so it needs the OLE2 compound-file container walked before the BIFF8 record stream can be read. src/xlsx.ts does both that and OOXML .xlsx, dependency-free, on the Workers runtime.

data.gnerc.org sends its leaf certificate with no intermediate. Node’s bundled CA store cannot chain it and fails with UNABLE_TO_VERIFY_LEAF_SIGNATURE, so a local script testing this pack outside a Worker will look like the site is down. Cloudflare’s egress resolves it fine (verified live against our own gateway, 2026-09-10). Do not “fix” this by changing hosts — the alternatives serve the same single-certificate chain, and gnerc.org/excel/ answers 500.

The GNERC balance workbook is ~450 KB, so it is fetched and parsed once per isolate and cached for six hours rather than downloaded per call.

On the balance sheets, columns C..N are Jan..Dec and O is the year total — but empty months are written as self-closing, valueless cells. A worksheet cell regex whose <c ...>...</c> alternative comes before its self-closing one will merge an empty cell with the next populated one and slide values into the wrong column, reporting a December figure as April. It errors nowhere. The ordering in src/xlsx.ts is load-bearing; the note above it says so.

The three price workbooks are laid out the other way round (months down, years across) and do not agree on which row the header sits in, so the header is found by looking for the Georgian word for “month” rather than by position. Some of their cells are text padded with non-breaking spaces.

GNERC row labels are Georgian script only — ენგურჰესი is Enguri HPP. The balance_code column preserves the published hierarchy (1.4.1.1 is one station inside regulated hydro inside hydro inside total generation), so aggregate rows and their component stations are both present and distinguishable. Excel stores some of those codes as floats, so 1.1 arrives as 1.1000000000000001 and is normalised.

Tools

  • gse_grid_now — Georgia’s national electricity grid right now: hydro, thermal, wind and solar generation, total generation, cross-border flow on the Azerbaijan, Armenia, Russia (Salkhino/Java/Nakaduli lines) and Turk
  • gse_grid_at — Georgia’s national grid state at a specific past time — the same generation, tie-line and consumption blocks as gse_grid_now, with the same QUALITY flags, for one 3-minute slot. Sourced from the JSC G
  • gse_frequency — The Georgian power system’s electrical frequency in hertz, from the JSC Georgian State Electrosystem 1-minute real-time export — nominal 50 Hz, and how far it sits from nominal is a direct read on the
  • gse_demand_forecast — Georgia’s day-ahead electricity forecast published by JSC Georgian State Electrosystem: hour-by-hour total consumption, total supply, thermal / hydro (regulated and seasonal) / wind generation, and pl
  • gse_publications — Reports and notices published by JSC Georgian State Electrosystem, Georgia’s transmission system operator — including the Generation Adequacy Assessment (the medium and long-term supply-adequacy outlo
  • gse_tenders — Procurement tenders run by JSC Georgian State Electrosystem, the Georgian electricity transmission system operator — substation and transmission-line construction, primary equipment supply, consultanc
  • gnerc_station_generation — Monthly electricity generation for individual Georgian power stations — Enguri HPP, the Vardnili cascade, Khrami 1 and 2, Zhinvali, Gardabani thermal 1 and 2, the Kartli wind farm, named solar plants
  • gnerc_prices — Monthly Georgian electricity prices set or recorded by the Georgian National Energy and Water Supply Regulatory Commission (GNERC), 2015 to 2026, in tetri per kWh: the average balancing-electricity sa

Tools

  • gnerc_prices — Monthly Georgian electricity prices set or recorded by the Georgian National Energy and Water Supply Regulatory Commission (GNERC), 2015 to 2026, in tetri per kWh: the average balancing-electricity sa
  • gnerc_station_generation — Monthly electricity generation for individual Georgian power stations — Enguri HPP, the Vardnili cascade, Khrami 1 and 2, Zhinvali, Gardabani thermal 1 and 2, the Kartli wind farm, named solar plants
  • gse_demand_forecast — Georgia's day-ahead electricity forecast published by JSC Georgian State Electrosystem: hour-by-hour total consumption, total supply, thermal / hydro (regulated and seasonal) / wind generation, and pl
  • gse_frequency — The Georgian power system's electrical frequency in hertz, from the JSC Georgian State Electrosystem 1-minute real-time export — nominal 50 Hz, and how far it sits from nominal is a direct read on the
  • gse_grid_at — Georgia's national grid state at a specific past time — the same generation, tie-line and consumption blocks as gse_grid_now, with the same QUALITY flags, for one 3-minute slot. Sourced from the JSC G
  • gse_grid_now — Georgia's national electricity grid right now: hydro, thermal, wind and solar generation, total generation, cross-border flow on the Azerbaijan, Armenia, Russia (Salkhino/Java/Nakaduli lines) and Turk
  • gse_publications — Reports and notices published by JSC Georgian State Electrosystem, Georgia's transmission system operator — including the Generation Adequacy Assessment (the medium and long-term supply-adequacy outlo
  • gse_tenders — Procurement tenders run by JSC Georgian State Electrosystem, the Georgian electricity transmission system operator — substation and transmission-line construction, primary equipment supply, consultanc

Regenerated from source · build September 10, 2026