ckan-mcp-server

Overview

This MCP server provides direct access to CKAN-based open data portals through the Model Context Protocol. It offers tools for searching datasets, exploring organizations and groups, querying tabular data via DataStore SQL, and analyzing metadata following DCAT standards. The server supports both local installation and a hosted endpoint, making it accessible for various use cases from data journalism to research.

Try asking AI

After installing, here are 5 things you can ask your AI assistant:

• ckan_package_search

  Search datasets with Solr queries

  Try:Search for datasets about air quality in MilanTry:Find hotel or accommodation datasets
• ckan_find_relevant_datasets

  Rank datasets by relevance score

  Try:Find most relevant datasets about urban mobilityTry:Show me the best datasets about COVID vaccinations
• ckan_package_show

  Complete details of a dataset

  Try:Show me all details about the dataset 'vaccini-covid'Try:Get complete metadata for dataset ID abc-123
• ckan_tag_list

  List tags with counts

  Try:Show me all available tagsTry:List the most common tags
• ckan_organization_list

  List all organizations

  Try:Show me all organizationsTry:List all data publishers
• ckan_organization_show

  Details of an organization

  Try:Show me details about Tuscany RegionTry:Get information about organization 'regione-toscana'
• ckan_datastore_search

  Query tabular data

  Try:Query the vaccination dataset for 2023 dataTry:Get population statistics from the census data
• ckan_datastore_search_sql

  SQL queries on DataStore

  Try:Run SQL query to find all records with temperature > 30Try:Select the first 100 rows from the air quality table
• ckan_get_mqa_quality

  Get MQA quality score for dati.gov.it datasets

  Try:Show quality score for the air quality datasetTry:Get MQA metrics for dataset 'vaccini-covid'
• ckan_find_portals

  Discover CKAN portals worldwide

  Try:Find data portals in ItalyTry:Show me portals about environmental data
• ckan_catalog_stats

  Statistical overview of a portal

  Try:Show statistics for dati.gov.itTry:Get breakdown by format and organization
• sparql_query

  Execute SPARQL SELECT queries against public endpoints

  Try:Query DBpedia for all Italian citiesTry:Find all museums in Rome with SPARQL

Comparable tools

Installation

npm install -g @aborruso/ckan-mcp-server

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

FAQ

What is CKAN?

CKAN is the open-source platform behind most public open data portals worldwide, including Italy's dati.gov.it, the US data.gov, and Canada's open.canada.ca.

Are there usage limits?

The hosted endpoint has a shared quota of 100k requests/day. Local installation has no limits.

Compare ckan-mcp-server with