"How to perform SELECT queries in PostgreSQL" matching MCP servers:

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.

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.

MCP server that provides statistically rigorous weather and climate context by exposing the Baseline API as agent tools, enabling queries about climate conditions and comparisons against historical data.

Enables on-demand weather queries for up to three named locations via Open-Meteo, supporting current conditions, forecasts, rain probability, and conversational location management in English or Japanese.

Provides comprehensive weather data (forecasts, historical, air quality, marine) from Open-Meteo through 12 tools, with support for single and batch location queries.

Provides real-time weather temperature queries for any city with an interactive UI form, using Open-Meteo API (no API key needed).

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.

Exposes Weather Underground personal weather station data as tools in Claude, enabling queries for current conditions, daily summaries, hourly history, and station metadata.

A Model Context Protocol server for space weather and geomagnetic conditions, enabling AI agents to answer queries about solar flares, solar wind, geomagnetic storms, aurora forecasts, and more from authoritative data.

Provides current weather and forecast data for any city via OpenWeatherMap. Can be used with Ollama or Claude Desktop for natural-language weather queries.

Provides live Greek weather data from EMY, including forecasts, alerts, marine bulletins, warnings, and climate records. Supports location-based queries by name, ID, or coordinates without requiring an API key.

This MCP server enables AI assistants to perform calculations, fetch live weather, manage in-memory notes, access system info and note resources, and use reusable code review and summarization prompts.

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

Enables MCP hosts to access verifiable, decision-grade signals across five domains (hydrology, air quality, agriculture, power grid, shipping, regulatory filing) with pay-per-call in USDC via x402.

Provides real-time weather alerts for US states using the National Weather Service API, enabling users to fetch and view active weather warnings through natural language queries.

An MCP server that provides weather forecast tools for Israel (via Playwright web scraping) and the USA (via NWS API), enabling LLM agents to answer weather queries in natural language.

Enables fetching current weather forecast for cities in Israel by scraping weather2day.co.il using Playwright.

Provides access to real-time and historical water conditions of the Aare river in Switzerland, including water temperature, flow rates, swimming recommendations, and data from multiple monitoring locations along the river.

MCP server that provides tools to access Google Maps Environment APIs for air quality, pollen, and weather data, enabling queries like current conditions, forecasts, and history.

An MCP server that provides Korean weather information from the Korea Meteorological Administration's short-term forecast API, enabling natural language queries about weather conditions such as current weather, rain forecasts, and suitability for outdoor activities.