Skip to main content
Glama
deenesjakoruzh
dylanpieper

RMI Utility Transition Hub — MCP Server

by dylanpieper
OverviewSchemaRelated ServersScoreDiscussions
Python
Local

MCP Server for RMI's Utility Transition Hub

This MCP server loads RMI's public Utility Transition Hub data into DuckDB. Any MCP client can then query U.S. utility emissions, generation mix, and climate alignment with natural language.

WARNING

This is a demo. Use it at your own risk.

This software is not audited, validated, or ready for production. The tools can return errors. The tools can also aggregate the data incorrectly, and a language model can interpret the results incorrectly.

Check every result against the Utility Transition Hub and the RMI methodology before you cite it, publish it, or make a decision with it. RMI does not endorse this tool. This tool has no affiliation with RMI.

Setup

1. Install the Dependencies

pip install fastmcp duckdb pandas pymupdf

Or use uv:

uv init rmi-mcp-uth
cd rmi-mcp-uth
uv add fastmcp duckdb pandas pymupdf

2. Download the RMI Data

Download the data from the Utility Transition Hub. Extract the data into a data/ directory:

mkdir data
cd data

curl -LO https://utilitytransitionhub.rmi.org/static/data_download/data_download_all_pt_1.zip
curl -LO https://utilitytransitionhub.rmi.org/static/data_download/data_download_all_pt_2.zip

unzip -q -o -j data_download_all_pt_1.zip
unzip -q -o -j data_download_all_pt_2.zip

rm data_download_all_pt_1.zip data_download_all_pt_2.zip

3. Test With the MCP Inspector

npx @modelcontextprotocol/inspector python server.py

This command opens a browser interface. In the interface, you can call each tool, examine the resources, and monitor the protocol traffic.

4. Connect a Client

The server uses the stdio transport, and any MCP client can connect to it. See your provider's documentation or ask your agent (e.g., Claude Code) to set it up.

Related MCP server: US ISO Grid MCP

What the Server Exposes

Tools

Tool

What it does

list_tables

Show all tables, columns, and row counts

preview_table

Show sample rows from a table

list_utilities

Find utilities by state or name. The best matches come first.

get_emissions_trend

Show CO2 emissions over time for a utility. start_year and end_year limit the range.

get_generation_mix

Show the generation breakdown by technology_rmi. group_by="technology" combines the subsidiaries of a parent into one fleet.

get_climate_alignment

Compare the actual CO2 to the 1.5°C pathway. start_year and end_year limit the range.

rank_climate_alignment

Rank utilities or parents by distance from the 1.5°C pathway. Excludes the utilities whose benchmark makes the comparison meaningless, and says which.

query_data

Run read-only SQL in DuckDB syntax

Resources

URI

Description

rmi://data-dictionary

A summary of the datasets, columns, and units

rmi://data-dictionary-full

The full data dictionary PDF. It gives the definitions, sources, and methodology for each field.

rmi://methodology

The RMI methodology document. It gives the data sources, assumptions, and calculations.

Prompts

Prompt

Description

decarbonization_assessment

Analyze the climate progress of a utility

state_landscape

Show an overview of the utilities in a state

investment_risk_profile

Show the financial exposure of a utility to fossil fuel assets

Example Conversations

  • "Which US utilities are furthest off the 1.5°C pathway?"

  • "Which Wisconsin utilities have the highest CO2 emissions?"

  • "Compare Alliant Energy and Xcel Energy's generation mix"

  • "Show me Wisconsin Power & Light's emissions trend since 2015"

  • "Is Alliant Energy on track for 1.5°C, or is WEC Energy Group closer?"

  • "What share of Wisconsin generation comes from renewables?"

Rebuilding the Database

Delete utility_hub.duckdb and restart the server. The server builds the database again from the CSV files.

Data License

RMI licenses the Utility Transition Hub data under CC BY 4.0.

Install Server
RayrunBuild, deploy, and operate MCP servers without becoming an infrastructure team.ray.runAd
F
license - not found
A
quality
C
maintenance

How are these scores calculated?

Maintenance

–Maintainers
–Response time
–Release cycle
–Releases (12mo)
Commit activity

Resources

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Tools

Related MCP Servers

  • northwood-carbon MCP server

    trippborstel-hub
    F
    license
    A
    quality
    D
    maintenance
    An MCP server that provides access to Northwood Capital Partners' portfolio carbon data, enabling MCP-compatible agents to query emissions, analyze decarbonization gaps, and simulate reduction initiatives through natural language.
    5

  • US ISO Grid MCP

    pipeworx-io
    A
    license
    Not graded
    quality
    C
    maintenance
    Enables real-time access to US electricity generation, fuel mix, and demand data through natural language queries.
    15
    MIT
  • Atlas MCP by AtlasDevHQ

    Atlas MCPofficial

    AtlasDevHQ
    A
    license
    Not graded
    quality
    A
    maintenance
    Enables natural language querying of SQL databases and REST APIs through the MCP protocol, grounded in a semantic layer.
    2,887
    1
    AGPL 3.0

View all related MCP servers

Related MCP Connectors

  • eia-energy-mcp-server

    Browse and query the EIA API v2 — electricity, petroleum, natural gas, coal, forecasts via MCP.

  • Microsoft MCP Server for Enterprise

    Official Microsoft MCP Server to query Microsoft Entra data using natural language

  • mcp

    GibsonAI MCP server: manage your databases with natural language

View all MCP Connectors

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/dylanpieper/rmi-mcp-uth'

If you have feedback or need assistance with the MCP directory API, please join our Discord server