"How to access and read a local SQL database" matching MCP servers:

Enables running MCP tools locally in VS Code, currently providing US weather alerts and forecasts via the National Weather Service API.

A local testing MCP server that provides weather information for L'Hospitalet de Llobregat using the Open-Meteo API, accessible from mobile devices via SSE transport on local networks.

A local MCP server that integrates FastMCP with OpenAI to enable natural language queries for current weather, forecasts, and currency conversion using ExchangeRate-API and Open-Meteo.

A customizable Model Context Protocol server implementation that enables AI models to interact with external tools including weather queries, Google search, and camera control functionality.

Enables local control of an LED weather display, allowing users to manage weather data and LED settings through natural language.

Archives Garmin Connect health data locally (steps, HR, sleep, body battery) as JSON, no cloud, and also pulls context data (weather, pollen, air quality). Built-in MCP server (with SQLite cache) exposes the archive for querying via LLM tool calls.

Enables AI to read live weather data and manage a persistent to-do list through MCP tools, demonstrating both read and write capabilities without API keys.

Provides access to Hong Kong climate and weather data from the Hong Kong Observatory, including current conditions, forecasts, warnings, tides, and more.

An MCP server that provides real-time weather alerts, forecasts, stock market data, and news information through various API integrations.

Provides a health check and a get_weather tool to query current weather by city name via HTTP, designed for integration with Dify.

Enables interactive access to JAXA's satellite observation data (precipitation, land surface temperature, NDVI, elevation, soil moisture) via Claude, providing tools for point time series, dataset information, and area image generation.

Provides current weather alerts for specified locations to AI assistants through the Model Context Protocol.

Enables real-time weather lookup for any location via MCP, returning concise summaries from wttr.in.

Provides real-time weather forecasts and international time details through MCP tools, including geocoding, hourly/daily forecasts, and timezone information for any city.

Enables travel-related queries and planning including weather, train and flight information, itinerary generation, and travel knowledge retrieval via RAG, using an AI agent with MCP protocol.

A simple MCP server that provides weather tools, deployable with Docker, and designed to be used with Claude Desktop via a WSL bridge.

Demonstrates OAuth2/OIDC authentication for MCP servers using Asgardeo, with JWT validation and a sample weather tool to showcase secured API access.

Claude Code plugin and MCP server that nudges you to take outdoor breaks based on local weather, sunset timing, and session streaks. Exposes check_grass_conditions, suggest_activity, log_touch_grass, and get_stats tools — fully local, no API keys, no cloud storage.

Provides AI assistants with access to real-time space weather data and forecasts from NOAA's Space Weather Prediction Center, enabling queries and interpretations of geomagnetic storms, solar flares, and related indices.

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 models to access Swiss weather and climate data from MeteoSwiss, including current observations, forecasts, and warnings.

Exposes Swiss weather forecast data as MCP tools, including rainfall, sunshine, temperature, wind, and more, with local caching.

Enables access to Japan Meteorological Agency data through MCP, covering weather forecasts, warnings, earthquakes with seismic intensity, tsunami bulletins, and volcano alerts, with place-name lookup in kanji, kana, or romaji and no API key.

Solar vitamin D: whether the sun where you are can make vitamin D right now, how many minutes your Fitzpatrick skin type needs for a target dose, which months of the year synthesis is possible at your latitude, and how much a sun session produced. Computed from solar geometry, a clear-sky UV model with ozone and altitude, and live Open-Meteo UV data.

Wraps a climate data-processing pipeline so agents can inspect the config schema and available sample CSVs, validate an inline JSON config, and run the pipeline to return a monthly summary table plus a rendered plot, with file access sandboxed to the data and outputs directories.

Provides comprehensive access to Portuguese weather data from IPMA, including forecasts, warnings, sea state, fire risk, UV index, seismic activity, and weather station observations for all Portuguese cities and islands.

Provides access to Danish weather data from the Danish Meteorological Institute, enabling users to retrieve current conditions, hourly forecasts, and historical records. It supports location lookups via city names, postal codes, and coordinates for any Danish region.

Provides US weather forecasts, current conditions, alerts, earthquakes, elevation, and geocoding via keyless US-government data feeds. Enables AI agents to access real-time weather and geospatial data without API keys.

Provides real-time access to Polish meteorological and hydrological data from IMGW-PIB, including weather observations, river levels, and weather warnings, without requiring an API key.

Enables users to check whether a beach suits a beach day or a surf session today or up to six days ahead, using Open-Meteo weather and marine forecasts scored by deterministic, documented rules. It exposes tools for raw hourly forecast data, suitability scores and verdicts by activity and skill level, and finding the best multi-hour window within a day.