I'm currently using thingsboard to manage and deliver IoT device configuration. The IoT device can access its own configuration with its own auth key. This is great. However, thingsboard is a quite a lot more than I need and the settings management is bit clunky. Does anyone know of an db builder that will allow me to set a per row access token that each IoT device can use to fetch it's own row of config data ? I've looking at budibuilder and airtable but I can't see to get them to allow the IoT devices access to their record.

Update : I've got a bare bones Anvil app that is kinda of working but creating the entire editing interface a serious pain. All of these other database application designers have all the editing built in but how do get them to serve individual iot device config data without authentication ?

  • 1
    when you are talking about a database, then the term is record, not row ..... almost all database programs have a way of retrieving a single record
    – jsotola
    Apr 12, 2021 at 0:47

1 Answer 1


I know very little about thingsboard, but I would have assumed that if you add an enrichment node to add whatever device attributes you need, you can then use that in a transformation node, to run any javascript you want, where you could access some database such as airtable or even AWS dynamodb and use some of those device attributes as keys.

If you're not on thingsboard but on AWS IoT, you could then use a rule action to access a dynamodb database to get a record, using the client ID (perhaps with other things) as key.

  • I really appreciate your answer here but it sounds way too complicated.
    – tavis
    Apr 20, 2021 at 1:40

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.