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

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 HubDB 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 HubDB 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 HubDB data during coding sessions.

Prerequisites

• Kiro account
• CData Connect AI account
• HubDB account with valid credentials.

Step 1: Configure HubDB Connectivity for Kiro

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

1. Log into Connect AI, click Sources, and then click Add Connection.
2. Select HubDB from the Add Connection panel.
3. Enter the necessary authentication properties to connect to HubDB.

   There are two authentication methods available for connecting to HubDB data source: OAuth Authentication with a public HubSpot application and authentication with a Private application token.

   Using a Custom OAuth App

   AuthScheme must be set to "OAuth" in all OAuth flows. Be sure to review the Help documentation for the required connection properties for you specific authentication needs (desktop applications, web applications, and headless machines).

   Follow the steps below to register an application and obtain the OAuth client credentials:

   1. Log into your HubSpot app developer account.
      • Note that it must be an app developer account. Standard HubSpot accounts cannot create public apps.
   2. On the developer account home page, click the Apps tab.
   3. Click Create app.
   4. On the App info tab, enter and optionally modify values that are displayed to users when they connect. These values include the public application name, application logo, and a description of the application.
   5. On the Auth tab, supply a callback URL in the "Redirect URLs" box.
      • If you're creating a desktop application, set this to a locally accessible URL like http://localhost:33333.
      • If you are creating a Web application, set this to a trusted URL where you want users to be redirected to when they authorize your application.
   6. Click Create App. HubSpot then generates the application, along with its associated credentials.
   7. On the Auth tab, note the Client ID and Client secret. You will use these later to configure the driver.

   8. Under Scopes, select any scopes you need for your application's intended functionality.

      A minimum of the following scopes is required to access tables:

      • hubdb
      • oauth
      • crm.objects.owners.read
   9. Click Save changes.
   10. Install the application into a production portal with access to the features that are required by the integration.
       • Under "Install URL (OAuth)", click Copy full URL to copy the installation URL for your application.
       • Navigate to the copied link in your browser. Select a standard account in which to install the application.
       • Click Connect app. You can close the resulting tab.

   Using a Private App

   To connect using a HubSpot private application token, set the AuthScheme property to "PrivateApp."

   You can generate a private application token by following the steps below:

   1. In your HubDB account, click the settings icon (the gear) in the main navigation bar.
   2. In the left sidebar menu, navigate to Integrations > Private Apps.
   3. Click Create private app.
   4. On the Basic Info tab, configure the details of your application (name, logo, and description).
   5. On the Scopes tab, select Read or Write for each scope you want your private application to be able to access.
   6. A minimum of hubdb and crm.objects.owners.read is required to access tables.
   7. After you are done configuring your application, click Create app in the top right.
   8. Review the info about your application's access token, click Continue creating, and then Show token.
   9. Click Copy to copy the private application token.

   To connect, set PrivateAppToken to the private application token you retrieved.

   
4. Click Save & Test.
5. Navigate to the Permissions tab in the Add HubDB Connection page and update the User-based 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.

With the HubDB connection configured and a PAT generated, Kiro can now connect to HubDB 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.
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.
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"
         }
       }
     }
   }    

   
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 HubDB connection appears in the response, the MCP server is set up correctly and you are ready to query live data.

   

Step 3: Query Live HubDB Data from Kiro

With the MCP server registered and verified, Kiro agents can now access your live HubDB 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:

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

• "What tables are available in my HubDB connection?"
• "What are the top records in HubDB data ordered by revenue?"
• "List all active HubDB data and their current status."
• "Summarize HubDB 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.