Skip to content

DB

DB Category give you an ability to retrieve data from DB and update rows in it.

The Query and Update tools are based on predefined list of CKAN Models to select from.

There is a functionality that allows to extend the Models list and add your own Models to the List. You can find more details here.

Also you can hide the actual values for specific fields that shown in the results, to make sure that they are not exposed. This can be done by adding ckan.selftools.model_fields_blacklist, for more details look here.

Query

Provides an ability to search in DB using registered Models in CKAN.

DB Query

Enhanced Query Capabilities

The Query tool now supports:

  • Multiple conditions: you can add multiple search conditions simultaneously for more precise data filtering
  • Flexible comparison operators: various comparison operators are available (equals, not equals, contains, etc.) for more accurate query construction

This allows you to create complex database queries without writing SQL code manually.

Update

Provides an ability to update data within DB.

DB Query