mqtt2postgres

This project aims to implement a MQTT Message Broker to Postgres interface.

Pull requests are always welcome. For a list of past changes, see [CHANGELOG.md][__link2].

Currently Supported Features

• Generate Tables based on the MQTT Topic and Data-Type of the Payload
• Unmarshal JSON payloads into a single table
• Some things configurable via the TOML config file

Quickstart

[mqtt]
broker_ip = "localhost"
broker_port = 1883
client_name = "mqtt2postgres"

[postgres]
connection_string = "postgresql://postgres:postgres@localhost:5432/mqtt2postgres"

# [[topics.subscribe]]
# topic = "#"

# avoid subscribing to topics multiple times, there is no deduplication yet

[[topics.subscribe]]
topic = "zigbee2mqtt/#"

[[topics.subscribe]]
topic = "awtrix/eceb30/#"

License

@ 2024 Gero Gerke and contributors.