Overview

The Enterprise Configuration Management Database (CMDB) is a highly scalable, event-driven platform built on a reactive architecture (Eclipse Vert.x) and backed by PostgreSQL. It provides a single system of record for IT infrastructure, supporting advanced multi-dataset reconciliation, AI-driven analytics (AIOps), high-availability clustering, and granular multi-tenant access control.

The platform is designed around a Zero-Trust, Multi-Tenant architecture, ensuring that every API request is cryptographically validated and strictly scoped. It transforms a passive database into an active automation orchestrator, utilising a real-time event bus, dynamic rule evaluation, and automated action dispatching.

Architecture

The LIKPI CMDB follows a decoupled, modular design. The backend is a reactive microservice, while the frontend is a modern Single Page Application (SPA).

Backend Core & Platform

The Java/Vert.x backend handles the fundamental operational logic, persistence, and platform security.

  • Reactive HTTP/API Router: A non-blocking API gateway managing all inbound REST requests.
  • PostgreSQL Persistence: Manages database interactions, schema-less JSONB operations, and table partitioning.
  • Activity & Reconciliation Engine: The “brain” of the CMDB, processing merges from staging datasets (SANDBOX) into PRODUCTION by enforcing identification rules, resolving UUIDs, and calculating attribute precedence.
  • RBAC & Multi-Tenant Security: Enforces Row-Level Security (RLS) and JWT-based Role-Based Access Control (RBAC) to separate data between tenants.
  • License & Quota Service: Validates the platform’s license and enforces limits on HA nodes, CI counts, and users.
  • HA Cluster Manager: Manages distributed state and coordinates background job execution via Hazelcast.

Frontend User Interface (UI)

The UI is a responsive SPA built with React, TypeScript, and Vite, styled with Tailwind CSS. Key modules include:

  • Graph Explorer: An interactive canvas (React Flow) for visualising CI dependencies.
  • Data Explorer: A tabular data management interface with an advanced query builder.
  • Dashboard Factory: A no-code, drag-and-drop editor for building analytical dashboards.
  • AIOps Assistant: A chat interface for natural language to SQL (NL2SQL) queries.

High-Level Topology

The system consists of the following tiers:

  • Tier 1 – Frontend: End users and APIs access the React SPA.
  • Tier 2 – Routing: An API Gateway / Load Balancer distributes traffic.
  • Tier 3 – Compute: Multiple Vert.x application nodes form an active-active cluster, synchronised via a Hazelcast Grid.
  • Tier 4 – Intelligence: A local Ollama model and a Cloud AI engine provide cognitive services.
  • Tier 5 – Storage: A PostgreSQL Primary database with read-only replicas ensures data durability and read scalability.

CMDB-as-Code (Native GitOps)

Likpi features a native GitOps engine that empowers infrastructure and development teams to manage Configuration Items (CIs) and relationships using declarative YAML files (likpi.yaml) stored directly in Git (GitHub, GitLab, Bitbucket).

Instead of relying on manual ticket entry or fragile ETL (Extract, Transform, Load) scripts, Likpi intercepts Git webhooks in real-time. It stages the incoming data in isolated Virtual Datasets and relies on a smart Reconciliation Engine to safely merge changes into Production. This ensures your code and your CMDB are always perfectly synchronized, complete with automated cleanup of deleted assets (Zombie CI prevention).