← Back to List

BigSQL

Context

At OpenSCG, I helped conceptualize and led the design on their product, BigSQL - a web based database management and monitoring tool.

The product attempts to address several gaps in the postgres ecosystem:

  • The lack of a streamlined package management solution for postgres and the products in its ecosystem (like npm for nodejs)
  • No open-source one-click installer solution for postgres and its extensions
  • No GUI for managing multi-host postgres installations

Engagement

The role included contributing to the overall product strategy and vision, co-ordinating and planning the UX process – interaction design, visual design and working closely with the engineering team during product execution and managing the direction of the product and changes thereof.

Key Activities

  • Requirements Gathering
  • Persona & User stories creation
  • Stakeholder Interviews / discussions / workshops
  • Curating ideation workshops to develop Information Architecture
  • Wireframing & use flows with Sketch & Invision
  • Design Iterations
  • HTML Prototype
  • Interaction specifications

Challenges

  • High entropy in day-to-day activities
  • Fighting the engineering mindset
  • Focusing team on User Centered development
  • Continually shifting business & technical requirements
User Persona DB Architect

User Persona DB Architect

Lo fidelity wireframe

Lo fidelity wireframe

Hi fidelity wireframe / prototype

Hi fidelity wireframe / prototype