# HeidiSQL — TechHeck local connection

Settings live next to HeidiSQL:

- `C:\Users\User\AppData\Local\Programs\HeidiSQL\techheck-local.settings.json`
- `C:\Users\User\AppData\Local\Programs\HeidiSQL\techheck-local-settings.md`
- `C:\Users\User\AppData\Local\Programs\HeidiSQL\Open-TechHeck.ps1`

| Setting | Value |
| --- | --- |
| Network type | `MariaDB or MySQL (TCP/IP)` |
| Hostname / IP | `127.0.0.1` |
| User | `techheck` |
| Password | same as `DB_PASSWORD` in `.env` |
| Port | `3307` |
| Database | `techheck` |

```powershell
powershell -ExecutionPolicy Bypass -File "$env:LOCALAPPDATA\Programs\HeidiSQL\Open-TechHeck.ps1"
```

Tables to open after connect:

- `admin_users`
- `admin_sessions`
- `contact_messages` (site API)