ondata avatar

Ckan Mcp Server

ondata/ckan-mcp-server

Connects Claude and other MCP clients directly to CKAN open data portals through their public APIs. You get tools to search datasets, browse organizations, query tabular data, and pull metadata from portals like dati.gov.it, data.gov, or open.canada.ca without writing API calls yourself. Runs locally via npm or through a hosted endpoint with a 100k request daily quota. Built on DCAT metadata standards, so it works consistently across different CKAN instances. Useful when you're digging through government data catalogs, building data pipelines, or just need to verify what datasets an administration has published without clicking through portal UIs.

GitHub stars
61
tools
19
transport
STDIO
env vars
2
last updated
Nov 12, 2026

Tools

19 tools

Public tool metadata for what this MCP can expose to an agent.

ckan_package_searchSearch datasets with Solr queries

Search datasets with Solr queries

No parameter schema in public metadata yet.

ckan_find_relevant_datasetsRank datasets by relevance score

Rank datasets by relevance score

No parameter schema in public metadata yet.

ckan_package_showComplete details of a dataset

Complete details of a dataset

No parameter schema in public metadata yet.

ckan_tag_listList tags with counts

List tags with counts

No parameter schema in public metadata yet.

ckan_organization_listList all organizations

List all organizations

No parameter schema in public metadata yet.

ckan_organization_showDetails of an organization

Details of an organization

No parameter schema in public metadata yet.

ckan_organization_searchSearch organizations by name

Search organizations by name

No parameter schema in public metadata yet.

ckan_group_listList groups

List groups

No parameter schema in public metadata yet.

ckan_group_showShow group details

Show group details

No parameter schema in public metadata yet.

ckan_group_searchSearch groups by name

Search groups by name

No parameter schema in public metadata yet.

ckan_datastore_searchQuery tabular data

Query tabular data

No parameter schema in public metadata yet.

ckan_datastore_search_sqlSQL queries on DataStore

SQL queries on DataStore

No parameter schema in public metadata yet.

ckan_get_mqa_qualityGet the MQA quality score (methodology v2, 0-7.5 scale with band) for dati.gov.it datasets, with the failing metrics that would raise it most

Get the MQA quality score (methodology v2, 0-7.5 scale with band) for dati.gov.it datasets, with the failing metrics that would raise it most

No parameter schema in public metadata yet.

ckan_get_mqa_quality_detailsList every failing MQA metric for dati.gov.it datasets, grouped by FAIR dimension, with DCAT-AP property, weight and gain

List every failing MQA metric for dati.gov.it datasets, grouped by FAIR dimension, with DCAT-AP property, weight and gain

No parameter schema in public metadata yet.

ckan_find_portalsDiscover CKAN portals worldwide by country, language, or topic (uses datashades.info live registry of ~950 portals)

Discover CKAN portals worldwide by country, language, or topic (uses datashades.info live registry of ~950 portals)

No parameter schema in public metadata yet.

ckan_analyze_datasetsSearch datasets and inspect DataStore schemas of queryable resources

Search datasets and inspect DataStore schemas of queryable resources

No parameter schema in public metadata yet.

ckan_catalog_statsStatistical overview of a portal (totals, breakdown by category, format, organization)

Statistical overview of a portal (totals, breakdown by category, format, organization)

No parameter schema in public metadata yet.

sparql_queryExecute SPARQL SELECT queries against any public SPARQL endpoint

Execute SPARQL SELECT queries against any public SPARQL endpoint

No parameter schema in public metadata yet.

ckan_status_showVerify server status

Verify server status

No parameter schema in public metadata yet.

Sponsors

Configuration

CKAN_ALLOWED_DOMAINS

Comma-separated CKAN hostnames to allow. Empty = any portal.

CKAN_PRIVATE_HOSTS

Comma-separated host names that may be private (loopback, RFC 1918, IPv6 unique-local), e.g. a CKAN on localhost or an intranet. Empty = none.

Readme

npm version GitHub Ask DeepWiki License: MIT Newsletter Greptile: The War on Bugs

CKAN MCP Server

Turn any (CKAN) open data portal into a conversation.

Give your AI assistant direct access to any CKAN open data portal — search datasets, explore organizations, query tabular data, and read metadata, all through natural language.


View the full README on GitHub

Details

Repository
github.com/ondata/ckan-mcp-server
Category
Data & Analytics
Package
@aborruso/ckan-mcp-server
Transport
STDIO
Registry
MCP registry, active

Related Data & Analytics MCP servers

View all
1dweekly avatarQuicken Mac Mcpdweekly/quicken-mac-mcpRead-only access to Quicken For Mac financial data: transactions, spending, and portfolios.55stars
2affitor avatarOpenaffiliate Mcpaffitor/open-affiliateSearch and discover affiliate programs with agent-ready data and commission details.55stars
3isdaniel avatarWeather MCP Serverisdaniel/mcp_weather_serverproviding weather information, air quality data, and timezone utilities using the Open-Meteo API.50stars
4buildkite avatarBuildkite Mcp Serverbuildkite/buildkite-mcp-serverMCP server exposing Buildkite API data (pipelines, builds, jobs, tests) to AI tooling and editors.49stars
5trendsmcp-ai avatarTrends MCPtrendsmcp-ai/trends-mcpTrend data from Google Trends, YouTube, TikTok, Reddit, Amazon, Wikipedia, npm, Steam and more47stars
6microsoft avatarMicrosoft MCP Server for Enterprisemicrosoft/enterprisemcpOfficial Microsoft MCP Server to query Microsoft Entra data using natural language41stars