> ## Documentation Index
> Fetch the complete documentation index at: https://developers.learn.ink/llms.txt
> Use this file to discover all available pages before exploring further.

# Overview

> Stream your LearnInk data to a dedicated Postgres database for analysis

LearnInk Data Sync provisions a dedicated, read-only Postgres database containing your organisation’s learning data. It’s designed for analytics: connect it to your BI tooling, query it with SQL, or join it with data from other systems.

This is the right integration if you want to:

* Build custom dashboards in tools like Looker, Metabase, or Tableau
* Join LearnInk learning data with other datasets (e.g. sales performance, HR)
* Run ad-hoc SQL queries for analysis and reporting

***

## What you get

* A dedicated **read-only Postgres database** for your organisation
* **Daily refresh** (typically around midnight UTC)
* Optionally, a **Metabase instance** connected to your Data Sync database for instant access to dashboards and custom report generation

***

## Getting access

Email [support@learn.ink](mailto:support@learn.ink) to provision Data Sync.

Before access can be granted, you’ll need to provide an **IP allowlist** (the IPs permitted to connect). If you’re using a hosted BI tool, include the BI provider’s egress IPs too.

Once provisioned, we’ll share your read-only connection details via a secure mechanism.

***

## Database structure

The database contains tables covering users, courses, learning paths, learing performance data (completion times, scores etc.), and survey responses. We’ll provide a full schema reference and sample queries once your database has been provisioned.

***

## A note on timestamps

<Warning>
  **Offline mode:** If a user completes courses in offline mode, their progress data is saved with the timestamp of when the activity occurred — not when it synced to the database. This means historical figures (e.g. completions last week) can change as users come back online.
</Warning>