"A tool that can connect to MySQL database, understand table structure and query related data" matching MCP servers:

Enables agents to answer whether it's a good day to go up, hike, or take the cable car, and to rank the best day in the seven-day forecast using live weather, summit conditions, cable car status, and hours. It adds freshness warnings, out-of-forecast handling, clear errors, and an eval suite for validating agent tool use.

Enables querying current weather conditions for a named location with an optional country code, returning structured results that include units, time, resolved location, and data source.

Enables to query real-time weather information for any city worldwide by automatically geocoding city names and retrieving temperature, precipitation, and other data via Open-Meteo APIs, seamlessly integrated with Claude Desktop.

A production-oriented MCP server exposing tools for weather, currency conversion, text statistics, and server introspection, with auto-discovery, rate limiting, and API key auth.

An India-focused MCP server that provides real-time weather conditions, forecasts, air quality data, and location search capabilities using the OpenWeatherMap API.

Provides access to Japan Meteorological Agency (JMA) weather data including real-time observations, historical weather data, and forecasts from 1286 AMeDAS stations across Japan.

A minimal MCP server using FastMCP to demonstrate tool creation, including a get_weather example.

An MCP server that makes live Earth data usable by AI agents. Its initial data sources cover natural hazards: earthquakes from the USGS FDSN event catalog and volcanic activity from the Smithsonian Global Volcanism Program.

Enables AI agents to fetch real-time weather conditions, 5-day forecasts, and coordinate-based climate data for global locations, with x402 micropayment integration for paid API access.

Fetches live weather data from Open-Meteo without an API key and returns structured JSON with location disambiguation, enabling weather queries in LM Studio chat.

Real-time Singapore government data for AI agents. Weather forecasts, air quality (PSI/PM2.5), HDB carpark availability, and taxi supply from data.gov.sg.

A simple MCP service that allows users to query weather conditions for cities worldwide through the Cursor AI assistant.

Exposes the getWeather and getTime tools over a stateless streamable-HTTP MCP endpoint at /mcp, so clients can look up weather for a location and the current time for a timezone through MCP tool calls. Running the same pure tool code as the app's OpenAPI surface, it lets you register the deployment as a remote MCP tool and compare MCP against custom-OpenAPI integration.

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 Model Context Protocol tool that provides weather information for cities, with London access requiring Solana devnet payment via the Latinum Wallet MCP server.

Enables access to Singapore government open data and real-time environment/transport feeds including weather, air quality, taxi availability, and traffic incidents.

Provides real-time weather data, forecasts, and historical weather information from OpenWeatherMap API for Claude Desktop, enabling natural language queries about current conditions, forecasts, air quality, and weather alerts worldwide.

Enables Claude Code to query real-time Korean weather, air quality, and monitoring station information through natural language, using public data APIs with caching and error handling.

An MCP server implementation that allows users to fetch and display weather information for specified cities, including temperature, humidity, wind speed, and weather descriptions.

Provides real-world tools for weather data, stock market information, and internet search through the Model Context Protocol. Integrates with OpenWeatherMap, Stooq market data, and Google Custom Search APIs.

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.

Official aviation data MCP by Flight Master DAST (航班管家 DAST), providing flight status, route search, onboard comfort, delay and cancellation risk, airport weather forecasts, and real-time or historical flight trajectories.

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 real-time weather information for cities worldwide using the OpenWeatherMap API, accessible through natural language queries via the MCP protocol.

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.

A simple educational MCP server implemented in Node.js that allows users to fetch weather information for cities using the Open-Meteo API.

A minimal MCP server built with TypeScript exposing a single mocked weather tool over stdio transport.

Enables AI agents to retrieve live weather updates for any city via OpenWeatherMap, wrapped in MCP format.

MCP server providing access to Malaysia's government datasets, dashboards, weather forecasts, and transport data through a unified search system and hybrid data access architecture.