esquel

从 SQL 脚本创建 mermaid 图表。

USAGE:
    esquel [OPTIONS] --input <INPUT>

OPTIONS:
    -d, --dialect <DIALECT>    [default: generic] [possible values: ansi, clickhouse, generic, hive,
                               mssql, mysql, postgres, sqlite, snowflake]
    -f, --flow <FLOW>          Direction of the flowchart [default: tb] [possible values: tb, bt,
                               rl, lr]
    -h, --help                 Print help information
    -i, --input <INPUT>        Path to sql script or raw sql
        --no-icons             Do not show icons
    -o, --out <OUT>            Path to output file
    -V, --version              Print version information

使用所有 CREATE、INSERT、DELETE 和 UPDATE 语句，这些语句引用其他表。

示例

以下 SQL 脚本

create table foo as
select * from bar;

create view baz as
select * from foo
inner join qux;

delete from foo
where exists (
  select 1 from qux
  where qux.foo_id = foo.foo_id
);

生成此流程图

graph TB
    A[bar]
    B[fa:fa-eye baz]
    C[fa:fa-table foo]
    D[qux]
    A --> C
    C --> B
    D --> B
    D --> C

安装

cargo install esquel