# Retrieve KOTS application Config Values without Admin Console

**URL:** <https://community.replicated.com/t/retrieve-kots-application-config-values-without-admin-console/1461>\
**Category:** How do I?\
**Created:** [December 5, 2024, 1:34am UTC](https://community.replicated.com/t/retrieve-kots-application-config-values-without-admin-console/1461 "2024-12-05T01:34:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![GerardNguyen](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.replicated.com/gerardnguyen/32/828_2.png) [@GerardNguyen](https://community.replicated.com/u/GerardNguyen)\
**Post date:** [December 5, 2024, 1:34am UTC](https://community.replicated.com/t/retrieve-kots-application-config-values-without-admin-console/1461/1 "2024-12-05T01:34:54Z")

</div>

**Update** : See [Retrieve KOTS Config Values When the Admin Console is Unavailable](https://community.replicated.com/t/retrieve-kots-config-values-when-the-admin-console-is-unavailable/1589) for the latest community post on this subject which provides a utility for exporting the values in cases where the Admin Console isn’t available

* * *

Under normal circumstances, you can retrieve KOTS application config values using the KOTS CLI [kots get config](https://docs.replicated.com/reference/kots-cli-get-config)

When the KOTS Admin Console is unavailable but you need to access application configuration values, you can retrieve them directly from the rqlite database. This guide explains how to access both current and previous version configurations.

## Prerquisites

- Access to the Kubernetes cluster with sufficient permissions
- StatefulSet `kotsadm-rqlite` is up and running
- `kubectl` CLI tool installed and configured
- `curl` `jq` installed

## Instructions

- **Port-Forward to rqlite Service** , first establish a connection to the rqlite service:

```auto
export NAMESPACE=<namespace>
kubectl port-forward svc/kotsadm-rqlite 4001:4001 -n $NAMESPACE

```

- **Retrieve Configuration Values** in a new terminal window, run the following commands:

```auto
export NAMESPACE=<namespace>
export URL=kotsadm:$(kubectl get secret kotsadm-rqlite -n $NAMESPACE -o jsonpath='{.data.password}' | base64 -d)@localhost:4001

# for latest config values
curl -sG $URL/db/query\?pretty\&timings --data-urlencode 'q=select av.config_values from app_version av join app a on a.id=av.app_id and a.current_sequence = av.sequence' | jq -r '.results[0].values[0][0]' > config-values.yaml

# for config values for specific app sequence, replace <sequence> with actual sequence number
curl -sG $URL/db/query\?pretty\&timings --data-urlencode 'q=select config_values from app_version where sequence = <sequence>' | jq -r '.results[0].values[0][0]' > config-values.yaml

```