# marcboeker/gmail-to-sqlite

Index your Gmail account to a SQLite DB and play with the data.

Repository: https://github.com/marcboeker/gmail-to-sqlite
Canonical: https://ross.abutalabs.com/products/gmail-to-sqlite
Language: Python
License: MIT
License Family: permissive
Last push: 2026-02-13T23:58:51+00:00

## Health v2 (maintenance only)
Score: 56/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 67, release rhythm 35, longevity 69
- inputs: {"age_days": 976, "days_push": 201, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1221, forks 58 (observed 2026-08-28T04:04:02.112480+00:00)

## What it is
A Python CLI application that syncs Gmail messages into a local SQLite database, supporting incremental and full syncs with deletion detection. It enables local analysis and archival of your email data using the Gmail API with OAuth 2.0.

## Use cases
- back up my gmail to a local database
- analyze my email history with sql
- sync gmail messages to sqlite
- archive gmail emails locally for privacy
- detect deleted gmail messages
- query my email data offline

## When to choose
- you want a local, queryable copy of your Gmail for analysis or archival
- you need incremental syncing with deletion detection
- you prefer a simple Python CLI with parallel fetching

## When to avoid
- you need a full-featured email client or web UI
- you want a hosted backup service with no setup
- you're unwilling to create a Google Cloud project and OAuth credentials

## Facets
- artifact type: cli-tool
- maturity: active
- function: etl, database, cli, search-engine
- domain: email, developer-tools, privacy
- platform: python, cli, cross-platform
- tags: gmail, sqlite, email-archival, email-backup, data-analysis, oauth, data-engineering

## Member repositories
- marcboeker/gmail-to-sqlite (main) score 56

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:02.112480+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:15:42.088346+00:00, confidence not recorded.
  - readme: https://github.com/marcboeker/gmail-to-sqlite (fetched 2026-08-28T04:04:02.112480+00:00, sha c8bb204cbb13)
- Data as of 2026-08-30T08:39:29.467469+00:00.