Database access via GUI

fortrabbit requires database connections via SSH tunnel. All MySQL clients support this configuration, typically through a dedicated SSH tunnel tab. These general instructions may apply for Workbench, Sequel Ace and TablePlus.

• SSH part
  • SSH Host: ssh.{{region}}.frbit.app
  • SSH User: {{app-env-id}}
  • SSH Keyfile: Your local SSH private key
• MySQL part
  • MySQL Host: mysql
  • MySQL Server Port: 3306
  • Username: {{app-env-id}}
  • Password: Look it up in the dashboard
  • Default Schema: {{app-env-id}}

# Next steps

• Database up via GUI
• Database down via GUI

# Troubleshooting

The most common issues setting up the remote connection via database GUI are:

• Using no tunnel. Connect via SSH tunnel.
• Using localhost. Hostname is mysql.

# Why use a database GUI at all?

Using a database graphical user interface has many benefits Visually browse and edit the database, get hints running queries, save connection details as bookmarks. It's also practical to have the client connect to the remote and to the local database.

# Database GUI clients

• Sequel Ace recommended only for macOS, free, good.
• MySQL Workbench
• HeidiSQL
• TablePlus