"ClickHouse: A fast open-source columnar database management system" matching MCP servers:

Enables querying aviation weather, FAA TFRs, NWS alerts, flight tracking, and Amtrak train status using public APIs. No API keys or private infrastructure required.

An MCP server for Swiss Federal Railways (SBB) open data, enabling AI models to query real-time disruptions, passenger frequencies, station details, and more without an API key.

Enables AI assistants to search for vehicles, manage reservations, and access Enterprise Plus loyalty account information through headless browser automation on enterprise.com. It supports the complete car rental workflow including vehicle searching, booking, modifications, and points balance checks.

Provides Estonian public transport timetables, trip planning, stop search, and real-time vehicle tracking.

MCP server that lets citizens search and book Parks Canada campgrounds, accommodations, day use, and backcountry permits through their own AI assistant, with secure local session handling and payment completed by the user in their own browser.

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.

A smart commute assistant that monitors travel routes via the Amap API and sends automated notifications to DingTalk. It enables users to schedule daily route checks and receive real-time traffic updates using a modular MCP-based architecture.

Provides access to 250,000+ Canadian government datasets and specialized querying of transportation infrastructure including bridges, airports, cycling networks, transit systems, railways, and tunnels across multiple provinces.

The world railway atlas as read-only MCP tools: search 744+ legendary train routes (high-speed, classic, night, scenic) and get per-route facts, rankings and journey times. Runs from the repo's open dataset (CC BY 4.0); a free hosted endpoint is also live at https://trainrouter.com/mcp.

Enables AI agents to search, browse, and book hotels from a database of 2 million properties worldwide. Provides comprehensive hotel search capabilities with location lookup, filtering by amenities, detailed property information, and integrated booking functionality.

Real-time pet travel data for AI assistants. Connect Claude, ChatGPT, or any MCP-compatible AI to Pawgo's database of airline pet policies and country import requirements.

MCP server that exposes BiziDashboard's historical and analytical data for the Zaragoza Bizi bike-share system as tools for LLM clients, enabling queries on rankings, occupancy patterns, mobility signals, alert history, and station rebalancing diagnostics.

Enables AI agents to manage cab bookings, estimate fares, and dispatch drivers with a 2-tier priority algorithm for hotel guests, providing 18 MCP tools for driver management, dispatch, and ride lifecycle.

An open-source MCP server that exposes the Amadeus Self-Service APIs as tools for flight status, delay prediction, flight search, passenger rights, and disruption handling.

Provides access to Nagoya bus system information and schedules. Enables users to query bus routes, stops, and real-time transit data for Nagoya's public transportation network.

Read-only MCP server for vessel identity lookup, AIS-style positions, tracks, port calls, carrier schedules, vessel schedules, and delay heuristics with source attribution and BYOK provider support.

Enables natural-language search, booking, and management of simulated flights using a local SQLite database through Claude Desktop.

mcp-server-public-transport is an open-source, locally hosted server providing an interface for accessing public transport data across Europe.

An MCP server that provides real-time information about the Zaragoza tram system, including arrival estimations and station details through the DNDzgz API.

Integrates the Machship freight management platform with MCP-compatible LLMs, enabling shipment creation, quotes, labels, and carrier management via natural language.