skills.rest
ondata
ondataOFFICIAL
Explore all skills by this author →
Website𝕏@ondataitGitHub

ckan-mcp

Explore CKAN open data portals and data.europa.eu through conversational queries.

57|16|Updated Jan 7, 2026
Search Tags:#natural-language#sparql#data-portal#open-data#government-data#ckan#dataset-search
One-click install
npx skills add https://github.com/ondata/ckan-mcp-server --skill ckan-mcp
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ckan-mcp
Source: https://github.com/ondata/ckan-mcp-server/tree/main/skills/ckan-mcp
Command: npx skills add https://github.com/ondata/ckan-mcp-server --skill ckan-mcp

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Navigating CKAN open data portals requires knowing their structure, APIs, and search syntax. This Skill removes that barrier by letting users ask for data in natural language and automatically searching the right portal, handling country detection, portal verification, and fallback strategies.

Core Features & Use Cases

  • Multi-Portal Discovery: Automatically finds the correct CKAN portal for a country or accepts a specific portal URL, with fallback to data.europa.eu for European data.
  • Intelligent Search: Handles multilingual queries, Solr syntax, relevance ranking, and DataStore tabular queries across dozens of portals including dati.gov.it, data.gov, data.gov.uk, and open.canada.ca.
  • Dataset Analysis: Compares datasets, extracts metadata quality scores (MQA), discovers High Value Datasets, and maps fields to standard ontologies like DCAT and SSN.

Quick Start

Use the ckan-mcp skill to find air quality datasets published by the Italian Ministry of Environment.

Frequently Asked Questions about ckan-mcp

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I search CKAN open data portals using natural language instead of Solr syntax?▼

The Skill resolves the correct CKAN portal by detecting the target country from your conversational query, verifying the portal endpoint, and falling back to data.europa.eu for European data when needed.

Can I query tabular DataStore resources on government data portals conversationally?▼

The Skill compares dataset relevance, computes metadata quality scores (MQA), identifies High Value Datasets, and aligns extracted fields with W3C ontologies like DCAT and SSN for semantic interoperability across catalog entries.

How do I find High Value Datasets on data.europa.eu without writing SPARQL queries?▼

The Skill queries CKAN portals using natural language without requiring manual SPARQL or Solr syntax knowledge. It automatically manages portal verification, full-text search formulation, and JSON parsing to deliver relevant dataset results conversationally.

Does this approach work for discovering datasets across multiple government data portals like open.canada.ca and data.gov.uk?▼

The Skill maps dataset fields to standard W3C ontologies like DCAT and SSN by analyzing the extracted metadata and aligning the schema properties conversationally, ensuring semantic consistency without manual ontology engineering.

What are the limitations of using natural language to search open data catalogs hosted on CKAN?▼

The Skill requires MCP tool integration to successfully perform portal verification, Solr full-text search, SPARQL endpoint queries, and direct REST API access with JSON parsing to function correctly across CKAN portals.

Related Skills

Explore More Data & Analytics Skills→
thecolab-aithecolab-ai
24

data-govt-nz

Retrieve New Zealand open-data catalogue metadata via the CKAN API.

Official
Basic
ZurybrZurybr

sparql-university

Writes and verifies SPARQL queries for university RDF datasets.

Community
Intermediate
rnavarychrnavarych
14

role-database:search-engines

Guide Solr, Typesense, Meilisearch, Algolia, Zinc, Manticore Search, and Sonic implementations.

Community
Advanced
danbridanbri
1

scotgov-stats

Queries Scottish government statistics SPARQL endpoint for RDF DataCube information.

Community
Intermediate