Skip to main content
Glama
fivetran

Fivetran MCP Server

Official
by fivetran

create_connection

Create a new connection within a Fivetran group, run setup tests, and retrieve testing results. Ensure to include the destination_schema_names field to prevent disruptions.

Instructions

⚠️ WRITE OPERATION - Confirm with user before calling. Creates a new connection within a specified group in your Fivetran account. Runs setup tests and returns testing results. > IMPORTANT: The destination_schema_names field will soon become a required field. Make sure to include it in your API requests when creating new connections to prevent future disruptions. > IMPORTANT: If you want to get the fingerprint details, do not set trust_fingerprints to true when you create a connection with our REST API. We can only provide the fingerprint details through the failed SSH Tunnel Connection setup test. For a full walkthrough, see Get Connection Fingerprint Details.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
schema_fileYesREQUIRED: You must first read the schema file at 'open-api-definitions/connections/create_connection.json', then provide this exact path here to confirm.
request_bodyYesJSON string containing the request body. Refer to the schema file for the expected structure.
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Without annotations, the description carries full burden. It clearly states it's a WRITE operation, runs setup tests, and returns testing results. It also warns about future required fields and fingerprint details limitations. This provides substantial behavioral context beyond what annotations would offer.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is reasonably concise, front-loading the critical warning about user confirmation. It uses bullet points for emphasis and includes necessary details without excessive verbosity. Slight redundancy could be trimmed, but still effective.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness3/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

No output schema exists, so the description should explain return values more thoroughly. It only says 'returns testing results' without specifying format or fields. Also missing prerequisites (e.g., existing group) and error handling. For a complex creation tool, this is a gap.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so baseline is 3. The description adds value by explaining that schema_file must be read from a specific path and that request_body is a JSON string. It also gives important notes about destination_schema_names and trust_fingerprints, which are not in the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the action ('Creates a new connection') and the resource ('within a specified group in your Fivetran account'), with a specific verb and resource. It distinguishes itself from sibling tools like modify_connection or delete_connection.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description includes a prominent warning to confirm with the user before calling, which is a key usage guideline. It also advises including the destination_schema_names field and setting trust_fingerprints appropriately. However, it does not explicitly compare with alternative tools for when not to use.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/fivetran/fivetran-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server