SqlDBM

Product design lead

SqlDBM is a database modelling tool. It allows users to visualise SQL scripts and create database diagrams using a graphical editor. Users can also compare revisions to see who made changes, create database documentation, comment on entities and integrate with other services such as Confluence, Jira, Git etc.

Research & documentation

Product design

I designed various features for databases, including object support for sequences, views and functions, integration with Confluence, Git, Open API, data governance. As a non-professional database developer, I studied documentation and communicated extensively with experts and developers. I tested the user experience by inviting users to participate.

Feature examples

Users wanted to be able to communicate with each other, leave comments and receive notifications without leaving the editor. To solve these tasks, I reviewed several tools such as Figma, Miro and also sorted out user expectations.

Comments

This feature allows users to see if the syntax of a particular option is incorrect. For example, if a user has created tables with the same name, or a key that does not reference any columns.

In order to implement this feature, competitors with similar functionality were analysed and all properties of database objects were analysed. The result is a list of errors that can occur in different cases for different supported databases.

Errors and warnings

That was a challenging assignment to create a palette that could be used in a dark and light theme. I managed to create a set of 32 colours.

Colors

Together with the design team we created a style guide that contains styles, colours, icons atomic and molecular components.

Components

Style guide