TTN MQTT to PostgreSQL Python service

In order to get some sensor data into a Postgres database for consumption by Grafana dashboards and other applications I wrote a small Python service: ttnmqtt2pg

It’s available in a git repository (GitHub - gsauthof/lorawan: Stream LoRaWAN messages to PostgreSQL) which also includes a README that details the schema and some design decisions.

That repository also contains some Ansible roles for setting everything up.

Some example Grafana panel based on the streamed data:

Screenshot from 2021-12-13 18-16-46

The RSSI of those device for the same time period:

Screenshot from 2021-12-13 18-19-53


Screenshot from 2021-12-13 18-21-19