OpenKIM Query

Examples
Basic usage Specifying SI units Retrieving multiple keys

A square-bracketed list containing the Test name. The following formats are accepted: ["CC_DDDDDDDDDDDD"], ["TestName__CC_DDDDDDDDDDDD"], ["CC_DDDDDDDDDDDD_VVV"], ["TestName__CC_DDDDDDDDDDDD_VVV"]. Generally, the three digit version extension (VVV) should be omitted so that the latest version of the Test will be queried on. For more on KIM IDs, refer to the Guide to KIM IDs.

Accepted formats are identical to those above and, similar to above, the three digit version extension should generally be omitted.

A square-bracketed list containing the property name. May be specified as either the short name of a Property Definition, e.g. structure-cubic-crystal-npt, or the full property ID, e.g. ["tag:staff@noreply.openkim.org,2014-04-15:property/structure-cubic-crystal-npt"]. Only the short name should generally be used so that the latest version of the Property Definition is queried on. See here for a current list of Property Definitions.

Ordered array of keys specified as a square-bracketed, comma-separated list of quoted strings. The order of the keys must correspond to the order of the entries in the 'Units' field below. Some keys may be Optional in certain Property Definitions, if the requested optional key is not present in the returned test result, a value of null will be returned.

A square-bracketed, comma-separated list of quoted strings indicating the desired units that the value of each key should be returned in. The order of the entries in this list should correspond to the order of the entries in the 'Keys' field above. Valid strings for units are any of those recognized by the GNU units utility, or the special string "SI". Keys which are unitless must have a value of null (case-sensitive and unquoted).

See A Practical Guide to Raw MongoDB queries. Example queries:
Get all Test Drivers in the database Get all fcc Al lattice constants and the Model that ran them Get the lowest energy crystal structure for each Model using Si

Things you want true, as a dictionary of key value pairs, e.g. {"type": "td"} makes sure that all objects are test drivers.

Things you want back, as a dictionary of booleans, e.g. {"type":1, "path":1} returns just type and path (and '_id')

A mongodb aggregation pipeline. Use $sort, $limit, $skip, and $distinct aggregation pipeline stages instead of entering in their respective fields below if using aggregate(). For more information, check the docs

Database you want, valid options are [obj, data, job, log, agent]

Things you want sorted on, as a string, or a list with direction, e.g. "kimcode" sorts on kimcode, [["kimcode", -1]] gives reverse kimcode

How many you want, an integer, how it stops, leave empty for all

How many you want to skip, relevant if ordered

Things you want distinct, just a key, e.g. "type" would return distinct type fields. Note, this doesn't play well with others.

Reduce result to an array where the columns are ordered by this list i.e. ["meta.kimcode", "crystal-structure.a.source-value"]. Implies flatten.

Whether or not to flatten the keys in the dictionary

Return full database history. By default, only returns latest data

Return only count of number results created by query

Results

[
    {
        "log": "2026-08-19 23:44:53,294 - INFO - pipeline.compute - Copying the contents of /tmp/TE_144067719915_000-and-MO_475612090600_005-1787183093/output to /disk2/gateway/repository/er/TE_144067719915_000-and-MO_475612090600_005-1787183093-er"
    },
    {
        "log": "2026-08-19 23:44:53,249 - INFO - pipeline.pipeline.gateway-0 - Packaging job Error 'TE_144067719915_000-and-MO_475612090600_005-1787183093'..."
    },
    {
        "log": "2026-08-19 23:44:53,244 - INFO - pipeline.pipeline.gateway-0 - Got no compatible sites error 'GibbsFreeEnergyCrystal_A_hP68_194_ef2h2kl_Si_1200K__TE_144067719915_000-and-SW_ZhangXieHu_2014OptimizedSW2_Si__MO_475612090600_005'"
    },
    {
        "log": "2026-08-19 23:39:28,699 - INFO - pipeline.pipeline.gateway-0 - Sending task 'pipeline.tasks.director_result' with contents {'job': ['GibbsFreeEnergyCrystal_A_hP58_164_2d3i3j_Si_1200K__TE_731535371423_000', 'MEAM_LAMMPS_DuLenoskyHennig_2011_Si__MO_883726743759_002'], 'jobid': 'TE_731535371423_000-and-MO_883726743759_002-1787080422', 'uuid': 'TE_731535371423_000-and-MO_883726743759_002-1787080422-tr', 'result_type': 'tr', 'status': 'approved', 'prompting_child': None, 'prompting_parent': None, 'prompting_function': 'runpair', 'priority': 1000000}"
    },
    {
        "log": "2026-08-19 23:21:18,373 - INFO - pipeline.mongodb - Inserting result or error TE_731535371423_000-and-MO_883726743759_002-1787080422-tr "
    },
    {
        "log": "2026-08-19 23:21:18,353 - INFO - pipeline.rsync_tools - Touching flag file, upload complete for 'TE_731535371423_000-and-MO_883726743759_002-1787080422-tr'"
    },
    {
        "log": "2026-08-19 23:21:18,349 - INFO - pipeline.rsync_tools - ssh_touch_done cmd: ssh -F /home/gateway-user1/.ssh/config-gateway rsync-to-shared-repository \"touch /repo/home/.//pipeline/test-result-uploads/incoming//approved/./tr/TE_731535371423_000-and-MO_883726743759_002-1787080422-tr/upload_complete.txt\" >> /disk2/gateway/openkim-pipeline/logs/ssh.log 2>&1"
    },
    {
        "log": "2026-08-19 23:21:18,344 - INFO - pipeline.rsync_tools - ssh_touch_done remote_file: /repo/home/.//pipeline/test-result-uploads/incoming//approved/./tr/TE_731535371423_000-and-MO_883726743759_002-1787080422-tr/upload_complete.txt"
    },
    {
        "log": "2026-08-19 23:21:17,905 - INFO - pipeline.rsync_tools - running rsync for files: ['tr/TE_731535371423_000-and-MO_883726743759_002-1787080422-tr']"
    },
    {
        "log": "2026-08-19 23:21:17,875 - INFO - pipeline.pipeline.gateway-0 - Processing jobid TE_731535371423_000-and-MO_883726743759_002-1787080422 with result type tr"
    }
]

Query Link

https://query.openkim.org/raw?database=log&query=%7B%22id%22%3A%7B%22%24regex%22%3A%22gateway%22%7D%7D&fields=%7B%22log%22%3A1%2C%22_id%22%3A0%7D&sort=%5B%5B%22_id%22%2C-1%5D%5D&limit=10

Curl

curl --data-urlencode 'database=log' --data-urlencode 'query={"id":{"$regex":"gateway"}}' --data-urlencode 'fields={"log":1,"_id":0}' --data-urlencode 'sort=[["_id",-1]]' --data-urlencode 'limit=10' https://query.openkim.org/api

GET

https://query.openkim.org/api?database=log&query=%7B%22id%22%3A%7B%22%24regex%22%3A%22gateway%22%7D%7D&fields=%7B%22log%22%3A1%2C%22_id%22%3A0%7D&sort=%5B%5B%22_id%22%2C-1%5D%5D&limit=10

Python

result = requests.post("https://query.openkim.org/api",data={'database': 'log', 'query': '{"id":{"$regex":"gateway"}}', 'fields': '{"log":1,"_id":0}', 'sort': '[["_id",-1]]', 'limit': '10'}).json()

d3

d3.json('https://query.openkim.org/api?database=log&query=%7B%22id%22%3A%7B%22%24regex%22%3A%22gateway%22%7D%7D&fields=%7B%22log%22%3A1%2C%22_id%22%3A0%7D&sort=%5B%5B%22_id%22%2C-1%5D%5D&limit=10')

jQuery

$.post("https://query.openkim.org/api",{"database": "log", "query": "{\"id\":{\"$regex\":\"gateway\"}}", "fields": "{\"log\":1,\"_id\":0}", "sort": "[[\"_id\",-1]]", "limit": "10"});

pipeline.stdin.tpl

@< query({"database": "log", "query": {"id": {"$regularExpression": {"pattern": "gateway", "options": ""}}}, "fields": {"log": 1, "_id": 0}, "sort": [["_id", -1]], "limit": 10}) >@