search

mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.43k stars 290 forks source link

ERD diagram #1304

Open windmillcode0 opened 3 months ago

windmillcode0 commented 3 months ago

Is your feature request related to a problem? Please describe. More of an inconvenience how easy would it to create an ERD diagram

Describe the solution you'd like ERD diagram support

Describe alternatives you've considered DBeaver was a comprehensive tool but lacked ERD diagram support

Additional context I cant believe no one reach out about this earlier we will make a PR and work on it

windmillcode0 commented 3 months ago

If you can show us the files responsible for pulling all the schema entities (SELECT * FROM Information_Schema` that would work

george-james-software commented 2 months ago

I think ERD support would be really useful. Do you have some thoughts on how you would achive this? Is there something pre-built that does the heavy lifting? What did you have in mind?

windmillcode0 commented 2 months ago

were using https://www.npmjs.com/package/@dineug/erd-editor for the ERD diagram So far were able to run the main extension in extension developer but if we can get the pluging that will work wonders. We would want the diagram to optionally include the schema the entity is coming from since right now we have a cross schema db