MQTT is a good choice for resource constrained devices. This is an implementation of MQTT for IoT: sensors and actuators (2 way). The database is SQL. It includes MQTT message formats that permit send / response.
The database design is complete and at the same time extendable.