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.bankregel_correctie
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
SELECT * FROM "bankregel_correctie" LIMIT 50 OFFSET 0
| id | bv_code | boekjaar | account_no | regel_key | bron_account_no | doel_account_no | bedrag_cents | correctie_entry_id | status | actor | beslist_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | UZ | 2024 | 810 | card-herclass-2024-4868 | 810 | 4868 | 55293 | verwerkt | claude-card-herclass-20260614 | 2026-06-14T08:39:54.170Z | |
| 2 | UZ | 2024 | 810 | card-herclass-2024-4610 | 810 | 4610 | 15723 | verwerkt | claude-card-herclass-20260614 | 2026-06-14T08:39:54.215Z | |
| 3 | UZ | 2024 | 810 | card-herclass-2024-9005 | 810 | 9005 | 3995 | verwerkt | claude-card-herclass-20260614 | 2026-06-14T08:39:54.237Z | |
| 4 | UZ | 2025 | 810 | card-herclass-2025-4868 | 810 | 4868 | 155822 | 8822 | verwerkt | claude-card-herclass-20260614 | 2026-06-14T08:39:54.258Z |
| 5 | UZ | 2025 | 810 | card-herclass-2025-4610 | 810 | 4610 | 39853 | verwerkt | claude-card-herclass-20260614 | 2026-06-14T08:39:54.279Z | |
| 6 | UZ | 2025 | 810 | card-herclass-2025-9005 | 810 | 9005 | 6695 | 8824 | verwerkt | claude-card-herclass-20260614 | 2026-06-14T08:39:54.301Z |
| 7 | UZ | 2026 | 810 | card-herclass-2026-4868 | 810 | 4868 | 199277 | 8825 | verwerkt | claude-card-herclass-20260614 | 2026-06-14T08:39:54.322Z |
| 8 | UZ | 2026 | 810 | card-herclass-2026-4610 | 810 | 4610 | 7473 | 8826 | verwerkt | claude-card-herclass-20260614 | 2026-06-14T08:39:54.343Z |
Raw JSON details
Rij 1
{
"id": 1,
"bv_code": "UZ",
"boekjaar": 2024,
"account_no": "810",
"regel_key": "card-herclass-2024-4868",
"bron_account_no": "810",
"doel_account_no": "4868",
"bedrag_cents": 55293,
"correctie_entry_id": null,
"status": "verwerkt",
"actor": "claude-card-herclass-20260614",
"beslist_at": "2026-06-14T08:39:54.170Z"
}Rij 2
{
"id": 2,
"bv_code": "UZ",
"boekjaar": 2024,
"account_no": "810",
"regel_key": "card-herclass-2024-4610",
"bron_account_no": "810",
"doel_account_no": "4610",
"bedrag_cents": 15723,
"correctie_entry_id": null,
"status": "verwerkt",
"actor": "claude-card-herclass-20260614",
"beslist_at": "2026-06-14T08:39:54.215Z"
}Rij 3
{
"id": 3,
"bv_code": "UZ",
"boekjaar": 2024,
"account_no": "810",
"regel_key": "card-herclass-2024-9005",
"bron_account_no": "810",
"doel_account_no": "9005",
"bedrag_cents": 3995,
"correctie_entry_id": null,
"status": "verwerkt",
"actor": "claude-card-herclass-20260614",
"beslist_at": "2026-06-14T08:39:54.237Z"
}Rij 4
{
"id": 4,
"bv_code": "UZ",
"boekjaar": 2025,
"account_no": "810",
"regel_key": "card-herclass-2025-4868",
"bron_account_no": "810",
"doel_account_no": "4868",
"bedrag_cents": 155822,
"correctie_entry_id": 8822,
"status": "verwerkt",
"actor": "claude-card-herclass-20260614",
"beslist_at": "2026-06-14T08:39:54.258Z"
}Rij 5
{
"id": 5,
"bv_code": "UZ",
"boekjaar": 2025,
"account_no": "810",
"regel_key": "card-herclass-2025-4610",
"bron_account_no": "810",
"doel_account_no": "4610",
"bedrag_cents": 39853,
"correctie_entry_id": null,
"status": "verwerkt",
"actor": "claude-card-herclass-20260614",
"beslist_at": "2026-06-14T08:39:54.279Z"
}Rij 6
{
"id": 6,
"bv_code": "UZ",
"boekjaar": 2025,
"account_no": "810",
"regel_key": "card-herclass-2025-9005",
"bron_account_no": "810",
"doel_account_no": "9005",
"bedrag_cents": 6695,
"correctie_entry_id": 8824,
"status": "verwerkt",
"actor": "claude-card-herclass-20260614",
"beslist_at": "2026-06-14T08:39:54.301Z"
}Rij 7
{
"id": 7,
"bv_code": "UZ",
"boekjaar": 2026,
"account_no": "810",
"regel_key": "card-herclass-2026-4868",
"bron_account_no": "810",
"doel_account_no": "4868",
"bedrag_cents": 199277,
"correctie_entry_id": 8825,
"status": "verwerkt",
"actor": "claude-card-herclass-20260614",
"beslist_at": "2026-06-14T08:39:54.322Z"
}Rij 8
{
"id": 8,
"bv_code": "UZ",
"boekjaar": 2026,
"account_no": "810",
"regel_key": "card-herclass-2026-4610",
"bron_account_no": "810",
"doel_account_no": "4610",
"bedrag_cents": 7473,
"correctie_entry_id": 8826,
"status": "verwerkt",
"actor": "claude-card-herclass-20260614",
"beslist_at": "2026-06-14T08:39:54.343Z"
}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) |