This script is currently in progress.

<aside> 💡 This command assumes that the enviroment variable NOTION_API_KEY contains your integration key. Please set this environment variable before execution.

# bash, zsh
export NOTION_API_KEY=secret_..........

# fish
set -gx NOTION_API_KEY secret_.......

</aside>

How to use

erdToNotionDb.rb creates Notion databases from ER diagrams in mermaid code block. At first, you invite your integration to your pages

• a page including the mermaid code block,
• a page for creating or updating databases.

After inviting, please type command as follows.

# Pattern1: use id
erdToNotionDb.rb code_block_id page_id --inline
Example:
  erdToNotionDb.rb e6e0e92965f046e7b383fac6dea4590f 87e5e52a6b9f46abbdeebcb3c902a516 --inline

# Pattern2: use url (needs "")
  erdToNotionDb.rb "<https://www.notion.so/hkob/erdToNotionDb-sample-87e5e52a6b9f46abbdeebcb3c902a516#e6e0e92965f046e7b383fac6dea4590f>" "<https://www.notion.so/hkob/erdToNotionDb-sample-87e5e52a6b9f46abbdeebcb3c902a516>" --inline

Format of ER diagram for creating Notion database

1. Database title

• The first line is erDiagram
• In Notion databases, titles often include non-ASCII characters such as spaces, symbols, and CJK characters. To ensure accuracy, please use keywords for Mermaid database titles.
• Instead, enter the Database title in the comment field of the attribute.
• The title property is required in the Notion database. Please make sure to provide one.

If you run the script in this state, it will be like this.

erDiagram
  db1 {
    Database title "Task database"
    title Name
  }

<aside> ⚒️ Created database

</aside>

2. Update database

• If there is already corresponding database on the page, it will be updated.
• The title can only exist once in the database, so it will change if it is rewritten.