CKAN MCP Server

What it does

CKAN MCP Server gives your AI assistant direct, interactive access to any CKAN open data portal — the platform powering Italy's dati.gov.it, the US data.gov, Canada's open.canada.ca, and ~950 portals worldwide. Instead of navigating complex APIs manually, you ask in plain language and the server translates your intent into Solr queries, DataStore SQL, SPARQL, and CKAN API calls, returning structured results you can explore interactively.

Key features

• Natural language dataset search — full Solr query support including fuzzy matching, proximity search, date math, and boolean operators across any CKAN portal
• DataStore SQL queries — run SELECT statements directly against tabular datasets that have DataStore enabled
• SPARQL endpoint support — execute SPARQL queries against any public SPARQL endpoint
• Portal discovery — find CKAN portals worldwide by country, language, or topic via the Datashades.info live registry (~950 portals)
• MQA quality metrics — retrieve Metadata Quality Assurance scores and detailed diagnostics for dati.gov.it datasets
• Hosted endpoint — zero-install option at https://ckan-mcp-server.andy-pr.workers.dev/mcp with 100k requests/day shared quota

Installation

Claude Desktop (hosted endpoint — no install):

{
  "mcpServers": {
    "ckan": {
      "url": "https://ckan-mcp-server.andy-pr.workers.dev/mcp"
    }
  }
}

Claude Desktop (local):

{
  "mcpServers": {
    "ckan": {
      "command": "npx",
      "args": ["@aborruso/ckan-mcp-server@latest"]
    }
  }
}

VS Code Copilot (hosted):

{
  "mcpServers": {
    "ckan": {
      "url": "https://ckan-mcp-server.andy-pr.workers.dev/mcp",
      "type": "http"
    }
  }
}

ChatGPT: Add via Settings → Apps → Advanced settings → Create app, using URL https://ckan-mcp-server.andy-pr.workers.dev/mcp.

Supported hosts

Claude Desktop, VS Code Copilot, ChatGPT (Plus/Team/Enterprise), Gemini CLI, Codex CLI. Also works with any MCP-compatible client via the hosted HTTP endpoint.