n8n


n8n


The CData Connect Cloud Remote MCP Service enables n8n to securely read and take action on your data in real time.

This page outlines the steps to install and configure the CData Connect Cloud connector for n8n. After installation, n8n can pull data from sources that you have connected to your CData Connect Cloud account.

Prerequisites

Before you can configure and use n8n with CData Connect Cloud, you must first connect a data source to your CData Connect Cloud account. See Sources for more information.

You must also generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

Connecting to CData Connect Cloud

Follow these steps to connect to CData Connect Cloud in n8n:

  1. Sign in to n8n.io or create a new account.

  2. Create a workflow in n8n that uses the MCP client tool. The example below acts as a chatbot. OpenAI was used as the Chat Model, and Simple Memory was used as the Memory.

  3. Configure the MCP Client node in the Workflow:

    • Endpoint–enter https://mcp.cloud.cdata.com/mcp.

    • Server Transport–select HTTP Streamable.

    • Authentication–select Header Auth.

  4. Edit the Header Auth account. In the Connection tab, set the following properties to use Basic Authentication:

    • Name–enter Authorization.

    • Value–enter the value in the form Basic EMAIL:PAT, replacing EMAIL and PAT with your CData Connect Cloud email address and the PAT created in the prerequisites. For example: Basic email@cdata.com:Uu90pt5vEO….

  5. (Optional) Give the AI Agent context. This establishes the AI Agent’s role and provides context for the conversation through the System Message parameter in the AI Agent node. By providing a system message that explicitly informs the agent about its role as an MCP Server expert and lists the available tools, you can enhance the agent’s understanding and response accuracy.

    The following is a example System Message:

    You are an expert at using the MCP Client tool connected which is the CData Connect Cloud MCP Server. Always search thoroughly and use the most relevant MCP Client tool for each query. Below are the available tools and a description of each:
    queryData: Execute SQL queries against connected data sources and retrieve results. When you use the queryData tool, ensure you use the following format for the table name: catalog.schema.tableName
    execData: Execute stored procedures against connected data sources
    getCatalogs: Retrieve a list of available connections from CData Connect Cloud. The connection names should be used as catalog names in other tools and in any queries to CData Connect Cloud. Use the `getSchemas` tool to get a list of available schemas for a specific catalog.
    getColumns: Retrieve a list of available database columns from CData Connect Cloud for a specific catalog, schema, and table.
    getExportedKeys: Retrieve a list of foreign key relationships from CData Connect Cloud for a specific catalog, schema, and table.
    getImportedKeys: Retrieve a list of foreign key relationships from CData Connect Cloud for a specific catalog, schema, and table.
    getIndexes: Retrieve a list of indexes from CData Connect Cloud for a specific catalog, schema, and table.
    getPrimaryKeys: Retrieve a list of primary keys from CData Connect Cloud for a specific catalog, schema, and table.
    getProcedures: Retrieve a list of stored procedures from CData Connect Cloud for a specific catalog and schema
    getProcedureParameters: Retrieve a list of stored procedure parameters from CData Connect Cloud for a specific catalog, schema, and procedure.
    getSchemas: Retrieve a list of available database schemas from CData Connect Cloud for a specific catalog. Use the `getTables` tool to get a list of available tables for a specific catalog and schema.
    getTables: Retrieve a list of available database tables from CData Connect Cloud for a specific catalog and schema. Use the `getColumns` tool to get a list of available columns for a specific table.
    
  6. Now that you created the Workflow in n8n and connected the MCP Client, you can interact with your data. The MCP Client node allows you to send queries and receive responses from the data source in real time.

  7. Open the Workflow in n8n and execute it to start interacting with your data. You can ask questions, retrieve data, and perform actions on your data using the MCP Client node: