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.sqlite_stat1
Feitelijke read-only selectie. Grote waarden zijn afgekapt; gevoelige patronen worden gemaskeerd.
Read-only query
SELECT * FROM "sqlite_stat1" LIMIT 50 OFFSET 0
| tbl | idx | stat |
|---|---|---|
| journal_line | idx_journal_line_source_document | 38640 12880 |
| journal_line | idx_journal_line_reverses | 38640 744 |
| journal_line | idx_journal_line_account | 38640 136 |
| journal_line | idx_journal_line_vat | 38640 12880 1546 |
| journal_line | idx_journal_line_period | 38640 12880 137 |
| journal_line | sqlite_autoindex_journal_line_1 | 38640 4 1 |
| sales_invoice | idx_sales_invoice_source_document | 5 1 |
| sales_invoice | idx_sales_invoice_dossier | 5 2 |
| sales_invoice | idx_sales_invoice_status | 5 3 2 1 |
| sales_invoice | sqlite_autoindex_sales_invoice_2 | 5 3 1 |
| sales_invoice | sqlite_autoindex_sales_invoice_1 | 5 3 1 |
| journal_entry | idx_journal_entry_source_document | 12211 5 |
| journal_entry | sqlite_autoindex_journal_entry_2 | 12211 4071 1 |
| journal_entry | sqlite_autoindex_journal_entry_1 | 12211 4071 1 |
| grootboek_mutatie | idx_grootboek_mutatie_bv_acc | 39413 13138 1460 26 |
| draft_line | idx_draft_line_source_document | 1282 1282 |
| draft_line | idx_draft_line_batch | 1282 428 4 |
| draft_line | sqlite_autoindex_draft_line_1 | 1282 428 4 1 |
| bank_account | idx_bank_account_bv | 7 3 |
| bank_account | sqlite_autoindex_bank_account_1 | 7 1 |
| bank_transaction | idx_bank_transaction_iban_date | 6152 1231 3 |
| bank_transaction | sqlite_autoindex_bank_transaction_1 | 6152 1231 3 1 1 |
| rgs_account | sqlite_autoindex_rgs_account_2 | 632 211 1 |
| rgs_account | sqlite_autoindex_rgs_account_1 | 632 211 1 |
| source_document | idx_source_document_regie | 3754 1252 140 51 49 |
| source_document | sqlite_autoindex_source_document_1 | 3754 1252 1 |
| vat_declaration | sqlite_autoindex_vat_declaration_1 | 77 26 1 1 |
Raw JSON details
Rij 1
{
"tbl": "journal_line",
"idx": "idx_journal_line_source_document",
"stat": "38640 12880"
}Rij 2
{
"tbl": "journal_line",
"idx": "idx_journal_line_reverses",
"stat": "38640 744"
}Rij 3
{
"tbl": "journal_line",
"idx": "idx_journal_line_account",
"stat": "38640 136"
}Rij 4
{
"tbl": "journal_line",
"idx": "idx_journal_line_vat",
"stat": "38640 12880 1546"
}Rij 5
{
"tbl": "journal_line",
"idx": "idx_journal_line_period",
"stat": "38640 12880 137"
}Rij 6
{
"tbl": "journal_line",
"idx": "sqlite_autoindex_journal_line_1",
"stat": "38640 4 1"
}Rij 7
{
"tbl": "sales_invoice",
"idx": "idx_sales_invoice_source_document",
"stat": "5 1"
}Rij 8
{
"tbl": "sales_invoice",
"idx": "idx_sales_invoice_dossier",
"stat": "5 2"
}Rij 9
{
"tbl": "sales_invoice",
"idx": "idx_sales_invoice_status",
"stat": "5 3 2 1"
}Rij 10
{
"tbl": "sales_invoice",
"idx": "sqlite_autoindex_sales_invoice_2",
"stat": "5 3 1"
}Rij 11
{
"tbl": "sales_invoice",
"idx": "sqlite_autoindex_sales_invoice_1",
"stat": "5 3 1"
}Rij 12
{
"tbl": "journal_entry",
"idx": "idx_journal_entry_source_document",
"stat": "12211 5"
}Rij 13
{
"tbl": "journal_entry",
"idx": "sqlite_autoindex_journal_entry_2",
"stat": "12211 4071 1"
}Rij 14
{
"tbl": "journal_entry",
"idx": "sqlite_autoindex_journal_entry_1",
"stat": "12211 4071 1"
}Rij 15
{
"tbl": "grootboek_mutatie",
"idx": "idx_grootboek_mutatie_bv_acc",
"stat": "39413 13138 1460 26"
}Rij 16
{
"tbl": "draft_line",
"idx": "idx_draft_line_source_document",
"stat": "1282 1282"
}Rij 17
{
"tbl": "draft_line",
"idx": "idx_draft_line_batch",
"stat": "1282 428 4"
}Rij 18
{
"tbl": "draft_line",
"idx": "sqlite_autoindex_draft_line_1",
"stat": "1282 428 4 1"
}Rij 19
{
"tbl": "bank_account",
"idx": "idx_bank_account_bv",
"stat": "7 3"
}Rij 20
{
"tbl": "bank_account",
"idx": "sqlite_autoindex_bank_account_1",
"stat": "7 1"
}Rij 21
{
"tbl": "bank_transaction",
"idx": "idx_bank_transaction_iban_date",
"stat": "6152 1231 3"
}Rij 22
{
"tbl": "bank_transaction",
"idx": "sqlite_autoindex_bank_transaction_1",
"stat": "6152 1231 3 1 1"
}Rij 23
{
"tbl": "rgs_account",
"idx": "sqlite_autoindex_rgs_account_2",
"stat": "632 211 1"
}Rij 24
{
"tbl": "rgs_account",
"idx": "sqlite_autoindex_rgs_account_1",
"stat": "632 211 1"
}Rij 25
{
"tbl": "source_document",
"idx": "idx_source_document_regie",
"stat": "3754 1252 140 51 49"
}Rij 26
{
"tbl": "source_document",
"idx": "sqlite_autoindex_source_document_1",
"stat": "3754 1252 1"
}Rij 27
{
"tbl": "vat_declaration",
"idx": "sqlite_autoindex_vat_declaration_1",
"stat": "77 26 1 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) |