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.138 rijen/items22 domeincontainers
Zoeken
Tabelzoeker zoekt in de gekozen tabel; dossierzoeker zoekt klant/dossierlocaties over bekende dossierstores.
Dossiertrace: 18811837-d6ad-454e-8bc2-8f72c0c5304b
Waar deze klant/dossier-id feitelijk voorkomt.
| Bron | Tabel/key | Label | Aantal | Sample |
|---|---|---|---|---|
| postgres-main | dossiers | Hermes Hypotheek E2E Test 2026-05-24 | 1 | 18811837-d6ad-454e-8bc2-8f72c0c5304b |
| postgres-main | dossier_data | dossier_data.dossier_id | 2 | 18811837-d6ad-454e-8bc2-8f72c0c5304b |
| postgres-main | audit_logs | audit_logs.dossier_id | 23 | 18811837-d6ad-454e-8bc2-8f72c0c5304b |
| postgres-main | workflow_events | workflow_events.dossier_id | 2 | 18811837-d6ad-454e-8bc2-8f72c0c5304b |
| postgres-main | dossier_data | key: workflow_v1 | 1 | 1779592882083 |
| postgres-main | dossier_data | key: inventarisatie | 1 | 1779592046016 |
Rijen: postgres-main.dossiers
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
WITH _statement_timeout AS (SELECT set_config('statement_timeout', '1500ms', true)) SELECT t.* FROM public."dossiers" t CROSS JOIN _statement_timeout ORDER BY created_at DESC LIMIT 50 OFFSET 0| id | name | created_at |
|---|---|---|
| 9711d808-3b75-4d54-8f0b-8d56072af018 | qa-onwaarschijnlijke-zoekterm-xyz-20260614 | 1781466629128 |
| 77e67854-ec33-4481-aebf-b5211210863d | qa-onwaarschijnlijke-zoekterm-xyz-20260614 | 1781466615810 |
| b6f787bc-be3e-40d0-9832-728f0b37f7f0 | Waterschade | 1781275276835 |
| 03c102b5-16de-45da-958e-1201eb3da19e | Toppin, Jaleesa (JPO) (95062) | 1781267679989 |
| 6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771 | Hoek, Robert van den (R.) | 1781247153356 |
| 100de351-22d4-46ef-9117-86f768363636 | Hermes rekenregister E2E 2026-06-02 normbron verplichtingen | 1780386560668 |
| cb172e51-0240-4fcd-8fc8-311ab5c383c6 | waterschade | 1780050522712 |
| ac9f9569-7085-4a56-842d-d8933d54b537 | mollink | 1779698281293 |
| hermes-e2e-advies-2026-05-24 | Hermes Hypotheek E2E Sandbox | 1779649854311 |
| hermes-e2e-2026-05-24 | Hermes Hypotheek E2E Sandbox | 1779621298590 |
| c93e90bf-68c0-4f5e-85f4-7a1cd30a0eba | Hermes Claude Opus E2E 2026-05-24 | 1779614029236 |
| 9dc68025-07b7-4b21-b246-fa7e713ffb82 | Hermes Hypotheek E2E Buildtest 2026-05-24 | 1779592953885 |
| 18811837-d6ad-454e-8bc2-8f72c0c5304b | Hermes Hypotheek E2E Test 2026-05-24 | 1779591998732 |
| be960a24-41d5-4f06-b00f-2f701f7d609a | Dylan Riebel | 1778612067524 |
| test-state-dossier-1 | Test State Dossier | 1778571365710 |
| test-queue-dossier-1 | q | 1778571365567 |
| dde8f934-dafd-4776-8342-d0d37cf72252 | test3 | 1778347533153 |
| supplier-blg-hypotheken | Leverancier - BLG Hypotheken | 1778254679439 |
| supplier-bnp-paribas-personal-finance | Leverancier - BNP Paribas Personal Finance | 1778254679438 |
| supplier-clarian-wonen | Leverancier - Clarian Wonen | 1778254679437 |
| supplier-colibri-hypotheken | Leverancier - Colibri Hypotheken | 1778254679436 |
| supplier-dynamic-credit | Leverancier - Dynamic Credit | 1778254679435 |
| supplier-dynamic-hypotheken | Leverancier - Dynamic Hypotheken | 1778254679434 |
| supplier-groene-hart-hypotheken | Leverancier - Groene Hart Hypotheken | 1778254679433 |
| supplier-hq-hypotheken | Leverancier - HQ Hypotheken | 1778254679432 |
| supplier-iqwoon | Leverancier - IQWOON | 1778254679431 |
| supplier-neo-hypotheken | Leverancier - Neo Hypotheken | 1778254679430 |
| supplier-onderlinge-nederland | Leverancier - Onderlinge Nederland | 1778254679429 |
| supplier-orange-credit | Leverancier - Orange Credit | 1778254679428 |
| supplier-philips-pensioenfonds | Leverancier - Philips Pensioenfonds | 1778254679427 |
| supplier-regiobank | Leverancier - RegioBank | 1778254679426 |
| supplier-sns-bank | Leverancier - SNS Bank | 1778254679425 |
| supplier-tellius-hypotheken | Leverancier - Tellius Hypotheken | 1778254679424 |
| supplier-woonfonds-hypotheken | Leverancier - Woonfonds Hypotheken | 1778254679423 |
| supplier-abn-amro | Leverancier - ABN AMRO | 1778242703795 |
| supplier-aegon | Leverancier - Aegon | 1778242703794 |
| supplier-allianz | Leverancier - Allianz | 1778242703793 |
| supplier-argenta | Leverancier - Argenta | 1778242703792 |
| supplier-asn-bank | Leverancier - ASN Bank | 1778242703791 |
| supplier-asr | Leverancier - ASR | 1778242703790 |
| supplier-attens | Leverancier - Attens | 1778242703789 |
| supplier-bijbouwe | Leverancier - bijBouwe | 1778242703788 |
| supplier-bunq | Leverancier - bunq | 1778242703787 |
| supplier-centraal-beheer | Leverancier - Centraal Beheer | 1778242703786 |
| supplier-florius | Leverancier - Florius | 1778242703785 |
| supplier-hollandwoont | Leverancier - HollandWoont | 1778242703784 |
| supplier-hypotrust | Leverancier - Hypotrust | 1778242703783 |
| supplier-impact | Leverancier - Impact | 1778242703782 |
| supplier-ing | Leverancier - ING | 1778242703781 |
| supplier-knab | Leverancier - Knab | 1778242703780 |
Raw JSON details
Rij 1
{
"id": "9711d808-3b75-4d54-8f0b-8d56072af018",
"name": "qa-onwaarschijnlijke-zoekterm-xyz-20260614",
"created_at": 1781466629128
}Rij 2
{
"id": "77e67854-ec33-4481-aebf-b5211210863d",
"name": "qa-onwaarschijnlijke-zoekterm-xyz-20260614",
"created_at": 1781466615810
}Rij 3
{
"id": "b6f787bc-be3e-40d0-9832-728f0b37f7f0",
"name": "Waterschade",
"created_at": 1781275276835
}Rij 4
{
"id": "03c102b5-16de-45da-958e-1201eb3da19e",
"name": "Toppin, Jaleesa (JPO) (95062)",
"created_at": 1781267679989
}Rij 5
{
"id": "6cdf1a8b-d6b0-4881-b6ca-2c7fb45c4771",
"name": "Hoek, Robert van den (R.)",
"created_at": 1781247153356
}Rij 6
{
"id": "100de351-22d4-46ef-9117-86f768363636",
"name": "Hermes rekenregister E2E 2026-06-02 normbron verplichtingen",
"created_at": 1780386560668
}Rij 7
{
"id": "cb172e51-0240-4fcd-8fc8-311ab5c383c6",
"name": "waterschade",
"created_at": 1780050522712
}Rij 8
{
"id": "ac9f9569-7085-4a56-842d-d8933d54b537",
"name": "mollink",
"created_at": 1779698281293
}Rij 9
{
"id": "hermes-e2e-advies-2026-05-24",
"name": "Hermes Hypotheek E2E Sandbox",
"created_at": 1779649854311
}Rij 10
{
"id": "hermes-e2e-2026-05-24",
"name": "Hermes Hypotheek E2E Sandbox",
"created_at": 1779621298590
}Rij 11
{
"id": "c93e90bf-68c0-4f5e-85f4-7a1cd30a0eba",
"name": "Hermes Claude Opus E2E 2026-05-24",
"created_at": 1779614029236
}Rij 12
{
"id": "9dc68025-07b7-4b21-b246-fa7e713ffb82",
"name": "Hermes Hypotheek E2E Buildtest 2026-05-24",
"created_at": 1779592953885
}Rij 13
{
"id": "18811837-d6ad-454e-8bc2-8f72c0c5304b",
"name": "Hermes Hypotheek E2E Test 2026-05-24",
"created_at": 1779591998732
}Rij 14
{
"id": "be960a24-41d5-4f06-b00f-2f701f7d609a",
"name": "Dylan Riebel",
"created_at": 1778612067524
}Rij 15
{
"id": "test-state-dossier-1",
"name": "Test State Dossier",
"created_at": 1778571365710
}Rij 16
{
"id": "test-queue-dossier-1",
"name": "q",
"created_at": 1778571365567
}Rij 17
{
"id": "dde8f934-dafd-4776-8342-d0d37cf72252",
"name": "test3",
"created_at": 1778347533153
}Rij 18
{
"id": "supplier-blg-hypotheken",
"name": "Leverancier - BLG Hypotheken",
"created_at": 1778254679439
}Rij 19
{
"id": "supplier-bnp-paribas-personal-finance",
"name": "Leverancier - BNP Paribas Personal Finance",
"created_at": 1778254679438
}Rij 20
{
"id": "supplier-clarian-wonen",
"name": "Leverancier - Clarian Wonen",
"created_at": 1778254679437
}Rij 21
{
"id": "supplier-colibri-hypotheken",
"name": "Leverancier - Colibri Hypotheken",
"created_at": 1778254679436
}Rij 22
{
"id": "supplier-dynamic-credit",
"name": "Leverancier - Dynamic Credit",
"created_at": 1778254679435
}Rij 23
{
"id": "supplier-dynamic-hypotheken",
"name": "Leverancier - Dynamic Hypotheken",
"created_at": 1778254679434
}Rij 24
{
"id": "supplier-groene-hart-hypotheken",
"name": "Leverancier - Groene Hart Hypotheken",
"created_at": 1778254679433
}Rij 25
{
"id": "supplier-hq-hypotheken",
"name": "Leverancier - HQ Hypotheken",
"created_at": 1778254679432
}Rij 26
{
"id": "supplier-iqwoon",
"name": "Leverancier - IQWOON",
"created_at": 1778254679431
}Rij 27
{
"id": "supplier-neo-hypotheken",
"name": "Leverancier - Neo Hypotheken",
"created_at": 1778254679430
}Rij 28
{
"id": "supplier-onderlinge-nederland",
"name": "Leverancier - Onderlinge Nederland",
"created_at": 1778254679429
}Rij 29
{
"id": "supplier-orange-credit",
"name": "Leverancier - Orange Credit",
"created_at": 1778254679428
}Rij 30
{
"id": "supplier-philips-pensioenfonds",
"name": "Leverancier - Philips Pensioenfonds",
"created_at": 1778254679427
}Rij 31
{
"id": "supplier-regiobank",
"name": "Leverancier - RegioBank",
"created_at": 1778254679426
}Rij 32
{
"id": "supplier-sns-bank",
"name": "Leverancier - SNS Bank",
"created_at": 1778254679425
}Rij 33
{
"id": "supplier-tellius-hypotheken",
"name": "Leverancier - Tellius Hypotheken",
"created_at": 1778254679424
}Rij 34
{
"id": "supplier-woonfonds-hypotheken",
"name": "Leverancier - Woonfonds Hypotheken",
"created_at": 1778254679423
}Rij 35
{
"id": "supplier-abn-amro",
"name": "Leverancier - ABN AMRO",
"created_at": 1778242703795
}Rij 36
{
"id": "supplier-aegon",
"name": "Leverancier - Aegon",
"created_at": 1778242703794
}Rij 37
{
"id": "supplier-allianz",
"name": "Leverancier - Allianz",
"created_at": 1778242703793
}Rij 38
{
"id": "supplier-argenta",
"name": "Leverancier - Argenta",
"created_at": 1778242703792
}Rij 39
{
"id": "supplier-asn-bank",
"name": "Leverancier - ASN Bank",
"created_at": 1778242703791
}Rij 40
{
"id": "supplier-asr",
"name": "Leverancier - ASR",
"created_at": 1778242703790
}Rij 41
{
"id": "supplier-attens",
"name": "Leverancier - Attens",
"created_at": 1778242703789
}Rij 42
{
"id": "supplier-bijbouwe",
"name": "Leverancier - bijBouwe",
"created_at": 1778242703788
}Rij 43
{
"id": "supplier-bunq",
"name": "Leverancier - bunq",
"created_at": 1778242703787
}Rij 44
{
"id": "supplier-centraal-beheer",
"name": "Leverancier - Centraal Beheer",
"created_at": 1778242703786
}Rij 45
{
"id": "supplier-florius",
"name": "Leverancier - Florius",
"created_at": 1778242703785
}Rij 46
{
"id": "supplier-hollandwoont",
"name": "Leverancier - HollandWoont",
"created_at": 1778242703784
}Rij 47
{
"id": "supplier-hypotrust",
"name": "Leverancier - Hypotrust",
"created_at": 1778242703783
}Rij 48
{
"id": "supplier-impact",
"name": "Leverancier - Impact",
"created_at": 1778242703782
}Rij 49
{
"id": "supplier-ing",
"name": "Leverancier - ING",
"created_at": 1778242703781
}Rij 50
{
"id": "supplier-knab",
"name": "Leverancier - Knab",
"created_at": 1778242703780
}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) |