ha-voice-control-mcp/DOCKER_SETUP.md

DBeaver — Database Connecties voor Homelab

PostgreSQL (homelab op Synology NAS)

Connection type: PostgreSQL

Instelling	Waarde
Host	192.168.1.211
Port	5433
Database	homelab
Username	mo
Password	(zie .env bestand)
SSL	disable (lokaal netwerk)

Schemas om te bekijken:

• dashboard — favorites, passwords, calendar_events, settings, file_index, photos, widgets

DBeaver stappen:

1. New Database Connection → PostgreSQL
2. Vul bovenstaande gegevens in
3. Test Connection → Finish
4. In Database Navigator: rechtermuis op Tables → Refresh

Neo4j (netwerk graph op Synology NAS)

Connection type: Neo4j (via Bolt)

Instelling	Waarde
URI	neo4j://192.168.1.211:49153
Browser UI	http://192.168.1.211:49154
Username	neo4j
Password	(zie .env bestand)

DBeaver stappen (vereist Neo4j JDBC driver):

1. New Database Connection → Neo4j
2. Vul URI, username, password in
3. Test Connection → Finish
4. Run queries zoals:

   MATCH (d:Device) RETURN d.ip, d.hostname, d.os_guess
   MATCH (d:Device)-[:HAS_PORT]->(p:Port) RETURN d.ip, p.number, p.service
   

Snelle setup via DBeaver CLI / Import

Je kunt ook deze .dbeaver-data-sources.json importeren:

{
  "folders": {},
  "connections": {
    "postgresql-homelab": {
      "provider": "postgresql",
      "driver": "postgresql-jdbc",
      "name": "Homelab PostgreSQL",
      "host": "192.168.1.211",
      "port": "5433",
      "database": "homelab",
      "user": "mo",
      "savePassword": true,
      "configurationType": "MANUAL",
      "properties": {
        "connectTimeout": "20"
      }
    },
    "neo4j-homelab": {
      "provider": "neo4j",
      "driver": "neo4j-jdbc",
      "name": "Homelab Neo4j",
      "url": "neo4j://192.168.1.211:49153",
      "user": "neo4j",
      "savePassword": true,
      "configurationType": "MANUAL"
    }
  }
}