Build Typeform-Connected Applications in Kiro with CData Connect AI MCP Server

Somya Sharma
Somya Sharma
Technical Marketing Engineer
Leverage the CData Connect AI Remote MCP Server to enable Kiro to securely access, query, and take action on live Typeform data without replication.

Kiro is an agentic AI IDE from AWS that takes a spec-driven approach to software development, turning a natural language prompt into a detailed spec, then into working code, tests, and documentation. Available as a desktop IDE and CLI, Kiro supports remote MCP servers natively across all plans, letting agents pull live context from enterprise systems while they build.

By integrating Kiro with CData Connect AI through the MCP (Model Context Protocol), Kiro agents gain the ability to query, analyze, and act on live Typeform data directly inside any coding session. Connect AI manages authentication, security, and query optimization so you can focus on building intelligent applications, while Kiro handles spec generation, code writing, and task execution.

This article outlines the steps to configure Typeform connectivity in Connect AI, generate the required authentication credentials, register the Connect AI MCP Server in Kiro, and verify that your agent can successfully interact with live Typeform data during coding sessions.

Prerequisites

Step 1: Configure Typeform Connectivity for Kiro

Connectivity to Typeform from Kiro is made possible through Connect AI's Remote MCP Server. To interact with Typeform data from your Kiro agent sessions, start by creating and configuring a Typeform connection in Connect AI.

  1. Log into Connect AI, click Sources, and then click Add Connection. Adding a Connection in Connect AI
  2. Select Typeform from the Add Connection panel. Selecting a data source
  3. Enter the necessary authentication properties to connect to Typeform.

    Start by setting the Profile connection property to the location of the TypeForm Profile on disk (e.g. C:\profiles\TypeForm.apip). Next, set the ProfileSettings connection property to the connection string for TypeForm (see below).

    TypeForm API Profile Settings

    Authentication to TypeForm uses the OAuth standard.

    To authenticate to TypeForm, you must first register and configure an OAuth application with TypeForm here: https://admin.typeform.com/account#/section/tokens. Your app will be assigned a client ID and a client secret which can be set in the connection string. More information on setting up an OAuth application can be found at https://developer.typeform.com/get-started/.

    Note that there are several different use scenarios which all require different redirect URIs:

    • CData Desktop Applications: CData desktop applications (Sync, API Server, ArcESB) accept OAuth tokens at /src/oauthCallback.rst. The host and port is the same as the default port used by the application. For example, if you use http://localhost:8019/ to access CData Sync then the redirect URI will be http://localhost:8019/src/oauthCallback.rst.
    • CData Cloud Applications: CData cloud applications are similar to their desktop counterparts. If you access Connect AI at https://1.2.3.4/ then you should use the redirect https://1.2.3.4/src/oauthCallback.rst.
    • Desktop Application: When using a desktop application, the URI https://localhost:33333 is recommended.
    • Web Application: When developing a web application using the driver, use your own URI here such as https://my-website.com/oauth.

    After setting the following connection properties, you are ready to connect:

    • AuthScheme: Set this to OAuth.
    • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to manage the process to obtain the OAuthAccessToken.
    • OAuthClientId: Set this to the Client Id that is specified in your app settings.
    • OAuthClientSecret: Set this to Client Secret that is specified in your app settings.
    • CallbackURL: Set this to the Redirect URI you specified in your app settings.
    Configuring a connection (Salesforce is shown)
  4. Click Save & Test.
  5. Navigate to the Permissions tab in the Add Typeform Connection page and update the User-based permissions. Updating permissions

Add a Personal Access Token

A Personal Access Token (PAT) is used to authenticate the connection to Connect AI from Kiro. It is best practice to create a separate PAT for each integration to maintain granular access control.

  1. Click the Gear icon at the top right of the Connect AI app to open Settings.
  2. On the Settings page, go to the Access Tokens section and click Create PAT.
  3. Give the PAT a descriptive name (e.g., Kiro MCP) and click Create. Creating a new PAT

With the Typeform connection configured and a PAT generated, Kiro can now connect to Typeform data through Connect AI.


Step 2: Register the CData Connect AI MCP Server in Kiro

Kiro connects to external data sources through MCP servers configured in a file called mcp.json. In this step, you will open that file, add the Connect AI server details, and verify the connection.

  1. Open a project folder. Kiro requires an open project before its agent features activate. When Kiro launches, click Open a project on the Getting started screen (or click Open Folder in the Explorer panel on the left). You can open any existing folder or create a new empty one, it just needs to be open. Opening a project folder in Kiro
  2. Open the MCP config file. Press Ctrl + Shift + P (Windows) or Cmd + Shift + P (Mac) to open the command palette. Type MCP and select Kiro: Open user MCP config (JSON). This opens the mcp.json file where you register MCP servers for Kiro. Opening the Kiro user MCP configuration
  3. Generate your Base64 credentials. Kiro authenticates with Connect AI using your email and PAT, encoded together as a single Base64 string. Open a terminal and run the command for your operating system. Replace [email protected] with your Connect AI login email and YourPAT with the PAT you created in Step 1.

    Windows (PowerShell):

    [Convert]::ToBase64String([Text.Encoding]::UTF8.GetBytes("[email protected]:YourPAT"))

    Mac/Linux (Terminal):

    echo -n "[email protected]:YourPAT" | base64

    Copy the output string. You will paste it into the config file in the next step.

  4. Add the Connect AI server to mcp.json. Paste the following block into your mcp.json file. Replace your_base64_string with the string you copied in the previous step:
    {
      "mcpServers": {
        "cdata-connect-ai": {
          "url": "https://mcp.cloud.cdata.com/mcp",
          "headers": {
            "Authorization": "Basic your_base64_string"
          }
        }
      }
    }    
    Configuring the Connect AI MCP server in mcp.json
  5. Save the file. Press Ctrl + S (Windows) or Cmd + S (Mac). Kiro picks up changes to mcp.json automatically, no restart is needed.
  6. Verify the connection. Click the ghost icon in the left sidebar to open the Kiro panel. Under MCP SERVERS, you should see cdata-connect-ai with a green connected indicator. You can also confirm by typing the following in the Kiro chat panel:
    List all available connections from Connect AI.

    If your Typeform connection appears in the response, the MCP server is set up correctly and you are ready to query live data.

    Verifying the Connect AI MCP server connection in Kiro

Step 3: Query Live Typeform Data from Kiro

With the MCP server registered and verified, Kiro agents can now access your live Typeform data directly in any session. Open the Kiro chat panel and use the following prompts to interact with your data.

The integration uses the following Connect AI MCP tools in sequence:

MCP tool Purpose
getCatalogsRetrieves all available connections from Connect AI
getSchemasRetrieves the database schemas for the selected connection
getTablesRetrieves all tables and views for the selected schema
queryDataExecutes the generated SQL query and returns live results

Open the Kiro chat panel and try the following prompts to interact with your Typeform data:

  • "What tables are available in my Typeform connection?"
  • "What are the top records in Typeform data ordered by revenue?"
  • "List all active Typeform data and their current status."
  • "Summarize Typeform data activity for this quarter."

Kiro automatically discovers all CData connections, selects the most relevant connection, discovers the schema, generates, and executes the appropriate SQL query, and returns live results directly in the chat.

Build real-time, data-aware applications with Kiro and CData

Kiro and CData Connect AI together enable intelligent, AI-driven development where natural language prompts are automatically translated into live data operations across enterprise systems, without ETL pipelines, data sync jobs, or custom integration logic. This streamlined approach delivers stronger governance, lower operational overhead, and faster, more grounded responses from AI-powered agents.

Start a free trial today to see how CData Connect AI can empower Kiro with live, secure access to hundreds of enterprise systems.

Ready to get started?

Learn more about CData Connect AI or sign up for free trial access:

Free Trial