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:
The RSSI of those device for the same time period:
SNR:
