"How to query data in Snowflake" matching MCP servers:

Enables retrieval and filtering of Indiana Bureau of Motor Vehicles (BMV) locations, including branches, self-service kiosks, and motorcycle training sites.

Enables querying Tennessee DMV driver service center locations with per-location service capabilities and impaired driving crash data for 2022.

Provides tools to get current time by coordinates, convert time zones, and parse custom dates to ISO format.

Access and query Denver open geospatial data via the ArcGIS REST API, enabling natural language questions about Denver's datasets.

Provides access to French public data through data.gouv.fr, IGN cartographic services (maps, tiles, geographic data), address geocoding, and administrative divisions with demographic information.

Official MCP server for ipgeolocation.io APIs. IP geolocation, VPN/proxy detection, timezone, astronomy, user-agent parsing, ASN, company, and IP abuse contact tools for AI assistants.

Provides authoritative astronomical data including moon phases, solar eclipses, and sun/moon rise and set times using the US Navy API or offline Skyfield calculations. It enables users to query Earth's seasons and celestial events for any location and date.

Provides real-time fuel prices at gas stations in Spain using the government's public API. Enables users to find the cheapest fuel in a municipality or list stations sorted by price.

Enables agents to turn structured data into production-ready static maps, returning rendered PNG and SVG URLs along with an editable map link.

MCP server for sthan.io - US address verification, parsing, autocomplete, forward/reverse geocoding, and IP geolocation. 8 tools, TypeScript, stdio transport. Free tier, no credit card required.

IP Geolocation MCP server using IP2Location.io API to ease the query of geolocation information.

MCP server for Chelaile realtime public transit data in China, including bus and metro arrivals, vehicle positions, nearby stops, timetables, and route planning. It runs locally over stdio with no login or account configuration required.

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.

An MCP server that lets LLMs query USGS NHDPlus HR hydrography data—streams, rivers, lakes, stream gages, and watershed boundaries—via point or GeoJSON geometry intersection queries.

MCP server for W-2 event staffing across 300+ US and Canadian markets. Five read-only lookups (city coverage, staffing roles, all-inclusive W-2 rate ranges, lead-time guidance, and state-by-state compliance) plus an opt-in request_quote tool that submits a structured staffing request to TempGuru for a human-reviewed quote. No authentication required; connect with the URL alone.

Enables to look up Japanese postal codes, convert zipcodes to addresses, search addresses by query, and list cities in a prefecture using the jpzip dataset.

Enables AI agents and hackathon teams to query Glendale, California hazard zones and city GIS data by address or coordinates, including nearby resources and dataset metadata for emergency-preparedness applications.

MCP server for live Turkey data — gold & silver prices, official TCMB exchange rates, fuel pump prices, prayer times and the Kandilli earthquake feed.

Read-only access to a self-hosted GeoLens geospatial catalog: dataset search, schemas, GeoJSON features, saved maps, and sandboxed read-only SQL over PostGIS.

Provides AI assistants with live information about who is currently in space and the location of the ISS, using the free Open Notify API.