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

# Managing connections

> Add and manage database connections in Tamery, including sync types, labels, and colors.

Connections live in one place so you can switch between databases and devices.

## Add a connection

<Steps>
  <Step title="Choose a database type">PostgreSQL, MySQL, MSSQL, or ClickHouse.</Step>

  <Step title="Enter a connection string">
    Paste your string and click **Test connection** to verify it before saving.
  </Step>

  <Step title="Name and configure">
    Set a name, a sync type (see below), and optionally a label and color. Click **Save**.
  </Step>
</Steps>

<Note>
  Tamery tests the connection before saving. If it fails, check the host, port, credentials, and
  database name.
</Note>

## Sync types

Sync type controls whether Tamery stores your password. Both options sync the connection across your devices.

<Tabs>
  <Tab title="Cloud (with password)">
    The full connection string, including the password, is encrypted with your per-user key and stored in the cloud. Available on every device with no re-entry.

    Good for dev and staging.
  </Tab>

  <Tab title="Cloud (without password)">
    Only metadata (host, port, database, username) is stored; the password is never uploaded. You enter it on each device.

    Good for production or when policy forbids storing passwords externally.
  </Tab>
</Tabs>

## Organizing

* **Labels** — tag connections (e.g. `production`, `staging`) to group and filter them.
* **Colors** — color-code environments.
* **Pinning** — pin frequently used connections to the top.

Change a connection's name, label, color, or sync type anytime from its settings.

## Supported databases

<CardGroup cols={2}>
  <Card title="PostgreSQL" icon="elephant" href="/connections/postgresql">
    Supabase, Neon, Railway, self-hosted.
  </Card>

  <Card title="MySQL" icon="dolphin" href="/connections/mysql">
    MySQL and MariaDB, including PlanetScale and Railway.
  </Card>

  <Card title="SQL Server" icon="microsoft" href="/connections/mssql">
    SQL Server and Azure SQL.
  </Card>

  <Card title="ClickHouse" icon="database" href="/connections/clickhouse">
    ClickHouse Cloud and self-hosted.
  </Card>
</CardGroup>