> ## Documentation Index
> Fetch the complete documentation index at: https://docs.emergence.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# em-data-insights Chart

> Helm chart for deploying the CRAFT Data Insights solution — extends em-core with data analysis agents and Redshift integration.

# em-data-insights Chart

`em-data-insights` deploys the CRAFT Data Insights solution — a superset of `em-core` that adds the data analysis agent and Redshift connector.

## Components

`em-data-insights` includes all [em-core](./em-core) components plus:

| Component                     | Purpose                                         |
| ----------------------------- | ----------------------------------------------- |
| `em-data-insights-agent`      | Data analysis and insights generation A2A agent |
| `em-redshift-query-connector` | AWS Redshift query connector service            |

## Quick start

<Steps>
  <Step title="Set environment variables">
    ```bash theme={null}
    export HOSTNAME=platform.example.com
    export KEYCLOAK_ADMIN_PASSWORD=<secure-password>
    export POSTGRES_PASSWORD=<secure-password>
    export REDSHIFT_HOST=<your-redshift-endpoint>
    export REDSHIFT_USER=<redshift-user>
    export REDSHIFT_PASSWORD=<redshift-password>
    ```
  </Step>

  <Step title="Create namespace">
    ```bash theme={null}
    kubectl create namespace em-data-insights
    ```
  </Step>

  <Step title="Create secrets">
    ```bash theme={null}
    # Platform credentials (Keycloak + PostgreSQL)
    kubectl create secret generic em-data-insights-credentials \
      --namespace em-data-insights \
      --from-literal=KEYCLOAK_ADMIN_PASSWORD=$KEYCLOAK_ADMIN_PASSWORD \
      --from-literal=POSTGRES_PASSWORD=$POSTGRES_PASSWORD

    # Redshift credentials — must be named 'redshift' with these exact keys
    kubectl create secret generic redshift \
      --namespace em-data-insights \
      --from-literal=redshift-host=$REDSHIFT_HOST \
      --from-literal=redshift-port=${REDSHIFT_PORT:-5439} \
      --from-literal=redshift-database=$REDSHIFT_DATABASE \
      --from-literal=redshift-username=$REDSHIFT_USER \
      --from-literal=redshift-password=$REDSHIFT_PASSWORD
    ```
  </Step>

  <Step title="Install the chart">
    ```bash theme={null}
    helm install em-data-insights oci://ghcr.io/emergenceai/em-charts/em-data-insights \
      --version 0.0.8 \
      --namespace em-data-insights \
      --set em-core.hostname=$HOSTNAME \
      --set em-core.schema=http
    ```
  </Step>
</Steps>

## Redshift integration

Configure the Redshift connector in your values:

```yaml theme={null}
em-redshift-query-connector:
  env:
    REDSHIFT_DATABASE: my_database
    REDSHIFT_PORT: "5439"
  envVars:
    - name: REDSHIFT_HOST
      valueFrom:
        secretKeyRef:
          name: redshift
          key: redshift-host
    - name: REDSHIFT_USERNAME
      valueFrom:
        secretKeyRef:
          name: redshift
          key: redshift-username
    - name: REDSHIFT_PASSWORD
      valueFrom:
        secretKeyRef:
          name: redshift
          key: redshift-password
```

## Using external databases

Disable bundled PostgreSQL and Redis for production:

```yaml theme={null}
postgresql:
  enabled: false

redis:
  enabled: false

postgresql:
  existingSecret: my-external-db-credentials

redis:
  existingSecret: my-external-db-credentials
```

## Key values

| Value                                          | Default                                           | Description                                    |
| ---------------------------------------------- | ------------------------------------------------- | ---------------------------------------------- |
| `em-core.hostname`                             | `localhost`                                       | External hostname (passed to em-core subchart) |
| `em-core.schema`                               | `http`                                            | `http` or `https`                              |
| `em-data-insights-agent.image.repository`      | `ghcr.io/emergenceai/em-data-insights-agent`      | Agent image                                    |
| `em-redshift-query-connector.image.repository` | `ghcr.io/emergenceai/em-redshift-query-connector` | Redshift connector image                       |
| `postgresql.enabled`                           | `true`                                            | Deploy bundled PostgreSQL                      |
| `redis.enabled`                                | `true`                                            | Deploy bundled Redis                           |

The full values reference is in `charts/em-data-insights/values.yaml` in the em-charts repository.

## Related

<CardGroup cols={2}>
  <Card title="em-core Chart" icon="dharmachakra" href="/deployment/helm/em-core">
    Core platform chart that em-data-insights extends.
  </Card>

  <Card title="Data Insights Overview" icon="chart-bar" href="/data-insights/overview">
    Data Insights solution capabilities.
  </Card>

  <Card title="Text-to-SQL" icon="code" href="/data-insights/text-to-sql">
    How the Text2SQL agent converts natural-language questions to SQL.
  </Card>
</CardGroup>