---
title: "Get All Databases Status"
method: GET
path: "/preprocessing/databases"
tags: ["preprocessing", "admin"]
---

# Get All Databases Status

`GET /preprocessing/databases`

## Request

- Base URL: `https://api.helena.bio` (the document declares no server; this is the origin it was published from)
- URL: `https://api.helena.bio/preprocessing/databases`
- Auth: none declared

Get complete status of all reference databases.

Returns identity, source files, parquet conversion, reference_db loading,
freshness assessment, and validation results for each database.

Fast endpoint (< 2 seconds): filesystem stat() calls + one DuckDB query.

## Response `200`

Successful Response

- AllDatabasesStatusResponse: Response for GET /preprocessing/databases.
  - `reference_db` ReferenceDBSummarySchema, required: Summary of reference_db.duckdb.
    - `exists` boolean, required
    - `file_path` string, required
    - `file_size_bytes` integer
    - `file_size_human` string
    - `last_modified` string, nullable
    - `tables` string[]
    - `total_rows` integer
  - `databases` DatabaseStatusSchema[], required
    - `name` string, required
    - `display_name` string, required
    - `version` string, nullable
    - `description` string, nullable
    - `priority` integer, required
    - `enabled` boolean
    - `license_required` boolean
    - `vep_required` boolean
    - `source_url` string, nullable
    - `source` SourceStatusSchema, required: Source files on disk.
      - `exists` boolean, required
      - `path` string, required
      - `files_found` integer
      - `files_expected` integer
      - `total_size_bytes` integer
      - `total_size_human` string
      - `oldest_file_modified` string, nullable
      - `newest_file_modified` string, nullable
    - `parquet` ParquetStatusSchema, required: Parquet conversion status.
      - `exists` boolean, required
      - `path` string, required
      - `partitions` integer
      - `partitions_expected` integer
      - `total_size_bytes` integer
      - `total_size_human` string
      - `last_modified` string, nullable
      - `row_count` integer, nullable
      - `conversion_metadata` ConversionMetadataSchema: Conversion metadata summary.
        - `start_time` string, nullable
        - `elapsed_seconds` number, nullable
        - `elapsed_human` string, nullable
        - `successful_chromosomes` integer, nullable
        - `failed_chromosomes` integer, nullable
    - `reference_db` ReferenceDBTableSchema, required: Status of a table in reference_db.duckdb.
      - `loaded` boolean, required
      - `table_name` string, required
      - `row_count` integer, nullable
      - `column_count` integer, nullable
    - `freshness` FreshnessSchema, required: Freshness assessment.
      - `status` string, required
      - `message` string, required
      - `source_age_days` integer, nullable
      - `parquet_age_days` integer, nullable
      - `cache_ttl_days` integer, nullable
      - `is_within_ttl` boolean, nullable
      - `suggested_action` string, nullable
    - `validation` ValidationSchema, required: Validation results.
      - `passed` boolean, required
      - `checks` object

---

[API](https://skmtc.dev/helena/apis/helix-insight-variant-analysis-service.md) · [All operations](https://skmtc.dev/helena/apis/helix-insight-variant-analysis-service/llms.txt) · [OpenAPI document](https://skmtc.dev/helena/apis/helix-insight-variant-analysis-service/revisions/fe51fd20cdf1?raw)