With IoT it is possible to connect several devices to the internet, but each device has its specific data format, so this project creates a way that allows the user to connect the device to the ChirpStack server and collect data automatically without the need to create a specific data model in the database. Many users don't know how to create or connect their data to a database, this project allows users to save and test their routines. All data that arrives at chirpstack is saved in a database through a text field that receives a json from MQTT. In this database, a dataview is created for users to access their data and save it in their own databases.

Chirpstack allows the user to access the data, however, the data is temporary and only the last 10 messages are displayed. This project was created to facilitate and simplify the way for users to save their data, as it is normal for sensors to collect data all day long, in some cases every few seconds.

Software and technologies used:

• Ubuntu: Operational system.

• Docker: Containerize applications.

• Database: PostgreSQL.

• Sensors: Sensors compatible with Arduino and Raspberry, for example.

• Chirpstack: LoraWAN server.

• LoRaWAN: Protocol sending data from LOng-RAnge sensors.

• MQTT: Protocol for sending data.