Skip to content
ch-kit Docs

Apps & integrations

The chkit app registry provides installable ClickHouse integrations with editable schemas, API readers, and sync pipelines.

Available integrations

Section titled “Available integrations”

Choose an app to see its setup guide, every resource it syncs, required permissions, and how data reaches ClickHouse. These integrations copy TypeScript source into the project, where the readers and schemas remain editable.

  • Attio

    9 resources · Full scans · TypeScript

    v0.2.0

    Editable Attio CRM schemas, raw data readers, typed views, and independent streams for People, Companies, configured custom types, and workspace resources.

    • Objects
    • Object attributes
    • Records
    • Lists
    • List attributes
    • List entries
    • Notes
    • Tasks
    • Workspace members

    Bearer token · 3 derived views

    bunx chkit add attio
    Integrating ClickHouse with Attio

  • Circleback

    1 resources · Full scans · TypeScript

    v0.2.0

    Editable Circleback full scan cycles with bounded parent recovery and durable transcript availability diagnostics.

    • Meetings

    Bearer API key · 0 derived views

    bunx chkit add circleback
    Integrating ClickHouse with Circleback

  • GitHub

    8 resources · Timestamp windows, Full scans · TypeScript

    v0.2.0

    Editable GitHub ingestion with independent issue, pull-request, discussion, review, commit, and stargazer streams and raw ClickHouse tables.

    • Issues
    • Issue comments
    • Pull requests
    • Pull request conversation comments
    • Pull request review comments
    • Pull request reviews
    • Pull request commits
    • Stargazers

    Bearer token · 0 derived views

    bunx chkit add github
    Integrating ClickHouse with GitHub

  • Google Meet

    3 resources · Cursor checkpoints · TypeScript

    v0.2.0

    Editable Google Meet API ingestion with journaled checkpoints and raw ClickHouse tables.

    • Conferences
    • Transcripts
    • Transcript entries

    OAuth access token · 0 derived views

    bunx chkit add google-meet
    Integrating ClickHouse with Google Meet

  • Lemlist

    2 resources · Timestamp windows, Full scans · TypeScript

    v0.2.0

    Editable Lemlist ingestion with resumable activity date intervals and full campaign scans.

    • Activities
    • Campaigns

    HTTP Basic API key · 0 derived views

    bunx chkit add lemlist
    Integrating ClickHouse with Lemlist

  • Linear

    9 resources · Timestamp windows, Full scans · TypeScript

    v0.2.0

    Editable Linear ingestion with nine independent raw resource streams, overlapping update windows, and complete issue history.

    • Issues
    • Comments
    • Projects
    • Project updates
    • Cycles
    • Users
    • Teams
    • Issue relations
    • Issue history

    Personal API key · 0 derived views

    bunx chkit add linear
    Integrating ClickHouse with Linear

  • Slack

    3 resources · Full scans, Cursor checkpoints · TypeScript

    v0.2.0

    Editable raw Slack readers with resumable message ranges, retained thread work, and historical reconciliation.

    • Conversations
    • Users
    • Messages and thread replies

    Slack OAuth bearer token (user token recommended) · 0 derived views

    bunx chkit add slack
    Integrating ClickHouse with Slack

Find and install an app

Section titled “Find and install an app”

Browse the official GitHub registry from the CLI without a ClickHouse connection. This site renders the provider manifests during its build:

Terminal window
bunx chkit registry list
bunx chkit registry inspect attio
bunx chkit add attio --dry-run
bunx chkit add attio --with-tests

registry list --json exposes resource coverage and documentation links for scripts and agents. registry inspect includes API endpoints and scopes, destination tables, derived views, credential setup instructions, sync limitations, dependencies, and the files to install. --with-tests copies the app’s portable fixture tests alongside its source.

Installation adds source files, registers schemas and ingestion, and installs dependencies. Configure the app credentials and ClickHouse connection, then follow the integration guide to generate and review migrations before the first sync. Schedule recurring runs through cron, CI, or an existing scheduler.

What each integration guide covers

Section titled “What each integration guide covers”
  • Setup: requirements, where to create source-system credentials, authentication scopes, installation, schema migrations, and the first run.
  • Records: every included resource, its destination table, stored fields, and query views.
  • Sync behavior: discovery, pagination, retries, repeat runs, and failed runs.
  • Coverage limits: unsupported resources, deletion behavior, and permissions.
  • Customization: select resources, change projections, and operate the copied source.

Add another app

Section titled “Add another app”

Build readers for an API using the source authoring guide, then publish a registry item. Each app in the official catalog ships with its own integration guide; the catalog, CLI, and search metadata use the same registry manifest.

Section titled “Related pages”