notion2pg 0.1.0

Quick start

1. Create a Notion integration.

2. Share a Notion database with your integration, as well as related databases.

3. Create a PostgreSQL database e.g.:

   $ createuser notion
   $ createdb notion -O notion

4. Install notion2pg (requires Python ≥ 3.8):

   $ pip install notion2pg

5. Set Notion and PostgreSQL credentials as environment variables e.g.:

   $ export NOTION_TOKEN=secret_...
   $ export POSTGRESQL_DSN="dbname=notion user=notion"

6. Import your database e.g.:

   $ notion2pg <database_id> <table_name>

   where <database_id> can be found in the URL of your database — it’s a UUID like 858611286a7d43a197c7c0ddcc7d5a4f and <table_name> is any valid PostgreSQL table name.

Command line options

FAQ

Why is my relation or rollup field empty?

Your integration must have access not only to the table that you’re importing, but also to every table involved in a relation or a rollup.

Limitations

• The order of columns in the table isn’t preserved. This information isn’t available in the API of Notion.

• Rollups “Show original” and “Show unique values” are ignored. Import the related table and join it in your queries instead.

• Properties of type “people” are imported as the person ID, which is probably not the most useful representation.

• Every import is a full copy. Given that Notion’s API isn’t particularly fast, the practical limit is around 10,000 rows.

Changelog

0.1

• Initial public release.