ckan_datastore_search_sql

MCP tool from Ckan MCP Server by ondata

SQL queries on DataStore

How to use it

ckan_datastore_search_sql is exposed by the Ckan MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the ckan_datastore_search_sql tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.

Install Ckan MCP Server

$claude mcp add -s user -t http ckan https://ckan-mcp-server.andy-pr.workers.dev/mcp

FULL CKAN MCP SERVER LISTING

Other tools in Ckan MCP Server (21)

> Requires a ChatGPT Plus, Team, or Enterprise plan.

ckan_analyze_datasets

Search datasets and inspect DataStore schemas of queryable resources

ckan_catalog_stats

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

ckan_datastore_search

Query tabular data

ckan_find_portals

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

ckan_find_relevant_datasets

Rank datasets by relevance score

ckan_get_mqa_quality

Get MQA quality score and metrics for dati.gov.it datasets (accessibility, reusability, interoperability, findability)

ckan_get_mqa_quality_details

Get detailed MQA quality reasons and failing flags for dati.gov.it datasets

ckan_group_list

List groups

ckan_group_search

Search groups by name

ckan_group_show

Show group details

ckan_organization_list

List all organizations

ckan_organization_search

Search organizations by name

ckan_organization_show

Details of an organization

ckan_package_search

Search datasets with Solr queries

ckan_package_show

Complete details of a dataset

ckan_status_show

Verify server status

List tags with counts

~/Library/Application Support/Claude/claudedesktopconfig.json

Execute SPARQL SELECT queries against any public SPARQL endpoint