"How to create, read from, and write to a database" matching MCP servers:

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 unofficial read-only MCP server for Panasonic AiSEG2 home energy management controllers, enabling clients to read live power flow, per-circuit consumption, circuit names, daily totals, and historical energy/cost data from the device's local web interface.

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.

DeepPVMapper is an open source, crowdsourced verified AI map of rooftop solar systems. The MCP serves as a endpoint to allow queries to the database (1.1M+ systems) in natural language. This work is based on my former PhD work.

Enables Claude or any MCP client to read live and historical Sunsynk inverter, battery, and solar data, plus inverter settings, through the Sunsynk Connect cloud API. It is read-only and lets users ask natural-language questions about generation, consumption, charging, and configuration.

Connect AI assistants to Victron Energy systems to read real-time solar, battery, grid, and inverter data from your local network via Modbus TCP or MQTT.

Connects Claude and other MCP clients to myGEKKO building controllers via the official Query API, enabling natural-language queries and control of smart-home devices. It is read-only by default, with write actions available only through explicit opt-in and safety policies.

Enables querying and retrieving details of U.S. BLM geothermal leases from the MLRS database, including search and single-lease lookup.

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.

Enables AI assistants to read and write selected values from IDM heat pumps via Modbus TCP, providing controlled access to operational data and setpoints.

Enables users to read power, energy counters, events, and settings from KOSTAL PLENTICORE inverters, and to preview or apply plant-owner settings changes through the inverter's local REST API.

Enables AI assistants to query Tesla vehicle data and analytics from a TeslaMate PostgreSQL database, including battery health, driving statistics, charging sessions, and custom SQL queries.

Enables users to ask directly within a Claude Code or Codex chat how much energy and CO2eq their current session or entire project has consumed, estimated locally from session logs with no telemetry or network calls. It also reports everyday-activity equivalents such as kettle boils or washing machine cycles for the resulting figures.

Enables classifying electricity meter days as active, standby, off, or unsure from 96 fifteen-minute kWh readings plus a meter reference, with batch support for up to 31 days and model metadata. Runs fully offline as a frozen scikit-learn classifier, exposing single-day and batch classification plus model-info tools over STDIO or HTTP.

MCP server for professionals to consult and download Cemig electricity bills from official sources, with prepaid credit per query. Read-only and works with any MCP client over HTTP.

Enables users to query and download Cemig electricity bills from official sources via natural language, with read-only access and pre-paid credits across various MCP clients.

This MCP server provides a single read-only tool to query official CPFL (electric utility) bill download data via a hosted, prepaid service without requiring platform credentials.

Connects MCP clients such as Claude to a NIBE myUplink heat-pump account, letting users list systems and devices, read sensor values and common parameters, check alarms, view smart-home zones, and write settings where scopes allow. Handles the OAuth2 authorization-code and client-credentials flows, refreshing tokens automatically while keeping credentials in a local .env file.

Read-only MCP server for querying Enel Rio de Janeiro's official list of installations using a single tool, hosted with prepaid pay-per-use pricing.

Enables prospecting lists of addresses, points or a bounding box through the Google Solar API's detected-arrays insight, reporting for each building whether rooftop PV is already detected, how old the capture imagery is, and how strong the roof's solar potential is. It ranks the remaining buildings into a reviewable prospect list while tracking call budget and list-price cost.

Connects Claude Desktop to the Enphase Developer API v4 for read-only access to solar production, consumption, battery, and EV charger data, with optional write tools for battery settings and EV charging.

Enables searching and retrieving US electricity tariff data from NREL's OpenEI Utility Rate Database, including rate schedules, charges, and utility information for locations.

Enables querying the official ANP Base de Distribuição database for distribution base information through a read-only, hosted MCP endpoint with prepaid per-query credits.

Gives AI assistants read-only, vendor-independent tools to analyze heat pump cycling, real heating curve, room behavior, energy signature, and efficiency from Home Assistant sensor data, returning structured findings with coverage and assumptions.

Enables users to consult and download second copies (2ª via) of Comgás gas bills from the official source via a read-only tool, with prepaid per-query credit.

Enables AI agents to interact with IoT device data from a smart city, including public lighting, water, and gas meters. Supports querying and management via the Model Context Protocol.

Read-only MCP server to consult Neoenergia (Elektro) energy bills via official source with OCR, pay-per-query.

Read-only MCP server for downloading and OCR-processing CPFL electricity bills from official sources, supporting any MCP client with prepaid per-query credits.