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

# Connections Overview

> Create and test the database and SaaS connections currently supported by Arcyria.

Connections are reusable encrypted credentials. PostgreSQL, MySQL, MongoDB,
Airtable, ClickHouse, and DuckDB are Available Now as sources and destinations.
Stripe, HubSpot, GitHub, Asana, Linear, Notion, Zendesk, and Strapi are Available
Now as sources. Each connector retains the role and limitations documented below.

<Note>
  Available Now means owner-approved and code-supported. It is not an independent
  production certification. Automated evidence and pending manual UI validation
  are tracked separately in the engineering audit documents.
</Note>

## Current live connectors

| Role        | Connector  | Status                                                                             |
| ----------- | ---------- | ---------------------------------------------------------------------------------- |
| Source      | PostgreSQL | Available Now                                                                      |
| Source      | MySQL      | Available Now                                                                      |
| Source      | MongoDB    | Available Now; dynamic collection discovery with Full Table and Incremental sync   |
| Source      | Airtable   | Available Now                                                                      |
| Source      | ClickHouse | Available Now                                                                      |
| Source      | DuckDB     | Available Now; requires a managed file reference                                   |
| Source      | Asana      | Available Now                                                                      |
| Source      | Linear     | Available Now                                                                      |
| Source      | Notion     | Available Now                                                                      |
| Source      | GitHub     | Available Now; Personal Access Token and one GitHub.com repository per connection  |
| Source      | Zendesk    | Available Now; OAuth required                                                      |
| Source      | Strapi     | Available Now; Strapi 5 and Full Table only                                        |
| Source      | HubSpot    | Available Now                                                                      |
| Source      | Stripe     | Available Now                                                                      |
| Destination | PostgreSQL | Available Now                                                                      |
| Destination | MySQL      | Available Now                                                                      |
| Destination | MongoDB    | Available Now; key-required Upsert delivery                                        |
| Destination | Airtable   | Available Now                                                                      |
| Destination | ClickHouse | Available Now                                                                      |
| Destination | DuckDB     | Available Now; managed artifact, write lease, and expected-version checks required |

Other connector tiles may appear in the catalog, but they are not available
until their create, test, save, pipeline, and run path is enabled in the app.

See [Airtable source](/connections/sources/productivity/airtable) and
[Airtable destination](/connections/destinations/airtable) for Personal Access
Token scopes, base/table discovery, field mapping, and Upsert behavior. See
[MySQL source](/connections/sources/database/mysql) and
[MySQL destination](/connections/destinations/mysql) for database grants,
table contracts, sync modes, and verification queries.

See [MongoDB source](/connections/sources/database/mongodb) and
[MongoDB destination](/connections/destinations/mongodb) for encrypted URI
setup, collection discovery, inferred schemas, BSON handling, Incremental
cursors, and key-required Upsert delivery. The
[MongoDB and PostgreSQL example](/example/pipelines/mongodb-and-postgresql)
records the three currently verified real data-movement paths.

See [ClickHouse source](/connections/sources/database/clickhouse) and
[ClickHouse destination](/connections/destinations/clickhouse) for HTTP and
native port handling, the `clickhousedb` SQLAlchemy dialect, MergeTree
destination tables, and cross-connector setup. See the
[ClickHouse and MySQL pipeline example](/example/pipelines/clickhouse-and-mysql)
for the validated cross-connector matrix.

See [DuckDB source](/connections/sources/database/duckdb) and
[DuckDB destination](/connections/destinations/duckdb) for the managed
`file_...` reference contract, read-only source behavior, direct Upsert into
pre-existing tables, write leasing, and optimistic version checks.

See [HubSpot source](/connections/sources/crm/hubspot) for its ten supported
streams, private app token setup, UTC extraction window, and PostgreSQL
requirements. See [Stripe source](/connections/sources/finance/stripe) for its
34 supported streams, authentication, sync modes, and empty-stream behavior.
See [Asana source](/connections/sources/productivity/asana) for PAT setup,
workspace/project scope, eight streams, task incremental behavior, and current
limitations.

See [Notion source](/connections/sources/productivity/notion) for integration
sharing, data-source discovery, dlt-backed Full Table and Incremental behavior,
stable staging names, and API safety limits.

See [Linear source](/connections/sources/productivity/linear) for Personal API
Key setup, team/project scope, eight resources, `updatedAt` incremental
behavior, and current limitations.

See [GitHub source](/connections/sources/developer-tools/github) for Personal
Access Token setup, repository permissions, 12 discoverable resources,
Full Table behavior, pagination safety, and limitations.

See [Zendesk source](/connections/sources/customer-support/zendesk) for
read-only OAuth, 13 Support resources, historical extraction windows,
incremental ticket and event behavior, and reconnect guidance.

See [Strapi source](/connections/sources/cms/strapi) for read-only API-token
setup, dynamic Content API IDs, hosted URL restrictions, Strapi 5 response
handling, and Full Table limitations.

## Create a source connection

1. Open **Connections**.
2. Click **+ New Connection**.
3. Set the role to **Source**.
4. Choose **PostgreSQL**, **MySQL**, **MongoDB**, **Airtable**, **ClickHouse**, **DuckDB**, **Asana**, **Linear**, **Notion**, **GitHub**, **Zendesk**, **Strapi**, **HubSpot**, or **Stripe**.
5. Fill the connector-specific fields. Airtable and Asana use Personal Access
   Tokens; Linear uses a Personal API Key; Notion uses an internal integration
   token; GitHub uses a Personal Access Token; Zendesk uses OAuth; Strapi uses a read-only API token; HubSpot uses a
   private app access token.
6. Click **Test Connection**.
7. Save after the test succeeds.

## Create a destination connection

1. Open **Connections**.
2. Click **+ New Connection**.
3. Set the role to **Destination**.
4. Choose **PostgreSQL**, **MySQL**, **MongoDB**, **Airtable**, **ClickHouse**, or **DuckDB**.
5. Fill the destination database credentials.
6. Click **Test Connection**.
7. Save after the test succeeds.

Database destination users need write access to existing tables or MongoDB
collections and permission to create or reconcile targets only when the
connector contract permits it.
Airtable destinations need an existing base/table, writable mapped fields, and
record read/write access.

## Network access

If your database is hosted behind a provider firewall, allow traffic from the Arcyria runtime before testing the connection. See [Private database access](/connections/private-database-access).