Table of contents

Use database GUI tools

Database GUI tools can be useful when developing applications and to understand the relationships between data. This document explains how to configure Sequel Pro for MySQL and PSequel for PostgreSQL inside the development VM.

Prerequisites

You should have set up the development VM and have replicated data. You’ll need to generate a ssh config to be able to connect to the VM via the standard ssh command rather than vagrant ssh:

cd ~/code/govuk-puppet/development-vm
vagrant ssh-config --host dev >> ~/.ssh/config

If you can connect to your VM with ssh dev this is working correctly.

Sequel Pro (for MySQL)

Install Sequel Pro in the normal way. Add a new connection with the following configuration:

Sequel Pro Config

There’s no need to set a key file. Vagrant already set this in your ~/.ssh/config. Test the connection and if it is successful, add it to favourites. It will now appear in the left-hand menu.

If you need to access other MySQL databases, you can duplicate the favourite, change the database and choose a different name.

PSequel (for Postgres)

Install PSequel in the normal way. Add a new connection with the following configuration:

PSequel Config

There’s no need to set an identity file. Vagrant already set this in your ~/.ssh/config.

This page was last reviewed . It needs to be reviewed again by the page owner #govuk-2ndline.