Access database via a client tool

You can use a database client to access your database. We recommend TablePlus as it is compatible with all database types and versions Cleavr offers.

  • Host: 127.0.0.1 (you may also need to enter a port number based on the db type)
  • User: db username
  • Password: db password
  • Server: server ip address
  • User: cleavr
  • Use SSH key and point to public key on your machine - make sure you add your public key to Cleavr first

When installing databases, Cleavr locks down root access to external client tools. This is for security. To access using a client tool, make sure you have added a database user and password and use those credentials for external clients. Also, during provisioning, Cleavr creates a 'cleavr' user on the server which is not granted database access. This is also for security reasons.