"How to add data to Google Sheets" matching MCP servers:

Provides access to Seoul public data including subway passenger statistics and cultural event information through a Model Context Protocol server.

Enables AI agents to search, retrieve metadata, and query tabular resources from Latvia's Open Data portal (data.gov.lv) via CKAN.

Enables searching and querying Winnipeg Open Data datasets through natural language or SoQL, with tools for datasets, metadata, and row-level data.

Enables querying Washington DC open data from opendata.dc.gov and ArcGIS REST API through MCP.

Enables querying Denmark's official open energy data from Energinet through MCP tools.

Enables searching and querying Île-de-France open data datasets (transport, environment, economy, etc.) via natural language or direct tool calls.

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

Enables AI agents to search, query, and explore datasets from the Centre-Val de Loire Open Data portal, covering regional services, transport, education, and environment.

Access Colorado government open data via Socrata SoQL API. Enables searching datasets, running queries, and retrieving metadata without an API key.

Provides access to Detroit open data via ArcGIS REST API, enabling querying and analysis of municipal datasets through natural language or direct tool calls.

Enables searching, querying, and retrieving metadata for datasets from New Caledonia Open Data (data.gouv.nc) using ODSQL.

Enables searching and querying Pennsylvania Open Data datasets via the Socrata API, including dataset search, SoQL queries, and metadata retrieval.

Enables querying City of Boston open data through the CKAN API, providing access to datasets from data.boston.gov via natural language.

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

Enables searching and querying New Jersey Open Data (data.nj.gov) via Socrata, including dataset discovery, SoQL queries, and metadata retrieval.

Enables searching and querying Orlando Open Data datasets via Socrata SoQL, providing access to metadata and data rows through natural language or direct tool calls.

Enables querying and searching Connecticut Open Data via Socrata SoQL API, allowing AI agents to access state agency, public health, education, and transportation datasets using natural language or structured queries.

Query and explore Delaware Open Data datasets via Socrata API, including search, filtering, and metadata retrieval.

MCP server providing access to Montgomery County, MD open data through the Socrata SODA API, enabling querying and analysis of public datasets via natural language.

Enables searching and querying Virginia Open Data (datahub.va.gov) via the Socrata API, providing tools to search datasets, run SoQL queries, and retrieve metadata.

Enables querying Maryland government open data (state, health, transportation, budget, environment) via the Socrata SoQL API, with tools to search datasets, run queries, and retrieve metadata.

Enables searching, querying, and retrieving metadata from Vermont Open Data (data.vermont.gov) datasets using Socrata SoQL, all via natural language.

MCP server for accessing data.ny.gov datasets via the Socrata Open Data API, enabling search, query, metadata retrieval, and column value exploration.

Enables AI agents to search and query the Michigan Open Data catalog, running Socrata SoQL queries against datasets by resource ID, and retrieving dataset metadata.

Enables AI agents to search and query Nantes Métropole open data datasets (mobility, urban services, environment, geography) using natural language and SQL-like filters.

MCP server for querying Santa Clara County open data via Socrata APIs, enabling dataset search, SoQL queries, and metadata retrieval.

Enables AI agents to search, query, and retrieve metadata from the Cook County Open Data catalog using Socrata SoQL queries.

Enables AI assistants to look up US census tract, block group, block, county FIPS, and legislative districts from a street address or latitude/longitude via the Census Geocoder, and to decode census GEOIDs offline.

Enables searching, querying, and retrieving metadata from Sonoma County Open Data datasets via Socrata SoQL or natural language.

Enables searching Texas state cooperative-contract awards and purchases and aggregating vendor sales data from official DIR data, with optional plain-English querying via ask_pipeworx.