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

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.

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.

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.

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.