How to create a database diagrams in visual studio code?

Question

I am trying Visual studio code to code the database but I cannot create the database diagram. Is there a way I can create it just like in SSMS. Thank you.

Solution

1. Install the ERD Editor extension from https://marketplace.visualstudio.com/items?itemName=dineug.vuerd-vscode

2. Create a file with the extension .vuerd.json, e.g. somedb.vuerd.json

3. Click the Open ERD Editor icon at the top right:

Comments

[Parth Shah]

Check this extension out.

[Utsav Barnwal]

It is really awesome. Apart from supporting multiple databases and giving export options it also generates entity types.