Ckan MCP Server
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 mcp add ckan-mcp-server -- npx @aborruso/ckan-mcp-server@latest{
"mcpServers": {
"ckan-mcp-server": {
"command": "npx",
"args": [
"@aborruso/ckan-mcp-server@latest"
]
}
}
}{
"mcpServers": {
"ckan-mcp-server": {
"command": "npx",
"args": [
"@aborruso/ckan-mcp-server@latest"
]
}
}
}code --add-mcp '{"name":"ckan-mcp-server","command":"npx","args":["@aborruso/ckan-mcp-server@latest"]}'What Ckan MCP Server can touch
- Our checks did not find this. The tool may still do it.Run shell commandsNot seen in this scan
- Our checks did not find this. The tool may still do it.Run dynamic codeNot seen in this scan
- Our checks did not find this. The tool may still do it.Read or write filesNot seen in this scan
- Seen in this scan, either in the code or while it ran.Read environment and secretsFound in the code by our scan
- Our checks did not find this. The tool may still do it.Control a web browserNot seen in this scan
- The server lists a tool that does this.Connect to databasesListed as a tool: ckan_datastore_search_sql
- Our checks did not find this. The tool may still do it.Read or send messagesNot seen in this scan
- Our checks did not find this. The tool may still do it.Touch money or tradingNot seen in this scan
- Our checks did not find this. The tool may still do it.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
- Give it a read-only database user unless it must write.
- Use a role with only the permissions it needs, never an admin key.
- Pin the version you reviewed instead of always installing the latest release.
- 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_searchSearch 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_datasetsFind 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_showGet 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_resourcesList 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_listList 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_showGet 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_searchSearch 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_searchQuery 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_sqlRun 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_showCheck 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_listList 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_listList 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_showGet 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_searchSearch 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_qualityGet 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_detailsGet 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_datasetsSearch 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_statsGet 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_queryExecute 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_portalsSearch 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
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.
| Name | Stars | Licence | Last updated | Scan |
|---|---|---|---|---|
| Ckan MCP Server (this page) ondata | 59 | MIT | Nov 1, 2026 | Scanned, no flagged issues |
| Codebase Memory MCP DeusData | 48k | MIT | Nov 1, 2026 | Scanned, see report |
| Xerj xerj-org | 19k | Apache-2.0 | Nov 1, 2026 | Scanned, no flagged issues |
| MCP Toolbox googleapis | 17k | Apache-2.0 | Nov 1, 2026 | Scanned, no flagged issues |
| Nightingale ccfos | 13k | Apache-2.0 | Oct 30, 2026 | Scanned, no flagged issues |
| Dbhub bytebase | 3.8k | MIT | Oct 26, 2026 | Scanned, no flagged issues |