Skip to main content
Use natural language to query, transform, and visualize asset and maintenance data with AI-powered generative UI.

Overview

The Data Transformation tool allows you to:
  • Query backend data using natural language
  • Display results in interactive tables
  • Filter and sort data dynamically
  • Visualize trends and patterns

Natural Language Queries

Just ask in plain language:
  • “Show me all HVAC units”
  • “List equipment in sector 3”
  • “Find assets needing maintenance”
  • “Display generators by status”

Generative UI Tables

Query results are displayed in rich, interactive tables:

Features

Interactive

Click to expand, sort, and filter

Responsive

Adapts to screen size

Status Badges

Color-coded status indicators

Pagination

Handle large datasets

Column Types

  • Text: Equipment names, descriptions
  • Status Badges: Operational status with colors
  • Priority Badges: High/Medium/Low indicators
  • Stock Indicators: Red/yellow/green for inventory levels
  • Dates: Formatted maintenance dates
  • Links: Clickable references

How It Works

1

Natural Language Query

Type your question in the chat:
"Muéstrame todos los equipos de aire acondicionado"
2

AI Processing

The AI:
  • Parses your query
  • Identifies the data type (assets/inventory/maintenance)
  • Determines filters and sort order
  • Calls the appropriate backend API
3

Data Retrieval

Backend API returns:
  • Paginated results
  • Metadata (total count, page info)
  • Structured data objects
4

Generative UI

AI generates:
  • Table structure
  • Column definitions
  • Cell renderers
  • Interactive components

Backend Integration

Data transformation queries use the Backend API Service:
import { createBackendAPIService } from '@/app/lib/services/backend-api-service';

const api = createBackendAPIService();

// Query assets
const assets = await api.getActivos({
  tipo: 'unidad-hvac',
  ubicacion: 'sector-3'
});

// Query inventory
const inventory = await api.getRepuestos({
  bajo_stock: true
});

// Query maintenance
const maintenance = await api.getMantenimientos({
  estado: 'pendiente'
});
See Backend API Service for details.

Chat Tools Integration

The transformation is powered by chat tools:
  • consultar_activos - Query asset catalog
  • consultar_inventario - Search spare parts
  • consultar_mantenimientos - List work orders
  • consultar_calendario - View scheduled maintenance
  • consultar_reportes - Access maintenance reports
  • consultar_proveedores - List suppliers
See Chat Tools API for tool definitions.

Advanced Features

Filters

Apply filters with natural language:
  • “Show only high-priority work orders”
  • “Filter by location: Sector 3”
  • “Display equipment manufactured after 2020”

Sorting

Specify sort order:
  • “Sort by date, newest first”
  • “Order by priority, high to low”
  • “Sort alphabetically by name”

Pagination

Handle large datasets:
  • Results shown in pages of 15 items
  • Click “Load More” for additional pages
  • Total count displayed

Example Queries

"Muéstrame todos los equipos de aire acondicionado"
"Listar activos en el edificio principal"
"Equipos que requieren mantenimiento urgente"
"Mostrar generadores en operación"
"¿Qué repuestos están bajos de stock?"
"Mostrar inventario de filtros HVAC"
"Listar proveedores de partes eléctricas"
"Piezas más caras en inventario"
"Órdenes de trabajo pendientes"
"Mantenimiento programado para esta semana"
"Mostrar reportes del último mes"
"Tareas de mantenimiento vencidas"

Generative Tables

Table component documentation

Chat Tools

Backend query tools reference

Backend API

API service documentation

Build docs developers (and LLMs) love