Controlpanel / Database
Database Explorer
Read-only SQL/JSON werkbank. Open een databron, kies een tabel, zoek in echte rijen en inspecteer data als ruwe JSON. Geen vrije SQL, geen writes, geen export.
6 bronnen66 tabellen/stores257.140 rijen/items22 domeincontainers
Zoeken
Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.
Rijen: boekhouding-sqlite.dagboek
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
SELECT * FROM "dagboek" LIMIT 50 OFFSET 0
| id | bv_code | code | naam | type | active |
|---|---|---|---|---|---|
| 1 | HOLDING | BANK | Bank | bank | 1 |
| 2 | HOLDING | INK | Inkoopboek | inkoop | 1 |
| 3 | HOLDING | VRK | Verkoopboek | verkoop | 1 |
| 4 | HOLDING | MEM | Memoriaal | memoriaal | 1 |
| 5 | HOLDING | KAS | Kas | kas | 1 |
| 6 | PALEIS | BANK | Bank | bank | 1 |
| 7 | PALEIS | INK | Inkoopboek | inkoop | 1 |
| 8 | PALEIS | VRK | Verkoopboek | verkoop | 1 |
| 9 | PALEIS | MEM | Memoriaal | memoriaal | 1 |
| 10 | PALEIS | KAS | Kas | kas | 1 |
| 11 | UZ | BANK | Bank | bank | 1 |
| 12 | UZ | INK | Inkoopboek | inkoop | 1 |
| 13 | UZ | VRK | Verkoopboek | verkoop | 1 |
| 14 | UZ | MEM | Memoriaal | memoriaal | 1 |
| 15 | UZ | KAS | Kas | kas | 1 |
Raw JSON details
Rij 1
{
"id": 1,
"bv_code": "HOLDING",
"code": "BANK",
"naam": "Bank",
"type": "bank",
"active": 1
}Rij 2
{
"id": 2,
"bv_code": "HOLDING",
"code": "INK",
"naam": "Inkoopboek",
"type": "inkoop",
"active": 1
}Rij 3
{
"id": 3,
"bv_code": "HOLDING",
"code": "VRK",
"naam": "Verkoopboek",
"type": "verkoop",
"active": 1
}Rij 4
{
"id": 4,
"bv_code": "HOLDING",
"code": "MEM",
"naam": "Memoriaal",
"type": "memoriaal",
"active": 1
}Rij 5
{
"id": 5,
"bv_code": "HOLDING",
"code": "KAS",
"naam": "Kas",
"type": "kas",
"active": 1
}Rij 6
{
"id": 6,
"bv_code": "PALEIS",
"code": "BANK",
"naam": "Bank",
"type": "bank",
"active": 1
}Rij 7
{
"id": 7,
"bv_code": "PALEIS",
"code": "INK",
"naam": "Inkoopboek",
"type": "inkoop",
"active": 1
}Rij 8
{
"id": 8,
"bv_code": "PALEIS",
"code": "VRK",
"naam": "Verkoopboek",
"type": "verkoop",
"active": 1
}Rij 9
{
"id": 9,
"bv_code": "PALEIS",
"code": "MEM",
"naam": "Memoriaal",
"type": "memoriaal",
"active": 1
}Rij 10
{
"id": 10,
"bv_code": "PALEIS",
"code": "KAS",
"naam": "Kas",
"type": "kas",
"active": 1
}Rij 11
{
"id": 11,
"bv_code": "UZ",
"code": "BANK",
"naam": "Bank",
"type": "bank",
"active": 1
}Rij 12
{
"id": 12,
"bv_code": "UZ",
"code": "INK",
"naam": "Inkoopboek",
"type": "inkoop",
"active": 1
}Rij 13
{
"id": 13,
"bv_code": "UZ",
"code": "VRK",
"naam": "Verkoopboek",
"type": "verkoop",
"active": 1
}Rij 14
{
"id": 14,
"bv_code": "UZ",
"code": "MEM",
"naam": "Memoriaal",
"type": "memoriaal",
"active": 1
}Rij 15
{
"id": 15,
"bv_code": "UZ",
"code": "KAS",
"naam": "Kas",
"type": "kas",
"active": 1
}Andere domeindatabases
Gefilterde containerinventaris. Niet alle containers hebben al een veilige connector.
| Container | Image | Status |
|---|---|---|
| adviestool-web | adviestool-web:latest | Up 9 minutes |
| adviestool-whatsapp | adviestool-whatsapp:latest | Up About an hour |
| adviestool-ocr | adviestool-ocr:latest | Up About an hour (healthy) |
| adviestool-web-preview | adviestool-web-preview:latest | Up 3 days |
| adviestool-preview-ocr | 9e5e9933f3ab | Up 3 days (healthy) |
| adviestool-postgres-test | postgres:17-alpine | Up 3 days (healthy) |
| adviestool-postgres | postgres:17-alpine | Up 5 days (healthy) |
| boekhouding-uw-zekerheid-mssql-1 | mcr.microsoft.com/mssql/server:2022-latest | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-arq-worker-1 | boekhouding-uw-zekerheid-arq-worker | Up 6 days |
| boekhouding-uw-zekerheid-api-1 | boekhouding-uw-zekerheid-api | Up 6 days |
| boekhouding-uw-zekerheid-web-1 | boekhouding-uw-zekerheid-web | Up 6 days |
| boekhouding-uw-zekerheid-caddy-1 | caddy:2-alpine | Up 6 days |
| boekhouding-uw-zekerheid-otel-collector-1 | otel/opentelemetry-collector:0.136.0 | Up 6 days |
| boekhouding-uw-zekerheid-redis-1 | redis:7-alpine | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-postgres-1 | pgvector/pgvector:pg16 | Up 6 days (healthy) |
| boekhouding-uw-zekerheid-minio-1 | minio/minio:RELEASE.2025-09-07T16-13-09Z | Up 6 days |
| adviseursite | adviseursite-adviseursite | Up 7 days (healthy) |
| hypotheek-gate | hypotheek-gate:latest | Up 7 days (healthy) |
| dash | dash-uw-zekerheid:latest | Up 7 days (healthy) |
| adviesbox-windows | dockurr/windows | Up 7 days |
| klantportaal | klantportaal:latest | Up 7 days (healthy) |
| uwpaleis-test | uwpaleis-website:latest | Up 7 days (healthy) |