@the-vcsi/openalex

Populate your database with OpenAlex author and paper data.

Installation

You'll be prompted for your email (required by the OpenAlex API). The add-on creates:

  • scripts/populate-openalex-db.js — Database population script
  • Appends author/paper tables to src/lib/server/db/schema.ts

If Drizzle isn't already installed, it will be added automatically.

Usage

After installation, populate the database:

This fetches author and publication data from the OpenAlex API and stores it in your local SQLite database via Drizzle ORM.