# Database instances and logical databases.
---
- id: smart-home-mysql
  name: Smart Home MySQL
  engine: mysql
  status: active
  host: smart-home-server
  used_by:
    - smart-home-platform
  backup_policy: smart-home-nfs-backups
  listen:
    host: 127.0.0.1
    port: 3306
  related_service: smart-home-platform
  known_tables_from_dump:
    - areas
    - devices
    - device_auth
    - groups
    - logs
    - meta
    - notifications
    - scripts
    - user_sessions
    - users
  dump_location: /home/shome/smart-home-server/database_dump
  docs: ../10-systems/automations/smart-home-overview.md
  last_reviewed: 2026-05-10
  source_of_truth: ssh-host-file-layout