"How to fetch and query data using a MySQL cursor" matching MCP servers:

Provides tools to search, inspect, and query energy open data from ODRE (electricity & gas production, consumption, grid load, renewables) using natural language or direct tool calls.

Enables live querying of oil & gas and geothermal well data from state regulator ArcGIS services, including searchable well records, operators, nearby wells, and raw queries, plus DOE GDR and Global Energy Monitor lookups.

A Model Context Protocol server providing free financial market data across 13 categories with 83 no-key tools, enabling access to stocks, indices, options, forex, crypto, energy, prediction markets, and more.

Enables querying Denmark's official open energy data from Energinet through MCP tools.

An MCP server that wraps the U.S. Energy Information Administration's Open Data API, enabling assistants to fetch live energy data via natural language. It provides tools for querying series, browsing data routes, filtering facets, and running custom queries.

Enables querying ENERGY STAR Open Data via Socrata MCP tools for searching datasets, running SoQL queries, and retrieving metadata.

Read-only MCP server for Energinet's public Energi Data Service. Enables dataset search, arbitrary dataset queries with filters, and CO2 emissions retrieval for DK1/DK2 without an API key.

Provides tools to discover and summarize French open energy data from multiple public sources, including electricity mix helpers.

Open-source MCP servers exposing US solar data (production, resource, economics, market, forecast) as agent-accessible tools with a consistent data envelope.

Enables AI agents to search and retrieve German open data through a remote, stateless Streamable HTTP endpoint — public procurement notices, Marktstammdatenregister energy units, and Bundesnetzagentur EV charging stations — with keyword, location, technology, and capacity filters plus aggregate statistics and data-freshness checks.

MCP server that enables Google ADK agents to triage solar fault signals, retrieve Salesforce diagnostics via hosted MCP prompt templates, and create WorkOrder records when replacements are needed.

Hourly electricity grid carbon intensity (gCO2eq/kWh) for 45 zones across Europe, the US and Great Britain, computed from ENTSO-E, EIA and NESO generation data. Four read-only tools; every value carries its interval timestamp and how stale it is. No API key, no account.

An MCP server for US electricity demand and weather data that provides tools, resources, and prompts to query hourly demand, daily demand, peak demand, and demand vs temperature across regions, all running locally with a bundled SQLite database.

Enables AI assistants to control a Homey Pro smart home hub, create automation flows from natural language, and query device and energy history.

An MCP server that exposes the U.S. Energy Information Administration (EIA) Open Data API, enabling LLMs to browse and query energy data across 17 datasets with generic, composable tools.

AI assistants can size heat pumps, estimate energy costs, and verify cold-climate performance using bundled data and no API keys.

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.

Enables LLM agents to query live data from Anker Solix solar systems (Solarbank, expansion batteries, Smartmeter) via natural language, such as current solar production or battery state of charge.

Enables AI agents and assistants to query Polish electricity market data from the SENS Energy Data API by discovering operators and tariffs, fetching composite prices, and inspecting tariff components through natural language.

Lets an MCP client read live power from a local IoTaWatt energy monitor over its HTTP API, query history logs for energy and interval data, inspect device configuration and channel definitions, and sample current waveforms to identify load types. All tools are read-only and require no cloud account.