Using With Cursor

Cursor IDE is a developer-focused IDE with built-in AI features. It supports natural language interaction with structured data through CData's Model Context Protocol (MCP).

This topic explains how to configure the CData Code Assist MCP to work with Cursor IDE. The CData Code Assist MCP for Adobe Experience Manager allows Cursor to securely query and describe live data using plain language prompts.

Prerequisites

Before you begin, make sure the following are installed and configured:

The CData Code Assist MCP for Adobe Experience Manager is installed.
A connection has been created and tested in the CData Code Assist MCP Configuration Tool.
Cursor IDE is installed on your machine. For more details, see Download Cursor.

Configuring CData Code Assist MCP

To register CData Code Assist MCP with Cursor IDE, create a file named mcp.json in a .cursor folder. The location of this folder determines the scope of the configuration.

The recommended way to populate mcp.json is to copy the MCP server JSON configuration directly from the CData Code Assist MCP Configuration Tool UI and paste it into the appropriate file. This ensures all paths, arguments, and connection names are accurate and eliminates the need to edit placeholders manually.

Configuration Scopes

Cursor supports two types of configuration scopes for registering MCP servers:


Scope	Location	Shareable	Description
User	.cursor/mcp.json in the user folder. For example, C:\Users\[YourUsername]\.cursor on Windows.	No	Applies to all projects on the machine. This configuration is personal and not intended for sharing across machines or repositories.
Project	.cursor/mcp.json inside the project folder. For example, C:\Projects\MyProject\.cursor on Windows.	Yes	Applies only to the current project. This configuration can be version-controlled and shared with team members.

Steps

Create a folder named .cursor in either your user folder or project folder, depending on your desired scope.
Create a file named mcp.json inside of that folder.
Copy the JSON configuration directly from the CData Code Assist MCP Configuration Tool UI and paste it into mcp.json.
Restart Cursor IDE to apply the changes.

Example Configuration

The following example illustrates the structure of an mcp.json entry and explains how key values are used by Cursor IDE.

Connection name: The server name (for example, mydatasource_sbx) must match the connection name defined in the CData Code Assist MCP Configuration Tool exactly and is case-sensitive.
Java path: The command value specifies the path to the Java executable bundled with the MCP server.
JAR path: The args array includes the path to the MCP server JAR file and the connection name passed at startup.

{
  "mcpServers": {
    "mydatasource_sbx": {
      "command": "C:\\Program Files\\CData\\CData Code Assist MCP for Adobe Experience Manager 2025\\jre\\bin\\java.exe",
      "args": [
        "-Dfile.encoding=UTF-8",
        "-jar",
        "C:/Program Files/CData/CData Code Assist MCP for Adobe Experience Manager 2025/lib/cdata.mcp.adobeexperiencemanager.jar",
        "mydatasource_sbx"
      ],
      "env": {}
    }
  }
}

Verifying Configuration

After you've created the mcp.json file, verify the configuration in Cursor.

Step 1: Open Settings

Open Cursor IDE.
Use Ctrl+Shift+P on Windows to open the Command Palette.
Search for Cursor: Settings.
Select Tools & MCP in the sidebar.
Look for your configured server name in the list. If it appears with a checkmark or a "Connected" status, the MCP server has been successfully registered and is active.

Step 2: Test a Query

Open the chat interface in Cursor (Ctrl+I on Windows) and enter a few sample queries to verify that your MCP server is active and responsive.

Managing Multiple MCP Servers

You can define multiple servers in the same mcp.json file. For example:

{
  "mcpServers": {
    "mydatasource_sbx": {
      "command": "...",
      "args": ["...", "mydatasource_sbx"],
      "env": {}
    },
    "mydatasource_prod": {
      "command": "...",
      "args": ["...", "mydatasource_prod"],
      "env": {}
    }
  }
}

Troubleshooting

The server does not appear in Cursor

Verify that a file named mcp.json exists in the correct directory.
- For user-level configuration: This file should be in your user folder, typically C:\Users\[YourUsername]\.cursor.
- For project-level configuration: The file should be in the .cursor subfolder of your project directory.
Make sure the contents of the JSON file are valid. You can copy and paste it into a free online JSON validator to check for syntax errors.
Fully close and relaunch Cursor IDE. A full restart is required to detect new or updated configuration files.

Connection issues

Check that the path to the Java executable is correct and points to the MCP server's internal JRE.
Check that the path to the JAR file is correct and points to the MCP server's JAR file for your server.
To confirm the paths, use PowerShell and run the following commands:
- Test-Path "C:\Program Files\CData\...\java.exe".
- Test-Path "C:\Program Files\CData\...\cdata.mcp.adobeexperiencemanager.jar".
Ensure that the server name listed as the last item in the args array matches the name of the MCP connection you configured using the CData Code Assist MCP Configuration Tool. This value is case-sensitive.
For Windows users, you can format file paths using either double backslashes (for example, C:\\Program Files\\CData\\...) or forward slashes (for example, C:/Program Files/CData/...).

Authentication errors

Open the installed CData Code Assist MCP Configuration Tool from the Start Menu or installation directory.
Select your configured connection and click Save & Test to confirm that the credentials are still valid.
If the test fails, re-enter your username, password, or OAuth credentials as needed, then click Save.
After saving, fully restart Cursor IDE to reload the MCP connection with updated credentials.