Need help with planter?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

achiku
428 Stars 33 Forks MIT License 42 Commits 3 Opened issues

Description

Generate PlantUML ER diagram textual description from PostgreSQL tables

Services available

!
?

Need anything else?

Contributors list

# 144,923
Go
SQL
plantum...
Amazon ...
11 commits
# 204,301
nagios
Erlang
Elixir
D
10 commits
# 60,496
golang
kafka
Shell
Scala
3 commits
# 3,805
viml
golang
ag
q
2 commits
# 249,888
Shell
plantum...
login-s...
JavaScr...
1 commit

planter

test GitHub license Go Report Card

Generate PlantUML ER diagram textual description from PostgreSQL tables

Why created

A team with only software engineers doesn't need ER diagram that much as long as they have decent experience in Relational Database modeling. However, it becomes very helpful to have always-up-to-date ER diagram when marketing/promotion/operation teams consisting of those who are fluent in writing/reading SQL, join to the game.

PlantUML supports ER diagram in the latest version with this awesome pull request. The tool, planter, generates textual description of PlantUML ER diagram from pre-existing PostgreSQL tables, and makes it easy to share visual structure of relations with other teams.

Installation

go get -u github.com/achiku/planter

Quick Start

$ planter postgres://[email protected]/planter?sslmode=disable -o example.uml
$ java -jar plantuml.jar -verbose example.uml

er diagram

Specify table names

planter postgres://[email protected]/planter?sslmode=disable \ 
    -t order_detail \
    -t sku \
    -t product

Help

$ planter --help
usage: planter [] 

Flags: --help Show context-sensitive help (also try --help-long and --help-man). -s, --schema="public" PostgreSQL schema name -o, --output=OUTPUT output file path -t, --table=TABLE ... target tables -x, --exclude=EXCLUDE ... target tables -T, --title=TITLE Diagram title

Args: PostgreSQL connection string in URL format

Test

setup database.

create database planter;
create user planter;

run

go test ./... -v

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.