sync-config.yaml

config:
  edition: 2

streams:
  books:
    auto_subscribe: true
    query: |
      SELECT
        book_id AS id,
        owner_user_id::text AS owner_user_id,
        title,
        subtitle,
        author,
        co_authors::text AS co_authors,
        isbn,
        isbn13,
        publisher,
        language,
        page_count,
        description,
        cover_image_url,
        file_media_id::text AS file_media_id,
        cover_media_id::text AS cover_media_id,
        reading_status,
        current_page,
        current_position,
        current_cfi,
        is_favorite,
        rating,
        custom_metadata::text AS custom_metadata,
        added_at::text AS added_at,
        updated_at::text AS updated_at,
        publication_date::text AS publication_date,
        file_format,
        file_size,
        file_hash,
        is_physical,
        physical_location,
        lent_to,
        lent_at::text AS lent_at,
        series_id,
        series_name,
        series_number,
        started_at::text AS started_at,
        completed_at::text AS completed_at,
        last_read_at::text AS last_read_at
      FROM books
      WHERE owner_user_id::text = auth.user_id()

  shelves:
    auto_subscribe: true
    query: |
      SELECT
        shelf_id AS id,
        name,
        description,
        color_hex,
        icon_code_point,
        icon_font_family,
        icon_font_package,
        icon_match_text_direction,
        parent_shelf_id::text AS parent_shelf_id,
        is_smart,
        smart_query,
        sort_order,
        created_at::text AS created_at,
        updated_at::text AS updated_at,
        owner_user_id::text AS owner_user_id
      FROM shelves
      WHERE owner_user_id::text = auth.user_id()

  tags:
    auto_subscribe: true
    query: |
      SELECT
        tag_id AS id,
        name,
        color_hex,
        description,
        created_at::text AS created_at,
        updated_at::text AS updated_at,
        owner_user_id::text AS owner_user_id
      FROM tags
      WHERE owner_user_id::text = auth.user_id()

  notes:
    auto_subscribe: true
    query: |
      SELECT
        note_id AS id,
        book_id::text AS book_id,
        title,
        content,
        location::text AS location,
        tags::text AS tags,
        is_pinned,
        created_at::text AS created_at,
        updated_at::text AS updated_at,
        owner_user_id::text AS owner_user_id
      FROM notes
      WHERE owner_user_id::text = auth.user_id()

  annotations:
    auto_subscribe: true
    query: |
      SELECT
        annotation_id AS id,
        book_id::text AS book_id,
        selected_text,
        color,
        location::text AS location,
        note,
        created_at::text AS created_at,
        updated_at::text AS updated_at,
        owner_user_id::text AS owner_user_id
      FROM annotations
      WHERE owner_user_id::text = auth.user_id()

  bookmarks:
    auto_subscribe: true
    query: |
      SELECT
        bookmark_id AS id,
        reader_locator::text AS reader_locator,
        book_id::text AS book_id,
        position,
        page_number,
        chapter_title,
        note,
        color_hex,
        created_at::text AS created_at,
        updated_at::text AS updated_at,
        owner_user_id::text AS owner_user_id
      FROM bookmarks
      WHERE owner_user_id::text = auth.user_id()

  book_shelves:
    auto_subscribe: true
    query: |
      SELECT
        id,
        book_id::text AS book_id,
        shelf_id::text AS shelf_id,
        added_at::text AS added_at,
        sort_order,
        owner_user_id::text AS owner_user_id
      FROM book_shelves
      WHERE owner_user_id::text = auth.user_id()

  book_tags:
    auto_subscribe: true
    query: |
      SELECT
        id,
        book_id::text AS book_id,
        tag_id::text AS tag_id,
        created_at::text AS created_at,
        owner_user_id::text AS owner_user_id
      FROM book_tags
      WHERE owner_user_id::text = auth.user_id()

  demo_items:
    auto_subscribe: true
    query: |
      SELECT
        item_id AS id,
        owner_user_id::text AS owner_user_id,
        title,
        notes,
        created_at::text AS created_at,
        updated_at::text AS updated_at
      FROM powersync_demo_items
      WHERE owner_user_id::text = auth.user_id()

  reading_goals:
    auto_subscribe: true
    query: |
      SELECT id, owner_user_id::text AS owner_user_id, payload::text AS payload,
        created_at::text AS created_at, updated_at::text AS updated_at
      FROM reading_goals
      WHERE owner_user_id::text = auth.user_id()

  reading_activities:
    auto_subscribe: true
    query: |
      SELECT id, owner_user_id::text AS owner_user_id, payload::text AS payload,
        created_at::text AS created_at, updated_at::text AS updated_at
      FROM reading_activities
      WHERE owner_user_id::text = auth.user_id()

  goal_periods:
    auto_subscribe: true
    query: |
      SELECT id, owner_user_id::text AS owner_user_id, payload::text AS payload,
        created_at::text AS created_at, updated_at::text AS updated_at
      FROM goal_periods
      WHERE owner_user_id::text = auth.user_id()

  reading_timers:
    auto_subscribe: true
    query: |
      SELECT id, owner_user_id::text AS owner_user_id, payload::text AS payload,
        status, base_version, created_at::text AS created_at, updated_at::text AS updated_at
      FROM reading_timers
      WHERE owner_user_id::text = auth.user_id()