Ckan MCP Server

by ondata• 59•• Scanned•Claim this listing•Request removal
Database Managementai toolsapi clientcivic techckanckan api

MCP server for querying CKAN open data portals (package search, DataStore SQL, organizations, groups, tags)

Ckan MCP Server is an open-source mcp server by ondata, written mainly in TypeScript, with 59 GitHub stars and the MIT license. Its code was last updated Nov 1, 2026. The latest npm release is @aborruso/ckan-mcp-server 0.4.143, published Nov 15, 2026, with 2,293 downloads last week.

Scan summary: scanned Nov 5, 2026 at commit bc06349. Seen able to read environment and secrets, connect to databases. 6 published advisories for its package. Scan policy

How to install Ckan MCP Server

Built from the start command in the project's README: npx @aborruso/ckan-mcp-server@latest. Check the README for required keys or settings.

Claude Code · Terminal
claude mcp add ckan-mcp-server -- npx @aborruso/ckan-mcp-server@latest
Claude Desktop · claude_desktop_config.json
{
  "mcpServers": {
    "ckan-mcp-server": {
      "command": "npx",
      "args": [
        "@aborruso/ckan-mcp-server@latest"
      ]
    }
  }
}
Cursor · .cursor/mcp.json
{
  "mcpServers": {
    "ckan-mcp-server": {
      "command": "npx",
      "args": [
        "@aborruso/ckan-mcp-server@latest"
      ]
    }
  }
}
VS Code · Terminal
code --add-mcp '{"name":"ckan-mcp-server","command":"npx","args":["@aborruso/ckan-mcp-server@latest"]}'

What Ckan MCP Server can touch

  • Run shell commandsNot seen in this scan
  • Run dynamic codeNot seen in this scan
  • Read or write filesNot seen in this scan
  • Read environment and secretsFound in the code by our scan
  • Control a web browserNot seen in this scan
  • Connect to databasesListed as a tool: ckan_datastore_search_sql
  • Read or send messagesNot seen in this scan
  • Touch money or tradingNot seen in this scan
  • Connect to the internetNo connections seen while running

"Not seen" means our checks did not find it, and the tool may still do it. Covers commit bc06349, Nov 5, 2026. See the scan policy.

Before you install Ckan MCP Server

AgenticMart scanned Ckan MCP Server on Nov 5, 2026 with automated checks for hidden code, known-malicious packages, leaked secrets and vulnerable dependencies. The result covers one commit under our scan policy, so review what access you give it and check any advisories shown here.

What it can access

  • An MCP server is a program your AI app starts and talks to. A local one runs with your user's permissions: it can see the files, environment variables and network your account can.
  • Based on its description and topics, it likely needs to connect to a database.
  • Based on its description and topics, it likely needs to act on cloud infrastructure.

Before you install

  1. Give it a read-only database user unless it must write.
  2. Use a role with only the permissions it needs, never an admin key.
  3. Pin the version you reviewed instead of always installing the latest release.
  4. Read the tool list or scripts before the first run, and keep approval prompts on for actions that write, send or delete.
  • Maintained by ondata on GitHub, 59 stars and 15 forks. Popularity is not proof of safety.
  • Last code change: Nov 1, 2026.
  • Open-source license: MIT.

Published advisories for @aborruso/ckan-mcp-server

From the OSV database, for this npm package. Check that your installed version is past any fix.

  • CVE-2026-33060SSRF in @aborruso/ckan-mcp-server via base_url allows access to internal networksFixed in 0.4.85.
  • CVE-2026-73844CKAN MCP Server: Information disclosure via verbose error reflectionFixed in 0.4.112.
  • CVE-2026-73846CKAN MCP Server: Cache-key canonicalization collision enables cache confusion / poisoningFixed in 0.4.112.
  • CVE-2026-61612@aborruso/ckan-mcp-server has SSRF via DNS-name → internal IP — incomplete fix of CVE-2026-53509Fixed in 0.4.108.
  • CVE-2026-73845CKAN MCP Server: MQA server allowlist bypass via unanchored regex (`isValidMqaServer`)Fixed in 0.4.112.
  • CVE-2026-53509@aborruso/ckan-mcp-server: SSRF via base_url allows access to internal networks (Potential fix bypass of CVE-2026-33060)Fixed in 0.4.106.

Tools Ckan MCP Server exposes (20)

Listed by the server itself during our scan of commit bc06349.

  • ckan_package_search

    Search for datasets (packages) on a CKAN server using Solr query syntax. Supports full Solr search capabilities including filters, facets, and sorting. Use this to discover datasets matching specific criteria. Note on parser behavior: Some CKAN portals use a restrictive default query parser that c

  • ckan_find_relevant_datasets

    Find and rank datasets by relevance to a query using weighted fields. Use this instead of ckan_package_search when you want relevance-ranked results with explicit scoring across title, notes, tags, and organization fields. Use ckan_package_search instead when you need Solr filter syntax, facets, or

  • ckan_package_show

    Get complete metadata for a specific dataset (package). Returns full details including resources, organization, tags, and all metadata fields. Notes: - metadata_modified is a CKAN record timestamp (publish time on source portals, harvest time on aggregators), not the content date. - issued

  • ckan_list_resources

    List all resources in a dataset with a compact summary. Returns a focused table of resources showing format, size, DataStore availability, and download URL. Use this to quickly assess what files a dataset contains before deciding how to access the data. Args: - server_url (string): Base URL of C

  • ckan_organization_list

    List all organizations on a CKAN server. Organizations are entities that publish and manage datasets. Args: - server_url (string): Base URL of CKAN server - all_fields (boolean): Return full objects vs just names (default: false) - sort (string): Sort field (default: "name asc") - limit (n

  • ckan_organization_show

    Get details of a specific organization. Args: - server_url (string): Base URL of CKAN server - id (string): Organization ID or name - include_datasets (boolean): Include list of datasets (default: true) - include_users (boolean): Include list of users (default: false) - response_format ('

  • ckan_organization_search

    Search for organizations by name pattern. This tool provides a simpler interface than package_search for finding organizations. Wildcards are automatically added around the search pattern. Args: - server_url (string): Base URL of CKAN server - pattern (string): Search pattern (e.g., "toscana",

  • ckan_datastore_search

    Query data from a CKAN DataStore resource. The DataStore allows SQL-like queries on tabular data. Not all resources have DataStore enabled. The response always includes a Fields section listing all available column names and types. Use limit=0 to discover column names without fetching data — do th

  • ckan_datastore_search_sql

    Run SQL queries on a CKAN DataStore resource. This endpoint is only available on CKAN portals with DataStore enabled and SQL access exposed. Args: - server_url (string): Base URL of CKAN server - sql (string): SQL query (e.g., SELECT * FROM "resource_id" LIMIT 10) - response_format ('markdow

  • ckan_status_show

    Check if a CKAN server is available and get version information. Useful to verify server accessibility before making other requests. Also shows the count of High-Value Datasets (HVD) when the portal supports it. Args: - server_url (string): Base URL of CKAN server Returns: Server status, vers

  • ckan_tag_list

    List tags from a CKAN server using faceting. This returns tag names with counts, optionally filtered by dataset query or tag substring. Args: - server_url (string): Base URL of CKAN server - q (string): Dataset search query (default: "*:*") - fq (string): Filter query (optional) - tag_quer

  • ckan_group_list

    List all groups on a CKAN server. Groups are thematic collections of datasets. Args: - server_url (string): Base URL of CKAN server - all_fields (boolean): Return full objects vs just names (default: false) - sort (string): Sort field (default: "name asc") - limit (number): Maximum results

  • ckan_group_show

    Get details of a specific group. Args: - server_url (string): Base URL of CKAN server - id (string): Group ID or name - include_datasets (boolean): Include list of datasets (default: true) - response_format ('markdown' | 'json'): Output format Returns: Group details with optional dataset

  • ckan_group_search

    Search for groups by name pattern. This tool provides a simpler interface than package_search for finding groups. Wildcards are automatically added around the search pattern. Args: - server_url (string): Base URL of CKAN server - pattern (string): Search pattern (e.g., "energia", "salute") -

  • ckan_get_mqa_quality

    Get MQA (Metadata Quality Assessment) quality score for a dataset on dati.gov.it from data.europa.eu. Returns the final score on the 0-7.5 scale of MQA methodology v2 with its band (Sufficient/Good/Excellent), dataset, distribution and data service scores, and the failing metrics with the largest ga

  • ckan_get_mqa_quality_details

    Get detailed MQA (Metadata Quality Assessment) quality reasons for a dataset on dati.gov.it. Lists every failing metric grouped by FAIR dimension, with DCAT-AP property, weight, how many distributions fail it and its gain on the final score, plus the HTTP status of failing URL tests (e.g. 1100 timeo

  • ckan_analyze_datasets

    Search datasets and inspect the DataStore schema of queryable resources. For each dataset found, lists all resources. For DataStore-enabled resources, fetches the full field schema (name, type, and label/notes when available) plus total record count — all in one call. Use this before ckan_datastor

  • ckan_catalog_stats

    Get a statistical overview of a CKAN portal: total dataset count and breakdown by category, format, and organization. Single CKAN call (package_search with rows=0 and facets). No query needed. Args: - server_url (string): Base URL of the CKAN server - facet_limit (number): Max entries per face

  • sparql_query

    Execute a SPARQL SELECT query against any public HTTPS SPARQL endpoint. Useful for querying open data portals and knowledge graphs that expose SPARQL endpoints, including: - data.europa.eu (European open data portal) - publications.europa.eu (EU Publications Office) - DBpedia, Wikidata - Any DCAT-A

  • ckan_find_portals

    Search the live datashades.info registry of ~950 CKAN portals worldwide. Use this tool to discover which CKAN portals exist for a country, language, or topic before querying them with other CKAN tools. **IMPORTANT — country parameter**: always pass country name in English. If the user writes in an

Ckan MCP Server is an open-source mcp server by ondata, written mainly in TypeScript. MCP server for querying CKAN open data portals (package search, DataStore SQL, organizations, groups, tags)

At a glance

Stars
59
Forks
15
Language
TypeScript
License
MIT
Created
Jan 2026
Last update
Nov 1, 2026
Type
MCP Server
Price
Free

Topics

ai-toolsapi-clientcivic-techckanckan-apiclaudecloudflare-workersdata-discoverydata-portaldatastoregovernment-datamcpmodel-context-protocolnodejsopen-datapublic-datasolrtypescript

Questions about Ckan MCP Server

What is Ckan MCP Server?

MCP server for querying CKAN open data portals (package search, DataStore SQL, organizations, groups, tags)

Who maintains Ckan MCP Server?

Ckan MCP Server is maintained by ondata on GitHub (ondata/ckan-mcp-server). AgenticMart lists it from public repository data.

Is Ckan MCP Server safe to use?

AgenticMart scanned Ckan MCP Server on Nov 5, 2026 with automated checks for hidden code, known-malicious packages, leaked secrets and vulnerable dependencies. The result covers one commit under our scan policy, so review what access you give it and check any advisories shown here.

What license does Ckan MCP Server use?

It is published under the MIT license.

Ckan MCP Server alternatives

View more →

Similar mcp servers in Database Management, ranked by GitHub stars. Compare licence, recent activity and scan status before you choose.

NameStarsLicenceLast updatedScan
Ckan MCP Server (this page)
ondata
59MITNov 1, 2026Scanned, no flagged issues
Codebase Memory MCP
DeusData
48kMITNov 1, 2026Scanned, see report
Xerj
xerj-org
19kApache-2.0Nov 1, 2026Scanned, no flagged issues
MCP Toolbox
googleapis
17kApache-2.0Nov 1, 2026Scanned, no flagged issues
Nightingale
ccfos
13kApache-2.0Oct 30, 2026Scanned, no flagged issues
Dbhub
bytebase
3.8kMITOct 26, 2026Scanned, no flagged issues