# CloudBeaver Database Manager Setup

**Date:** 2026-02-03 12:30
**Context:** Configured CloudBeaver to connect to all NUC databases with pre-configured connections

## Access

| Property | Value |
|----------|-------|
| **URL** | `http://192.168.1.3:8978` |
| **Admin User** | `cbadmin` |
| **Admin Password** | `CloudBeaver2026!` |
| **Coolify UUID** | `joo4g4k0w08k8kcosgsgswc0` |

## Connected Databases (9/9)

### Coolify Standalone DBs
| Connection | Host (Container) | Database | User | Password | Status |
|------------|-------------------|----------|------|----------|--------|
| WhyRating Hub | `i8skkc8cwsgwgsg0g8kcw44k` | whyrating | whyrating | WhyRatingPG2026! | OK |
| Turbostarter | `db-v4gogwwc8wkk4888ksscc4k4` | core | turbostarter | turbostarter | OK |
| LiquidGym (MySQL) | `hgwcgs4oswwc8scg080scoo4` | liquidgym | liquidgym | liquidgym_nuc_2026 | OK |

### Service Embedded DBs
| Connection | Host (Container) | Database | User | Password | Status |
|------------|-------------------|----------|------|----------|--------|
| Outline | `postgres-pccg80wks4c084008owokkkg` | outline | HVubx2MKadO9V4JU | OGB4GnEblE6t86IyzXYyKLE6nUjlOftp0B006kS3O0qlQcNdGh1FUHVyKEg2UbFq | OK |
| Google Scraper | `postgres-g4s8w4csk8s8ocswg48kkogo` | scraper | scraper | scraper_nuc_2026 | OK |
| LiquidGym (Postgres) | `postgres-x4kk8g4k8w4g0cw480w84g4g` | postgres | postgres | postgres | OK |
| Knosia | `postgres-ik80skko0008w4000c4w40os` | knosia | knosia | knosia_nuc_2026 | OK |
| Authentik | `postgresql-e8owcw0s4wcswc4w4css0sws` | authentik | yth9ADhCXAsYytvI | H6Ts2mC7dGn7ExWlt0yDoYREHpEMeSH6 | OK |

### Infrastructure
| Connection | Host (Container) | Database | User | Password | Status |
|------------|-------------------|----------|------|----------|--------|
| Coolify DB | `coolify-db` | coolify | coolify | fwI1hpB5Y3LPV2zLBjP8g6OZ43PLd93/k0s4CLNwPiw= | OK (read-only) |

## Docker Networks

CloudBeaver is connected to 8 networks:
- `default` (service network)
- `coolify` (Coolify infra + Coolify DB)
- `pccg80wks4c084008owokkkg` (Outline + its Postgres)
- `e8owcw0s4wcswc4w4css0sws` (Authentik + its Postgres)
- `g4s8w4csk8s8ocswg48kkogo` (Google Scraper + its Postgres)
- `x4kk8g4k8w4g0cw480w84g4g` (LiquidGym Postgres + MySQL)
- `ik80skko0008w4000c4w40os` (Knosia + its Postgres)
- `v4gogwwc8wkk4888ksscc4k4` (Turbostarter: web + pgvector + minio)

## Configuration Files

- **data-sources.json:** `/opt/cloudbeaver/workspace/GlobalConfiguration/.dbeaver/data-sources.json`
- **initial-data-sources.conf:** `/opt/cloudbeaver/conf/initial-data-sources.conf` (backup for fresh init)
- **Coolify compose:** Updated with external networks, healthcheck, and port mapping

## Notes

- CloudBeaver reads connection definitions from `data-sources.json` but NOT credentials
- Credentials were stored via GraphQL `initConnection` mutation with `saveCredentials: true`
- MySQL 8 connections require `allowPublicKeyRetrieval: true` JDBC property
- `admin` is a reserved username in CloudBeaver CE (used `cbadmin` instead)
- Turbostarter was redeployed as service `v4gogwwc8wkk4888ksscc4k4` with container `db-v4gogwwc8wkk4888ksscc4k4`

## Adding New Databases

1. Add connection to `data-sources.json` on the volume
2. Connect CloudBeaver container to the new database's Docker network
3. Update Coolify compose with the new external network
4. Use CloudBeaver UI or GraphQL API to set credentials

## Related
- Coolify service: `http://192.168.1.3:8000` (UUID: joo4g4k0w08k8kcosgsgswc0)
- CloudBeaver docs: https://dbeaver.com/docs/cloudbeaver/