Kimmo Vallema

Showing 25 of 54 from the live probe.

• Lh Get Schema

  Introspect the learnathome.schule PostgreSQL database schema. Returns all tables with columns, types, nullability, and primary keys. Optionally filter by table name substring.

• Lh Get Table Sizes

  Get approximate row counts for all tables in learnathome.schule. Useful for understanding data volume before querying.

• Lh Query

  Run a safe read query against learnathome.schule. Constructs SELECT from table/where/limit/order_by — no raw SQL injection possible. Returns JSON array of rows.

• Lh Get Course Stats

  Get course statistics for learnathome.schule: total courses, enrollment counts, completion rates, grouped by department/category. Optionally filter by department.

• Lh Write

  Execute a write operation (INSERT, UPDATE, DELETE) on learnathome.schule. REQUIRES confirm=True. Will describe the operation and refuse if confirm is False. Args: table: Target table operation: INSERT | UPDATE | DELETE data: For INSERT/UPDATE — {column: value}. For DELETE — {where_column: value} confirm: Must be True to execute

• Lh Read File

  Read a file from the learnathome.schule server. Useful for reading configs, .env templates, Next.js files, logs. Restricted paths (shadow, private keys, /root) are blocked.

• Lh Write File

  Write content to a file on the learnathome.schule server. REQUIRES confirm=True. Describe what you are writing before confirming.

• Lh Service Status

  Get systemd service status and recent logs from learnathome.schule server. If no service specified, returns status of all known services.

• Lh Restart Service

  Restart a service on learnathome.schule. REQUIRES confirm=True. Valid services: learnathome, nginx, postgresql.

• Scp Get Schema

  Introspect the SportClubPro PostgreSQL database schema. Returns tables with columns, types, nullability, primary keys.

• Scp Get Table Sizes

  Get approximate row counts for all tables in SportClubPro.

• Scp Query

  Run a safe read query against SportClubPro PostgreSQL database. Constructs SELECT from table/where/limit/order_by parameters.

• Scp Write

  Execute INSERT, UPDATE, or DELETE on SportClubPro. REQUIRES confirm=True. For UPDATE: data must be {'set': {col: val}, 'where': {col: val}}.

• Scp Read File

  Read a file from the SportClubPro server (configs, logs, source files).

• Scp Write File

  Write content to a file on SportClubPro server. REQUIRES confirm=True.

• Scp Service Status

  Get service status and recent logs from SportClubPro server.

• Scp Restart Service

  Restart a service on SportClubPro. REQUIRES confirm=True.

• Hl List Servers

  List all registered homelab servers available for management.

• Hl Server Stats

  Get CPU, memory, disk usage and uptime for a homelab server.

• Hl Exec

  Execute a shell command on a homelab server via SSH. Destructive commands require confirm=True.

• Hl Read File

  Read a file from any registered homelab server.

• Hl Write File

  Write a file to any registered homelab server. REQUIRES confirm=True.

• Hl Service Status

  Get service status and recent logs from a homelab server. Use service='all' for summary.

• Hl Restart Service

  Restart a systemd service on a homelab server. REQUIRES confirm=True.

• Hl Tail Log

  Tail a log file from any homelab server.