{"data":{"name":"io.github.cyanheads/eia-energy-mcp-server","title":null,"description":"Browse and query the EIA API v2 — electricity, petroleum, natural gas, coal, forecasts via MCP.","version":"0.4.4","websiteUrl":null,"repositoryUrl":"https://github.com/cyanheads/eia-energy-mcp-server","remotes":[{"url":"https://eia-energy.caseyjhand.com/mcp","type":"streamable-http"}],"packages":[{"version":"0.4.4","identifier":"@cyanheads/eia-energy-mcp-server","runtimeHint":"stdio","registryType":"npm","runtimeArguments":null,"environmentVariables":null},{"version":"0.4.4","identifier":"@cyanheads/eia-energy-mcp-server","runtimeHint":"streamable-http","registryType":"npm","runtimeArguments":null,"environmentVariables":null}],"status":"active","isLatest":true,"publishedAt":"2026-10-12T23:25:50.380Z","updatedAt":"2026-10-12T23:25:50.380Z","source":"official-registry","verification":"official","confidence":100,"stars":null,"sources":[{"stars":null,"title":null,"source":"official-registry","sourceId":"io.github.cyanheads/eia-energy-mcp-server","updatedAt":"2026-10-12T23:25:50.380Z","confidence":100,"websiteUrl":null,"description":"Browse and query the EIA API v2 — electricity, petroleum, natural gas, coal, forecasts via MCP.","verification":"official","repositoryUrl":"https://github.com/cyanheads/eia-energy-mcp-server"}],"toolIndex":{"tools":[{"serverName":"io.github.cyanheads/eia-energy-mcp-server","endpointFingerprint":"7ea3748c2d038746a5d183e98ce5ce7cb6e009d2baeabcabb3d697da145be08f","name":"eia_browse_routes","title":"Browse EIA Routes","description":"Lists child routes under a given path in the EIA dataset taxonomy. Start with no path to get the 14 top-level categories (electricity, petroleum, natural-gas, steo, aeo, ieo, seds, etc.), then drill into subcategories. Each result includes an isLeaf flag — leaf routes are queryable endpoints; non-leaf routes have children to browse. When isLeaf is true on the browsed path itself, switch to eia_describe_route. The first call after server start waits up to 20s for the route tree to warm, then answers from EIA directly.","inputSchema":{"type":"object","properties":{"path":{"description":"Route path to browse (e.g. \"electricity\", \"petroleum/pri\"). Omit for root. Whitespace and slashes are normalized, then one complete leading v2 segment is removed: \"/v2/electricity/retail-sales/\" resolves to \"electricity/retail-sales\", and \"/v2/\" to root. A path naming an EIA endpoint is refused: pass the route before its data or facet segment (\"petroleum/pri/spt\", not \"petroleum/pri/spt/data\" or \"petroleum/pri/spt/facet/series\"), and give the ID of a seriesid/{id} path to eia_search_routes. Full URLs are not normalized.","type":"string"}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"openWorldHint":false},"definitionHash":"28d375785dce9c445837bf7049f691895cd6b1962a80f37d875c055520e32c00","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:32.849Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/eia-energy-mcp-server","endpointFingerprint":"7ea3748c2d038746a5d183e98ce5ce7cb6e009d2baeabcabb3d697da145be08f","name":"eia_dataframe_describe","title":"Describe EIA Dataframes","description":"List canvas dataframes (df_<id>) materialized by eia_query_route calls that passed stage: true, with provenance, expiry, row count, and column schema. Nothing is staged until such a call runs, so an empty list on a fresh session means no query has staged yet, not that staging failed. Drops entries for dataframes the canvas no longer holds before responding, so the list is always current. Pass a specific name to inspect one dataframe; omit to list all active dataframes for this tenant. A name that is not staged comes back as found=false alongside the handles that are, never as an empty list. Listing is not use: only an eia_dataframe_query statement naming a dataframe extends its expiry, so a dataframe polled with this tool and never queried still lapses on schedule.","inputSchema":{"type":"object","properties":{"name":{"description":"df_<id> handle to describe a single dataframe. Omit to list all active dataframes.","type":"string"}},"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false},"definitionHash":"74682b3dc521f74c2637c887a2abfa88deec3648e198d08aea0b255a1c2d649e","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:32.849Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/eia-energy-mcp-server","endpointFingerprint":"7ea3748c2d038746a5d183e98ce5ce7cb6e009d2baeabcabb3d697da145be08f","name":"eia_dataframe_query","title":"Query EIA Dataframes","description":"Run a single-statement SELECT against canvas dataframes registered by eia_query_route calls that passed stage: true — a query that staged nothing leaves no table to select from. Standard DuckDB SQL — joins, aggregates, window functions, CTEs all supported. Reference dataframes by the df_<id> handles returned by eia_query_route or listed by eia_dataframe_describe. Read-only: writes, DDL, DROP, COPY, PRAGMA, ATTACH, file reads (read_* functions or a quoted file path), engine-setting functions (current_setting), and SQL built from a string (query_table) are rejected. System catalogs are denied: information_schema, pg_catalog, and the DuckDB internal metadata views (duckdb_tables, duckdb_columns, and the other duckdb_ views; sqlite_master and the other sqlite_ views; pragma_database_list; pg_class, pg_tables, and the other pg_ views) are refused as whole words anywhere in the statement outside string literals and comments, column aliases and CTE names included, as is any duckdb_<name>() call. A register_as name spelled like one of them is refused, since no statement could select from a table so named. EIA data values are VARCHAR — use CAST(col AS DOUBLE) for arithmetic and aggregation. Optional register_as chains results as a new dataframe with a fresh expiry. Every dataframe named in the statement has its expiry extended by the query. Inline rows stop at preview; a result cut short says how to reach the rest, including paging a register_as table with LIMIT/OFFSET and no ORDER BY, which keeps the order the preview showed.","inputSchema":{"type":"object","properties":{"sql":{"type":"string","minLength":1,"description":"Single-statement SELECT against df_<id> tables. EIA data columns are VARCHAR — use CAST(col AS DOUBLE) for arithmetic. Example: SELECT period, CAST(value AS DOUBLE) AS val FROM df_XXXXX ORDER BY period"},"register_as":{"description":"When set, persist the result as a new dataframe with a fresh expiry. Use to chain analyses without re-running upstream queries. The name must be unused — reusing a staged name is rejected, and the fix is a different name, not dropping the existing dataframe. eia_dataframe_describe lists the names already taken. A name spelled like a denied system catalog (information_schema, pg_tables, duckdb_tables, sqlite_master, and the rest the tool description lists), in any case, is refused as system_catalog_access; a longer name that only contains one, such as pg_tables_2024, is accepted.","type":"string","minLength":1},"preview":{"description":"Rows to include in the immediate response. Default 25; a larger value returns at most row_limit and says so. 0 returns none, useful when chaining via register_as.","type":"number","minimum":0,"multipleOf":1},"row_limit":{"default":1000,"description":"Hard cap on rows materialized. Default 1,000; a larger value returns at most 10,000 and says so. Rows past the cap are dropped without being counted — the response then carries truncated: true and a totalRows equal to the cap rather than a true total. Pass register_as to materialize the whole result instead and get an exact count.","type":"number","minimum":1,"multipleOf":1}},"required":["sql"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"idempotentHint":true,"openWorldHint":false},"definitionHash":"998518f754120f9c896da2c888769714fe062ab7a586e23e80f18b7de116e97d","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:32.849Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/eia-energy-mcp-server","endpointFingerprint":"7ea3748c2d038746a5d183e98ce5ce7cb6e009d2baeabcabb3d697da145be08f","name":"eia_describe_route","title":"Describe EIA Route","description":"Returns metadata for a leaf route: available facets with their valid values, data column names and units, frequency options, and date range. Call this before eia_query_route to discover valid facet IDs, facet values, column IDs, and frequency codes. Each facet returns a capped window of its values with value_count and values_truncated alongside; pass facet and values_offset to page through the rest of one facet. To find a value by name in a large facet (plant, entity, and mine IDs run to thousands), pass values_query: each facet keeps only the values whose id, name, or alias contains it — on a balancing-authority facet, also a value whose ISO/RTO acronym does, so \"ERCOT\" finds ERCO — values_matched counts them, and values_offset pages the matches. A values_offset past the last value of a facet returns an empty window for it and a notice naming the count to page against. Facet values are fetched from separate EIA endpoints, merged, and cached per route for 24 hours, after which the next call fetches the route again; a facet whose values EIA did not return is left out of facets, named in unavailable_facets, and fetched again by the next call. When a refresh fails, the cached values are served instead, with a notice naming when they were fetched.","inputSchema":{"type":"object","properties":{"route":{"type":"string","minLength":1,"description":"Leaf route path (e.g. \"electricity/retail-sales\", \"steo\"). Discoverable via eia_browse_routes or eia_search_routes. Whitespace and slashes are normalized, then one complete leading v2 segment is removed: \"/v2/electricity/retail-sales/\" resolves to \"electricity/retail-sales\". A path naming an EIA endpoint is refused: pass the route before its data or facet segment (\"petroleum/pri/spt\", not \"petroleum/pri/spt/data\"), with a facet ID in facet rather than in the path (\"petroleum/pri/spt/facet/series\" is route \"petroleum/pri/spt\", facet \"series\"), and give the ID of a seriesid/{id} path to eia_search_routes. Full URLs are not normalized."},"facet":{"description":"Restrict the response to one facet by ID (e.g. \"stateid\"). Use with values_offset to page a facet whose values were truncated, or with values_query to find a value in it. Omit to get every facet.","type":"string","minLength":1},"values_offset":{"default":0,"description":"Index of the first facet value to return, applied to every facet in the response. Use the value named in a truncation hint to continue past the cap. With values_query, indexes the matching values.","type":"integer","minimum":0,"maximum":9007199254740991},"values_query":{"description":"Keep only the facet values whose id, name, or alias contains this text, ignoring case (e.g. \"palo verde\" on plantCode). On the balancing-authority facets of electricity routes (respondent, fromba, toba, parent, balancing_authority_code), a value also matches when its ISO/RTO acronym contains the text: \"ERCOT\" finds ERCO, \"CAISO\" finds CISO, \"SPP\" finds SWPP and SWPW. A plain substring match, not a pattern or a ranked search. Applied to every facet in the response, before values_offset and the cap. Leading and trailing whitespace is ignored. Omit to list every value.","type":"string","minLength":1}},"required":["route"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"openWorldHint":false},"definitionHash":"c09fad1f69608d201ea986002f453415af3b531b506a7b5984eaf58330003500","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:32.849Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/eia-energy-mcp-server","endpointFingerprint":"7ea3748c2d038746a5d183e98ce5ce7cb6e009d2baeabcabb3d697da145be08f","name":"eia_query_route","title":"Query EIA Route Data","description":"Fetches data from a leaf route with optional facet filters, date range, frequency, and column selection. Use eia_describe_route first to discover valid facet IDs, facet values, column IDs, and frequency codes. Data values are strings in the response (EIA API returns all numeric values as strings, e.g. \"9.13\"); cast to DOUBLE in SQL when arithmetic is needed. Returns a preview inline and stages nothing by default — one upstream request, whatever total says. Pass stage: true to also page past the preview and stage the accumulated set as a DataCanvas table, then pass the returned dataset name to eia_dataframe_describe for its column names and eia_dataframe_query for SQL. Every dataset a tenant stages lands in the same canvas, so tables from different routes cross-join by name with nothing to thread between calls.","inputSchema":{"type":"object","properties":{"route":{"type":"string","minLength":1,"description":"Leaf route path (e.g. \"electricity/retail-sales\", \"steo\"). Discoverable via eia_browse_routes or eia_search_routes. Whitespace and slashes are normalized, then one complete leading v2 segment is removed: \"/v2/electricity/retail-sales/\" resolves to \"electricity/retail-sales\". A path naming an EIA endpoint is refused: pass the route before its data or facet segment (\"petroleum/pri/spt\", not \"petroleum/pri/spt/data\" or \"petroleum/pri/spt/facet/series\"), and give the ID of a seriesid/{id} path to eia_search_routes. Full URLs are not normalized."},"filters":{"description":"Facet filters keyed by facet ID (e.g. { \"stateid\": \"TX\", \"sectorid\": [\"RES\", \"COM\"] }). Use the facets[].id values returned by eia_describe_route as keys here. Every value travels in the request URI, which EIA caps at about 8 KB — a few hundred values across all filters; split a longer list across calls.","type":"object","propertyNames":{"type":"string"},"additionalProperties":{"anyOf":[{"type":"string"},{"type":"array","items":{"type":"string"}}]}},"columns":{"description":"Data column IDs to return (reduces payload). Defaults to all. IDs discoverable via eia_describe_route data_columns[].id. Every row also carries period and each facet ID whatever this lists, so naming those here is unnecessary and they are dropped from the request.","type":"array","items":{"type":"string"}},"frequency":{"description":"Aggregation frequency ID (e.g. \"monthly\", \"annual\"). Defaults to route default. Valid IDs from eia_describe_route.","type":"string"},"start":{"description":"Period start in the route date format (e.g. \"2020-01\" for monthly, \"2020\" for annual). Format from eia_describe_route. EIA reads a bound as the period of the effective frequency containing its first day, so a coarser bound selects that one period (\"2020\" is 2020-01 at monthly, \"2020-Q4\" is 2020-10). At local-hourly every bound needs its hour and UTC offset (YYYY-MM-DDTHH±HH, e.g. \"2024-02-01T02-06\").","type":"string"},"end":{"description":"Period end, read the same way as start: a coarser end selects only its first period, so \"2020\" ends at 2020-01 at monthly — use \"2020-12\" to include the whole year. At hourly a date-only end covers its whole day.","type":"string"},"sort":{"description":"Result ordering.","type":"array","items":{"type":"object","properties":{"column":{"type":"string","description":"Column ID to sort by."},"direction":{"type":"string","enum":["asc","desc"],"description":"Sort direction."}},"required":["column","direction"],"description":"A sort criterion."}},"offset":{"default":0,"description":"Row offset into the matching set (default 0). An offset at or beyond total returns zero rows.","type":"integer","minimum":0,"maximum":9007199254740991},"length":{"default":25,"description":"Rows per page. Default 25; a larger value returns at most 5,000 and says so. With stage: true, staging is not bounded by this — it pages past the page on its own.","type":"number","minimum":1,"multipleOf":1},"stage":{"default":false,"description":"Stage the matching rows as a DataCanvas table for SQL (default false). Off, the call makes one upstream request and returns the preview alone. On, the service pages past the preview up to the staging row cap this server sets and registers the accumulated rows, starting at offset, returning the handle in dataset — several extra upstream requests and seconds of latency on a large route, so turn it on when moving to analysis, not while exploring. Requires the server to have a canvas, which it does unless its operator turned it off; without one nothing is staged whatever this is set to.","type":"boolean"}},"required":["route"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"openWorldHint":false},"definitionHash":"b6feec46656491ecb7e32051a8d0b6ffea4663893b99aa9b5ec087556277c2ad","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:32.849Z","metadataTrust":"untrusted"},{"serverName":"io.github.cyanheads/eia-energy-mcp-server","endpointFingerprint":"7ea3748c2d038746a5d183e98ce5ce7cb6e009d2baeabcabb3d697da145be08f","name":"eia_search_routes","title":"Search EIA Routes","description":"Fuzzy text search across route names, descriptions, category labels, and the names of the data columns a route publishes. Resolves natural-language queries like \"electricity retail sales by state\" or \"natural gas imports\" to matching route paths, and a measure named only by its column — \"nameplate capacity\", \"gross generation\" — to the route that publishes it. Multi-term queries are also matched term by term, so combining a commodity, a metric, and a sector — \"electricity price residential\", \"coal generation industrial sector\" — reaches the route carrying that data even when no single entry reads like the whole phrase. A query spelling the end of a route path in words — \"retail sales\" for electricity/retail-sales — ranks that route first. STEO, SEDS, and Monthly Energy Review (total-energy) series names are indexed so queries like \"crude oil production forecast\", \"motor gasoline total consumption\", or \"primary energy consumption total\" also resolve — a series also by its ID, such as \"PATCPUSX\", \"MGTCB\", or \"TETCBUS\" — and so are facet values, so a fuel type or sector term like \"wind\" or \"anthracite coal\" resolves to the route that exposes it, with filter_hint carrying the filter to pass on. That includes the series and product names of the daily and weekly petroleum and natural-gas routes and the RTO balancing authorities, so benchmarks like \"Henry Hub\", \"WTI crude spot price\", \"Cushing\", or \"Electric Reliability Council of Texas\" resolve before any describe; a balancing authority also answers to its EIA code or its ISO/RTO acronym (\"ERCO\", \"ERCOT\", \"CAISO\", \"SPP\"). A legacy APIv1 series ID as the EIA website and Excel add-in write them — \"PET.RWTC.W\", \"ELEC.PRICE.TX-RES.M\" — is resolved through the EIA series lookup into one result with its route, filter_hint, frequency, and columns, ready for eia_query_route, without waiting on the index. Results include isLeaf so you know whether to browse further or query directly. Results with score > 0.72 are weak matches — try a more specific query or use eia_browse_routes to explore the taxonomy. The first call after server start waits 20-40s while the index warms, and at most 45s; later calls answer from the built index. Check indexComplete before reading anything into a short or empty result set.","inputSchema":{"type":"object","properties":{"query":{"type":"string","minLength":1,"description":"Free-text search terms to match against route names and descriptions, or a legacy APIv1 series ID (e.g. \"PET.RWTC.W\": three or more dot-separated segments ending in a frequency code A, Q, M, W, D, H, HL, or 4; any case). Leading and trailing whitespace is ignored, and only the first 256 characters are searched."},"limit":{"default":10,"description":"Maximum results to return. Default 10; a larger value returns at most 30 and says so. truncated says whether more matches exist.","type":"number","minimum":1,"multipleOf":1}},"required":["query"],"$schema":"https://json-schema.org/draft/2020-12/schema","additionalProperties":false},"annotations":{"readOnlyHint":true,"openWorldHint":false},"definitionHash":"1a8d171c0d0b447e42e7d75c3e1fdab17e315644b1f7ac2768b1139db101c16b","schemaStatus":"valid","origin":"official-registry","observedAt":"2026-11-19T07:46:32.849Z","metadataTrust":"untrusted"}],"endpoints":[{"endpointFingerprint":"7ea3748c2d038746a5d183e98ce5ce7cb6e009d2baeabcabb3d697da145be08f","protocol":"streamable-http","status":"indexed","toolCount":6,"observedAt":"2026-11-19T07:46:32.849Z"}],"authentication":"unknown"},"connectionConfigurations":{"status":"ready","authentication":"not embedded","clients":{"Claude Desktop":{"mcpServers":{"io.github.cyanheads/eia-energy-mcp-server":{"url":"https://eia-energy.caseyjhand.com/mcp"}}},"Cursor":{"mcpServers":{"io.github.cyanheads/eia-energy-mcp-server":{"url":"https://eia-energy.caseyjhand.com/mcp"}}},"VS Code":{"servers":{"io.github.cyanheads/eia-energy-mcp-server":{"type":"http","url":"https://eia-energy.caseyjhand.com/mcp"}}}}},"resourceType":"mcp-server","callable":true,"runtime":{"callable":true,"protocols":["mcp"]},"interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://eia-energy.caseyjhand.com/mcp"},{"protocol":"mcp","package":"@cyanheads/eia-energy-mcp-server","registryType":"npm","version":"0.4.4"},{"protocol":"mcp","package":"@cyanheads/eia-energy-mcp-server","registryType":"npm","version":"0.4.4"}],"profile":{"apiVersion":"1","schemaVersion":"1","id":"mcp-server:io.github.cyanheads%2Feia-energy-mcp-server","resourceType":"mcp-server","canonicalUrl":"https://www.agentsjunction.com/api/v1/servers/io.github.cyanheads%2Feia-energy-mcp-server","name":"io.github.cyanheads/eia-energy-mcp-server","description":"Browse and query the EIA API v2 — electricity, petroleum, natural gas, coal, forecasts via MCP.","interfaces":[{"protocol":"mcp","transport":"streamable-http","url":"https://eia-energy.caseyjhand.com/mcp"},{"protocol":"mcp","package":"@cyanheads/eia-energy-mcp-server","registryType":"npm","version":"0.4.4"},{"protocol":"mcp","package":"@cyanheads/eia-energy-mcp-server","registryType":"npm","version":"0.4.4"}],"capabilities":[],"identity":{"source":"official-registry","websiteUrl":null,"repositoryUrl":"https://github.com/cyanheads/eia-energy-mcp-server","version":"0.4.4"},"verification":{"state":"official","confidence":100},"operations":{"resourceType":"mcp-server","name":"io.github.cyanheads/eia-energy-mcp-server","status":"online","lastCheckedAt":"2026-11-20T09:18:02.483Z","lastSuccessfulCheck":"2026-11-20T09:18:02.483Z","latencyMs":246,"consecutiveFailures":0,"isStale":false,"checks":{"endpointReachable":true,"protocolValid":true,"agentCardValid":null,"mcpHandshakeValid":true},"lastSeen":null,"lastSuccessfulInteraction":null,"lastHealthCheck":"2026-11-20T09:18:02.483Z","source":{"type":"health-check","url":null},"observedAt":"2026-11-20T09:18:02.483Z"},"security":null,"timestamps":{"createdAt":"2026-10-12T23:25:50.380Z","updatedAt":"2026-10-12T23:25:50.380Z","observedAt":"2026-11-20T09:18:02.483Z"},"compatibility":{"serverVersion":"0.4.4","protocolVersions":[{"protocol":"mcp","version":null}]}}}}