sqlant
sqlant copied to clipboard
kurotych
Generate PlantUML/Mermaid ER diagram textual description from SQL connection string
Copy of https://github.com/achiku/planter/issues/24 >For large schemas, it would be useful to generate the ERD without the list of columns to just show the relationships. Perhaps with an additional option to...
If columns aren't PK but have Index we can show it. SQL query is ready https://github.com/kurotych/sqlant/blob/main/src/psql_erd_loader.rs#L56
It would be nice to have a legend for the terms used, or some optional way to supply a legend. e.g. ```plantuml legend right | |= __Legend__ | | (PK)...
TODO: - Fix clippy, refactor(?) https://github.com/kurotych/sqlant/issues/13 
- Works well as svg reader - install from debian repository - open source - plugin support - Simple open command: `inkscape sql.svg` Think about full automation 
~~use `object` keyword for such~~ UPD: `hide empty members` should fix the problem + remove '---' from template if no PKs https://github.com/plantuml/plantuml/issues/1304 STR: ``` @startuml hide circle skinparam linetype ortho...
Remove `skinparam linetype ortho` to make it work properly Also add next use case: Teble 2 has two FKs to Table B https://forum.plantuml.net/3636 Example ``` @startuml hide circle !include https://raw.githubusercontent.com/kurotych/sqlant/b2e5db9ed8659f281208a687a344b34ff38129cd/puml-lib/db_ent.puml...