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.137 rijen/items22 domeincontainers
Zoeken
Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.
Rijen: boekhouding-sqlite.bank_statement
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
SELECT * FROM "bank_statement" LIMIT 50 OFFSET 0
| id | iban | period_start | period_end | opening_cents | closing_cents | imported_at |
|---|---|---|---|---|---|---|
| 1 | NL11****9678 | 2023-12-31 | 2026-05-28 | 1201651 | 135836 | 2026-05-29T16:48:09.948Z |
| 2 | NL17****2419 | 2023-12-31 | 2026-05-28 | 902610 | 56860 | 2026-05-29T16:48:10.352Z |
| 3 | NL47****9112 | 2023-12-31 | 2026-05-28 | 713702 | 97124 | 2026-05-29T16:48:10.625Z |
| 7 | NL11****9678 | 2016-12-31 | 2017-12-31 | 2442801 | 681095 | 2026-06-16T16:44:31.920Z |
| 8 | NL11****9678 | 2022-08-16 | 2022-08-16 | 0 | 695 | 2026-06-16T16:46:27.166Z |
Raw JSON details
Rij 1
{
"id": 1,
"iban": "NL11****9678",
"period_start": "2023-12-31",
"period_end": "2026-05-28",
"opening_cents": 1201651,
"closing_cents": 135836,
"imported_at": "2026-05-29T16:48:09.948Z"
}Rij 2
{
"id": 2,
"iban": "NL17****2419",
"period_start": "2023-12-31",
"period_end": "2026-05-28",
"opening_cents": 902610,
"closing_cents": 56860,
"imported_at": "2026-05-29T16:48:10.352Z"
}Rij 3
{
"id": 3,
"iban": "NL47****9112",
"period_start": "2023-12-31",
"period_end": "2026-05-28",
"opening_cents": 713702,
"closing_cents": 97124,
"imported_at": "2026-05-29T16:48:10.625Z"
}Rij 4
{
"id": 7,
"iban": "NL11****9678",
"period_start": "2016-12-31",
"period_end": "2017-12-31",
"opening_cents": 2442801,
"closing_cents": 681095,
"imported_at": "2026-06-16T16:44:31.920Z"
}Rij 5
{
"id": 8,
"iban": "NL11****9678",
"period_start": "2022-08-16",
"period_end": "2022-08-16",
"opening_cents": 0,
"closing_cents": 695,
"imported_at": "2026-06-16T16:46:27.166Z"
}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) |