Connections
A Connection in Mycorr is a saved set of credentials for an external data source — a PostgreSQL database, a Supabase project, a Google account, a cloud storage bucket. You create a Connection once and reuse it across as many Models as you like.
You manage Connections from Settings → Connections, or create new ones inline from the Import panel inside a Model.
How Connections work
- Saved once, reused everywhere. Connect to your Postgres once and every Model in your account can import tables from it without re-entering credentials.
- Encrypted at rest. Passwords and tokens are encrypted with AES-256-GCM. Mycorr's server cannot read them back as plaintext after storage — only decrypt them in memory at the moment a query runs.
- Owner-scoped. A Connection belongs to the user who created it. Other team members cannot see your saved credentials, even if they share a Model with you.
- Read-only in practice. Mycorr's import code only ever reads:
SELECTon Postgres / Supabase,storage.objectVieweron buckets, and Drive picker-selected files on Google. (The Googledrive.filescope is technically read-write because that's the only Google API for picker-selected files — Mycorr only reads.) - Revocable from your side. Removing access in Postgres, GCP, or Google immediately stops Mycorr from being able to read — the next refresh fails cleanly with a permission error.
Supported connection types
| Type | Use it for | Setup |
|---|---|---|
| Google account | Importing Google Sheets | Google Sheets |
| PostgreSQL | RDS, self-hosted, Heroku, anything Postgres-wire-compatible | PostgreSQL |
| Supabase | A Supabase project (same as Postgres, with helpers for pooler URLs) | Supabase |
| Cloud Storage Bucket | Importing CSV / TSV / Parquet from GCS (S3 + Azure coming) | Cloud Storage Buckets |
Editing and revoking
From Settings → Connections you can:
- Rename a connection (the identity fields — host, database, username — are immutable; rotate the password by editing it).
- Replace the password / CA certificate without recreating the connection.
- Delete a connection. Any tables previously imported through it stay in Mycorr (the data is yours) but can no longer be refreshed — re-create the connection to resume syncing.
What's next
Pick the type you want to set up: