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

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.

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.

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.

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.

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.

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.

Tracks how long you've been indoors, nags you to touch grass, detects frustration, and recommends nearby parks with live weather.

A Model Context Protocol (MCP) server that provides access to Japanese weather forecasts using the weather.tsukumijima.net API.

A Model Context Protocol server that provides comprehensive weather data and forecasts through the OpenWeatherMap API, enabling AI assistants to access real-time weather information, forecasts, air quality data, and location services.