I'm doing some research and I would like to learn how CKAN manages data, in particular, I would like to learn its database scheme. Do you know where I can find it?

  • 4
    Probably, you will find the answer in the official github of CKAN. github.com/ckan/ckan
    – Tasos
    Commented Jun 2, 2014 at 12:15
  • The links in the answers are broken. And the question is about 4 years old. Is there any update to CKAN database scheme? Come on, some tables cannot be so hard to draw an entity-realtionship model of.
    – WeSee
    Commented Sep 27, 2019 at 14:11

1 Answer 1


CAVEAT: I am not an experienced user of the CKAN software.

From reviewing the online documentation, it appears that CKAN supports storing data in two methods: FileStore and DataStore. FileStore is storing and retrieving an entire datasets (e.g., CSV file, PDF document, etc). It does not involve a database.

The Datastore uses what they call an ad-hoc database for storing and querying individual elements of a structured dataset. In one mode, it appears to be fairly generic, creating a table and entries based on the column names in the structured data, and supporting an API query based on the column names.


I believe it has more advanced capabilities and relationships in the structured data is linked data or RDF and is constructed using a vocabulary supported by CKAN, which include the Dublin Core, DCAT, VoID and SCOVO.



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.