---
title: "Get Single Database Status"
method: GET
path: "/preprocessing/databases/{db_name}"
tags: ["preprocessing", "admin"]
---

# Get Single Database Status

`GET /preprocessing/databases/{db_name}`

## 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/{db_name}`
- Auth: none declared

Get detailed status of a single database.

Includes everything from the list endpoint plus:
- Per-chromosome row counts (for partitioned databases)
- Column names in the DuckDB table
- Sample data (first 5 rows)
- Full conversion metadata JSON

## Path parameters

- `db_name` string, required

## Response `200`

Successful Response

- DatabaseDetailResponse: Response for GET /preprocessing/databases/{db_name} with detail.
  - `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
  - `detail` object, nullable

## Other responses

- `422`: Validation Error

---

[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)