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

# ETL: Integrate.io MCP Server Creating Connections

> How an AI assistant creates an Integrate.io ETL connection through a one-time connection link, without ever handling the password or key.

An AI assistant connected to the Integrate.io MCP Server can set up a new connection without ever seeing its password or key. The assistant asks for a **connection link**: a one-time dashboard link that opens the normal **New connection** panel. You sign in, type the secret there and click **Create**. The assistant only learns the new connection's ID, which it can then use, for example to build a package.

## How it works

**1. The assistant checks what it can create**

It calls `list_connection_types` to see which connection types support links and which non-secret fields it may fill in for you (name, host, port, database, user name, and so on).

**2. The assistant creates a link**

It calls `create_connection_link` with the connection type, the fields it knows, and an optional note about what the connection is for. It gets back a link to share with you.

**3. You open the link and sign in**

The link opens the dashboard. Sign in as the **same Integrate.io user** the assistant is connected as, and finish signing in in the same browser tab.

**4. You confirm where the credential goes**

If the assistant filled in a host, the page shows what it requested first. Choose **This is my server, continue** to keep it, or **Continue without the host** to type your own. The note from the assistant is shown as unverified text.

**5. You fill in the connection and click Create Connection**

The page opens the same **New connection** panel as **Connections → New Connection**, with the assistant's fields already filled in. Choose the **Access type** (direct, SSH tunnel or reverse SSH tunnel), enter the password or key, optionally test the connection, and click **Create Connection**.

**6. The assistant picks up the new connection**

The assistant calls `get_connection_link_status` until the status is `completed`, then uses the returned connection ID.

> [!NOTE]
>
> The password or key you type goes straight from the dashboard to Integrate.io, the same as creating a connection by hand. It never appears in a tool argument, a tool result, the link URL, or the assistant's conversation.

## Supported connection types

| Type | `type` value | Fields the assistant may fill in | You enter |
| - | - | - | - |
| PostgreSQL | `postgres` | name, host, port, database, username, ssl, schema | Password, access type |
| MySQL | `mysql` | name, host, port, database, username, ssl, schema | Password, access type |
| Amazon Redshift | `redshift` | name, host, port, database, username, ssl, schema, region | Password, access type |
| Microsoft SQL Server | `sqlserver` | name, host, port, database, username, ssl, schema | Password, access type |
| Amazon S3 | `s3` | name, region | Access key ID and secret key |
| SFTP | `sftp` | name, host, port, username | Password or key authentication, access type |
| FTPS | `ftps` | name, host, port, username | Password |

`list_connection_types` returns the current list for your account, along with notes to pass on to you (for example, allowlisting Integrate.io's IP addresses on your firewall). OAuth connections such as Salesforce or HubSpot can't be created through a link yet.

## Link lifetime

| Rule | Detail |
| - | - |
| Open within 30 minutes | The link must be opened within 30 minutes of being created (`expires_at`). |
| 30 more minutes to finish | Once you have opened the page in time, you have up to 30 more minutes to click **Create**, and you can reload the page during that time. While you do, the assistant sees `pending`. |
| Single use | A link creates one connection. Opening it again afterwards shows that it was already used, with a link to the connection it created. |
| Tied to one user | Only the user the assistant is connected as can open the link. |
| Same browser tab | If you have to sign in first, finish signing in in the tab you opened the link in. Otherwise ask the assistant for a new link. |

## Tunnels and key authentication

If you choose **SSH tunnel** or **Reverse SSH tunnel**, or key authentication for SFTP, the dashboard opens the new connection's edit page after you click **Create**, the same as in the normal flow, so you can copy the public key or tunnel details. A notification confirms whether the assistant was told about the connection. The connection only works once you have installed the public key on your server or started the tunnel. Tell the assistant when that is done.

## Tool reference

### list\_connection\_types

**Read-only.** Lists the connection types that can be created through a link, with the fields the assistant may fill in and notes for the user.

**type** `string`

Return a single entry, for example `postgres`. An unsupported type returns an error listing the supported ones.

**connection\_types** `array`

Each entry has `type`, `label`, `family` (`database` or `file_storage`), `prefill_fields`, and `notes`.

### create\_connection\_link

**Write.** Creates a one-time connection link for the signed-in user. Requires permission to create connections in the account. Supports `dry_run` (validates without creating a link) and `idempotency_key` (a retry with the same key returns the original link, even after it has lapsed; use a new key for a new link).

**type** `string` *required*

A type from `list_connection_types`, for example `mysql`.

**prefill** `object`

Only that type's `prefill_fields`. Any other key, a password or key, or a connection string (`scheme://user:password@host`) is rejected with an error naming the offending fields. `host` must be a bare hostname or IP address.

**purpose** `string`

Up to 200 characters, shown to the user on the page as an unverified note. Must not contain a connection string.

**link\_id** `string`

Pass this to `get_connection_link_status`. It can't be used to open the page.

**url** `string`

The link to share with the user.

**expires\_at** `string`

When the link stops opening (30 minutes after it was created).

**instructions** `string`

What to tell the user.

### get\_connection\_link\_status

**Read-only.** Reports the outcome of a link.

**link\_id** `string` *required*

The `link_id` returned by `create_connection_link`, never the URL.

**status** `string`

`pending` (the user has not finished yet, including up to 30 minutes past `expires_at` once the page has been opened), `completed`, or `expired` (the link lapsed or never existed; create a new one).

**connection\_id** `integer`

The new connection's ID, once `completed`. `connection_name`, `type`, `expires_at`, and `completed_at` are also returned.

## FAQ

**Q: Does the AI assistant ever see my database password?**

No. You type it on the Integrate.io dashboard page. The assistant only receives the new connection's ID and name.

**Q: The page says the link expired. What now?**

Ask the assistant for a new link. Links must be opened within 30 minutes of being created.

**Q: Can I change what the assistant filled in?**

Yes. Every field on the page can be edited before you click **Create Connection**, and you can drop an assistant-supplied host on the review step.

**Q: I opened the link in one tab and signed in from another. Why does it say the link is missing its token?**

The link only works in the tab it was opened in. Ask the assistant for a new link and finish signing in in that tab.

## Related

> [card] [MCP Server Overview](https://www.integrate.io/docs/etl/integrateio-mcp-server.md)

> [card] [Building & Editing Packages](https://www.integrate.io/docs/etl/creating-packages-with-mcp-tools.md)

> [card] [Reading & Inspecting](https://www.integrate.io/docs/etl/mcp-tools-reading.md)

> [card] [MCP Authentication](https://www.integrate.io/docs/etl/mcp-authentication.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.