"Using PostgreSQL to Execute Queries" matching MCP servers:

Provides OpenStreetMap integration for MCP, allowing users to query and visualize map data with tools for adding markers, polygons, and controlling the map view.

Enables spatial analysis of large remote GeoParquet files directly from object storage without downloading or importing data, using DuckDB's predicate and projection pushdown to answer queries efficiently.

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.

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 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 assistants to scrape Google Maps business data (names, addresses, phones, emails, websites, ratings, etc.) through natural language queries, with tools for synchronous and asynchronous scraping and credit checking.

Enables querying GeoIP2, GeoLite2, and custom MMDB databases through the Model Context Protocol for IP lookups, filtered network queries, resumable pages, and MaxMind database downloads.

Connects MCP-compatible AI clients to BMLT root servers, enabling natural language queries for NA meeting data including search by location, day, format, and more.

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.

Enables AI assistants to find and get status of NYC public restrooms using live NYC Open Data, including hours, accessibility, and inspection reports.

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

An MCP server that finds great espresso cafes using a curated database of specialty coffee shops and a transparent scoring algorithm, with a strong bias against flavored syrups and mass-market chains.

Enables natural language search and retrieval of data from Japan's Ministry of Land, Infrastructure, Transport and Tourism (MLIT) Data Platform, including location-based queries, attribute filtering, and data visualization capabilities.

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

MCP server that provides AI assistants access to Oklahoma Corporation Commission public GIS datasets, enabling dataset search, layer metadata retrieval, and attribute/spatial queries on ArcGIS Hub data.

MCP server to look up long-term flood risk for England postcodes using official Environment Agency data, and validate UK postcodes.

Global postal code lookups, validation, and city search for 240+ countries with timezone, admin region, and elevation metadata. Sub-10ms responses at $0.000028/query with 1,000 free queries on signup.

MCP server for spatial queries via the Terranode Geospatial API, enabling AI agents to perform point-in-polygon lookups, nearest feature search, distance calculations, and spatial joins.

Look up IP address geolocation, network information, detect proxies and VPNs, and find abuse contact details using IPLocate.io

An MCP server that connects your PinMeTo locations to AI assistants, enabling natural language queries for insights from Google, Facebook, and Apple Maps.