json-scada

{json:scada}

A portable and scalable SCADA/IIoT-I4.0 platform centered on the MongoDB database server.

Mission Statement

To provide an easy to use, fully-featured, scalable, and portable SCADA/IIoT-I4.0 platform built by leveraging mainstream open-source IT tools.

Screenshots

Running Via Docker

sudo docker run -p 80:80 -p 9000:9000 -p 4840:4840 -p 2404:2404 -p 20000:20000 -d --name=json_scada ricardolo/json-scada:latest

Open http://127.0.0.1 on a browser (user=“admin” and password=“jsonscada”). See details here: Docker Image. Other installation options and instructions are available in the Installation Guide.

Major features

• Standard IT tools applied to SCADA/IoT (MongoDB, PostgreSQL/TimescaleDB, Node.js, C#, Golang, Grafana, etc.).
• MongoDB as the real-time core database, persistence layer, config store, SOE historian.
• Event-based realtime async data processing with MongoDB Change Streams.
• Portability and modular interoperability over Linux, Windows, x86/64, ARM.
• Windows installer available in the releases section.
• Unlimited tags, servers, and users.
• Horizontal scalability, from a single computer to big clusters (MongoDB-sharding), Docker containers, VMs, Kubernetes, cloud, or hybrid deployments.
• Modular distributed architecture. Lightweight redundant data acquisition nodes can connect securely over TLS to the database server. E.g. a Raspberry PI can be a data acquisition node.
• Extensibility of the core data model (MongoDB: NoSQL/schema-less).
• HTML5 Web interface. UTF-8/I18N. Mobile access. Web-based configuration management.
• Role-based access control (RBAC).
• Various high-quality protocol drivers.
• Integration with MQTT brokers (compatibility with Sparkplug B).
• Live point configuration updates.
• Inkscape-based and web-base SVG synoptic display editors.
• PostgreSQL/TimescaleDB historian integrated with Grafana for easy creation of dashboards.
• Easy development of custom applications with modern stacks like MEAN/MERN, etc. Extensive use of JSON from bottom up.
• Leverage a huge ecosystem of MongoDB/PostgreSQL tools, community, services, etc.
• Easy AI-helped custom app development using templates/API for tools like WindSurf/Cline/Cursor/Copilot/etc.

Use cases

• Protocol Gateway.
• Secure Protocol Gateway with 1-way air gapped replication (via data diode or tap device).
• Power/Oil/Gas/Manufacturing/etc Local Station HMI.
• SCADA for Control Centers.
• SCADA/IIoT Historian.
• Intranet/Internet HTTPS Gateway - Visualization Server.
• Multilevel Systems Integration (SCADA/IIoT/ERP/MES/PLC).
• Global-Level/Cloud SCADA Systems Integration.
• Edge processing.
• Data concentrator for Big Data / ML processing.
• Digital Transformation, Industry 4.0 enabler.

Real-world usage

• 5+ years of usage in 2 big control centers scanning data from 80+ substations, 90k tags.
• 5+ years of usage as HMI for local operation of circa 40 substations up to 230kV level.

Architecture

Documentation

• Generic Install Guide
• Windows Installer
• RHEL/Rocky/Alma/Oracle Linux 9/10 Installer Script
• Ubuntu Linux 24.04/26.04 Installer Script
• Docker Image
• Docker Compose Demo
• Schema Documentation
• Config File
• SVG Synoptic Display Editor
• IEC61850 Client Driver (GO)
• IEC61850 Server Driver (Go)
• IEC60870-5-104 Server Driver (Go)
• IEC60870-5-104 Client Driver (Go)
• IEC60870-5-101 Server Driver (Go)
• IEC60870-5-101 Client Driver (Go)
• ICCP TASE2 Client Driver
• ICCP TASE2 Server Driver
• DNP3 Client Driver (Go)
• DNP3 Server Driver (Go)
• Telegraf Listener Driver
• Node-RED Integration Driver (bidirectional)
• N8N Integration Driver (bidirectional)
• MQTT Sparkplug-B Client Driver
• OPC-UA Client Driver (Go)
• OPC-UA Server Driver
• OPC-DA Client Driver
• OPC-DA Server Driver
• PLC4J Client Driver
• Modbus Client Driver (native TCP/TLS/RTU/RTU-over-TCP, all byte orders)
• Modbus Server Driver (native TCP/TLS/RTU/RTU-over-TCP, all byte orders)
• Calculations
• Change Stream Data Processor
• Custom Data Processor
• Custom Developments
• Realtime Data Server
• Report Generators
• Deep Wiki

Protocols Roadmap

• IEC 60870-5-104 Server TCP/TLS
• IEC 60870-5-104 Client TCP/TLS
• IEC 60870-5-101 Server Serial/TCP
• IEC 60870-5-101 Client Serial/TCP
• IEC 60870-5-103 Client Serial/TCP
• IEC 61850 MMS Client TCP/TLS
• IEC 61850 MMS Server TCP/TLS
• IEC 61850 GOOSE/SV Client
• DNP3 Client TCP/UDP/TLS/Serial
• DNP3 Server TCP/UDP/TLS/Serial
• Various protocols (Modbus, S7, etc.) via PLC4X-Java
• Modbus Client (native) TCP/TLS/RTU/RTU-over-TCP, all byte orders
• Modbus Server (native) TCP/TLS/RTU/RTU-over-TCP, all byte orders
• ICCP Client TCP/TLS
• ICCP Server TCP/TLS
• Telegraf Client (many data sources available such as MQTT, MODBUS, SNMP, …)
• MQTT/Sparkplug-B Pub/Sub TCP/TLS
• OPC UA PubSub over MQTT with JSON payloads client
• OPC UA Client TCP/Secure
• OPC UA Server TCP/Secure
• OPC UA Historical Data Server
• OPC DA Client (Windows)
• OPC DA Server (Windows)
• ONVIF Camera control and streaming

Features Roadmap

• Web-based Viewers
• Web-based Configuration Manager
• Excel-based Configuration
• JWT Authentication
• User auth/Role-based Access Control (RBAC)
• LDAP/AD Authorization
• Inkscape-based SVG Synoptic Display Editor
• Web-based SVG Synoptic Display Editor
• Skill file for AI-assisted SVG creation with SCADA markup
• MCP Server to help with AI query, development and testing
• Template nodejs app with Typescript submodule to access JSON-SCADA data structures, manage connections and redundancy
• Compiled Cyclic Calculations Engine
• Low-latency/Asynchronous Calculations Engine
• Customizable Change-Stream Processor (for user implemented scripts)
• Basic Alarms Processor
• Advanced Alarms Processor
• Receipt runtime/editor
• PostgreSQL/TimescaleDB Historian
• Grafana Integration
• Metabase Integration (via PostgreSQL/MongoDB connectors)
• One-way realtime replication (over eth diode/tap device) w/ point db sync and historical backfill
• Windows Installer
• Docker Image
• Docker Compose Demo (docker-compose.yaml scripts)
• Install Script for RedHat/Rocky/Alma 9/10 Linux x86-64 and arm64
• Install Script for Ubuntu 24.04/26.04 Linux x86-64 and arm64
• Online Demo
• Supervisor (Linux process manager) examples
• InfluxDB Integration
• Telegraf Integration
• PowerBI Integration (via PostgreSQL connector)
• Kafka/Redpanda/Benthos Integration
• Eclipse 4diac
• Supabase Integration
• Node-RED Integration (bidirectional driver + node-red-contrib-jsonscada)
• n8n Integration (bidirectional driver + n8n-nodes-jsonscada)
• Alerta Integration (https://alerta.io/)
• Open PLC Integration
• Example templates/API for fast AI-helped custom app developments

Enterprise Services (available on request)

• Customizations
• Linux Image / VM
• Managed Cloud Service
• Supported LTS versions
• Commercial Redistribution License (Dual Licensing)

Online Demo (substations simulation)

• http://150.230.171.172

This demo provides a public IEC 60870-5-104 server port on IP address 150.230.171.172:2404 (common address = 1) for testing.

The demo data is published as regular MQTT topics to the public broker mqtt://test.mosquitto.org:1883 (about 8600 topics in JsonScadaDemoVPS/# and ACME_Utility/#).

Data is also published as Sparkplug-B to mqtt://test.mosquitto.org:1883 (about 4300 device metrics in spBv1.0/Sparkplug B Devices/+/JSON-SCADA Server/#). Data/birth messages are compressed by Eclipse Tahu Javascript libs.

Developer Contact

• https://www.linkedin.com/in/ricardo-olsen/