Build NetSuite SuiteAnalytics-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 NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics data during coding sessions.

Prerequisites

• Kiro account
• CData Connect AI account
• NetSuite SuiteAnalytics account with valid credentials.

Step 1: Configure NetSuite SuiteAnalytics Connectivity for Kiro

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

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

   Prerequisites

   Before you can connect to NetSuite SuiteAnalytics, you must set up SuiteAnalytics Connect in your NetSuite account:

   1. Enable the Connect Service feature.

      1. Ensure that your Account Administrator has enabled your Account and Role with the Connect Service feature.

      2. Navigate to Setup > Company > Enable Features.

      3. Click the Analytics tab and check the SuiteAnalytics Connect box.

   2. Add the SuiteAnalytics Connect permission to an existing Role, and note the Role ID for later.

   3. Find the Settings portlet on your home page and click Set Up SuiteAnalytics Connect, then click Your Configuration to view your service host and account ID. These settings map directly to the Server and Account Id properties.

   Add the NetSuite SuiteAnalytics Connection

   1. Open the Sources page of the Connect Cloud dashboard.

   2. Click Add Connection and select NetSuite SuiteAnalytics from the list of connectors.

   3. Enter a Connection Name of your choice.

   Authenticate to NetSuite SuiteAnalytics

   Set the following required properties:

   • Server: The Service Host value you found when setting up SuiteAnalytics Connect.

   • Account Id: The Account ID value you found when setting up SuiteAnalytics Connect.

   • Role Id: The internal ID of the login role you granted the SuiteAnalytics Connect permission.

   Next, choose one of the supported authentication methods:

   Basic authentication

   • User: The username you use to authenticate to your NetSuite account.

   • Password: The password associated with that account.

   Token-based authentication

   • Consumer Key and Consumer Secret: Generated when you create your integration record in NetSuite.

   • Token Key and Token Secret: The access token and secret generated for that integration.

   After you enter your credentials, click Save & Test to validate the connection.

   
4. Click Save & Test.
5. Navigate to the Permissions tab in the Add NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics connection configured and a PAT generated, Kiro can now connect to NetSuite SuiteAnalytics 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 NetSuite SuiteAnalytics connection appears in the response, the MCP server is set up correctly and you are ready to query live data.

   

Step 3: Query Live NetSuite SuiteAnalytics Data from Kiro

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

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