# Opendatasoft

> Opendatasoft is a freemium MCP server for cloud and infrastructure. Search and query datasets on Opendatasoft open data portals via an MCP gateway. It can run locally on your machine or as a hosted remote server.

- **Kind:** MCP server
- **Pricing:** Freemium
- **Starting price:** $49 a month
- **Platforms:** API, CLI, Web
- **Website:** https://pipeworx.io/packs/opendatasoft
- **Repository:** https://github.com/pipeworx-io/mcp-opendatasoft
- **MCP Registry name:** io.github.pipeworx-io/opendatasoft
- **Categories:** [cloud and infrastructure](https://ai-powered.com/categories/cloud-and-infrastructure)
- **Listing updated:** 2026-11-18

## About

The README describes this as a generic client for the roughly 3000 public Opendatasoft portals, with public.opendatasoft.com as the default instance and other portals reachable by hostname. Each portal's dataset catalog can be searched by keyword, and individual datasets can be inspected for field definitions and record counts before querying.

Records can be pulled with keyword search and ODSQL-style WHERE, SELECT, GROUP BY and ORDER BY clauses, with pagination. A facet tool lists distinct values for a field, which helps when choosing filter values. The pages say the server is hosted by Pipeworx, an MCP gateway, and that it is an unofficial integration not affiliated with Opendatasoft.

The README says public data needs no key. Anonymous use is capped daily, and a free Pipeworx account raises the limit. Developers connecting from an MCP client or running the npm stdio bridge are the likely audience.

## Features

- **Dataset keyword search:** Finds datasets on a chosen Opendatasoft portal by keyword, with optional sorting and facet filters.
- **Structured record queries:** Returns rows using ODSQL-style filters, column selection, grouping, ordering and pagination.
- **Dataset schema lookup:** Shows field definitions, record count and description for a single dataset.
- **Facet value enumeration:** Lists distinct values and counts for a facet field to help build filters.
- **Portal catalog metadata:** Reports portal-wide details such as total dataset count, themes and languages.
- **Multi-portal targeting:** Accepts a hostname so the same tools can query different Opendatasoft portals.

## Good for

- Finding open government datasets on a city or national Opendatasoft portal
- Filtering and aggregating public records with SQL-style queries from an AI assistant
- Enumerating categories in a dataset before pulling matching rows
- Checking what themes and datasets a portal offers before building a data workflow

## Install

### Claude Code (Terminal)

```sh
claude mcp add --transport http opendatasoft https://gateway.pipeworx.io/opendatasoft/mcp
```

### Claude Desktop (Settings → Connectors → Add custom connector)

```sh
https://gateway.pipeworx.io/opendatasoft/mcp
```

### Cursor (~/.cursor/mcp.json)

```json
{
  "mcpServers": {
    "opendatasoft": {
      "url": "https://gateway.pipeworx.io/opendatasoft/mcp"
    }
  }
}
```

### VS Code (.vscode/mcp.json)

```json
{
  "servers": {
    "opendatasoft": {
      "type": "http",
      "url": "https://gateway.pipeworx.io/opendatasoft/mcp"
    }
  }
}
```

### Windsurf (~/.codeium/windsurf/mcp_config.json)

```json
{
  "mcpServers": {
    "opendatasoft": {
      "serverUrl": "https://gateway.pipeworx.io/opendatasoft/mcp"
    }
  }
}
```

### Other clients (your client's MCP settings (most use this shape))

```json
{
  "mcpServers": {
    "opendatasoft": {
      "type": "http",
      "url": "https://gateway.pipeworx.io/opendatasoft/mcp"
    }
  }
}
```

## Tools

- `datasets`: Search datasets on an Opendatasoft instance by keyword, with optional sort and facet filters.
- `dataset`: Fetch schema and metadata for a single dataset by dataset_id.
- `records`: Query dataset records with keyword search, ODSQL clauses, pagination and projection.
- `facets`: Retrieve distinct values and counts for a named facet field.
- `instance_info`: Fetch catalog-level metadata for a portal instance.

## FAQ

### Does it need an API key?

The README says public data is keyless. Anonymous calls are capped at 50 per day, and a free Pipeworx account raises the cap to 200 per day.

### Which portals can it query?

The README says it works with the roughly 3000 public Opendatasoft portals, defaulting to public.opendatasoft.com and accepting a hostname for others.

### Are extra tools listed on the endpoint?

The README says tools/list also returns shared Pipeworx meta-tools such as ask_pipeworx, so the count is larger than the five pack tools.

### Is it official?

The README states it is an independent, unofficial integration and is not affiliated with or endorsed by the upstream provider.

### Is Opendatasoft free?

Opendatasoft has a free plan, with paid plans for more usage or features. Paid plans start at $49 a month.

### How do I add Opendatasoft to Claude Code?

Run this command in your terminal: claude mcp add --transport http opendatasoft https://gateway.pipeworx.io/opendatasoft/mcp

### What are the best alternatives to Opendatasoft?

The closest alternatives to Opendatasoft are mcp, Vercel MCP, Nist Beacon, Webflow and OpenWrt MCP.

## Where this comes from

- Description: written from the project's README, the project's website and its MCP Registry entry.
- Install steps: from the official MCP Registry entry.

## Alternatives

- [mcp](https://ai-powered.com/mcp/mcp-mwfu4c84): mcp is an open-source MCP server for cloud and infrastructure.
- [Vercel MCP](https://ai-powered.com/mcp/vercel-mcp): Vercel MCP is an MCP server for cloud and infrastructure.
- [Nist Beacon](https://ai-powered.com/mcp/nist-beacon): Nist Beacon is a freemium MCP server for cloud and infrastructure.
- [Webflow](https://ai-powered.com/mcp/webflow): Webflow is a freemium MCP server for cloud and infrastructure.
- [OpenWrt MCP](https://ai-powered.com/mcp/openwrt-mcp): OpenWrt MCP is an open-source MCP server for cloud and infrastructure.
- [Ripe Stat](https://ai-powered.com/mcp/ripe-stat): Ripe Stat is a freemium MCP server for cloud and infrastructure.
- [gws-admin-mcp](https://ai-powered.com/mcp/gws-admin-mcp): gws-admin-mcp is a paid MCP server for cloud and infrastructure.
- [Gateway SSH](https://ai-powered.com/mcp/gateway-ssh): Gateway SSH is a freemium MCP server for cloud and infrastructure.

---
Source: https://ai-powered.com/mcp/opendatasoft
