Kostal Piko Dataexporter

This Python scripts grabs content of the REST API of a Kostal PIKO 7.0 and exports the data either to PostgreSQL, ClickHouse or InfluxDB v2).

Setup

• PostgreSQL: Import the init.sql into your Database
• ClickHouse: Create Database pvwr
• InfluxDB: Create Database pvwr
• Set environment variables with the relevant details
• KOSTAL_USERNAME
• KOSTAL_PASSWORD
• KOSTAL_HOST
• For PostgreSQL:
  • DB_HOST
  • DB_PORT
  • DB_NAME
  • DB_USER
  • DB_PASSWORD
• For ClickHouse:
  • CLICKHOUSE_HOST
  • CLICKHOUSE_PORT
  • CLICKHOUSE_USER
  • CLICKHOUSE_PASSWORD
  • CLICKHOUSE_DATABASE
• For InfluxDB (2.x):
  • INFLUXDB_ORG
  • INFLUXDB_BUCKET
  • INFLUXDB_URL
  • INFLUXDB_TOKEN
• Run python kostal-piko-dataexport.py
  • --influx2 1 (on, default) or --influx 0 (off, optional)
  • --postgres 1 (on, optional) or --postgres 0 (off, default)
  • --clickhouse 1 (on, optional) or --clickhouse 0 (off, default)
  • --interval {seconds} Scrape interval (default: 30)
  • --oneshot Scrape data, print to stdout and exit

There's also a Docker Image available on GitLab's project Container Registry.

Grafana

By logging the data with this script it's easily possible to create a nice Grafana Dashboard to display some of the interesting data:

You can import the dashboard-postgresql.json for PostgreSQL or dashboard-influxdb2.json to use it in your Grafana instance.

Note

This is just a quick-and-dirty script to grab to content of the REST-API of my Kostal Piko 7.0 Inverter. This might be usable on other Inverters aswell.