DX MCP Server

About

The DX MCP Server is a Python-based tool that empowers AI applications, such as Claude for Desktop and Cursor, to interact with your DX Data Cloud database. The server includes tools to:

• establish a connection to your Postgres database, allowing the AI to actively formulate and execute queries on the database

• find/utilize context about your software entities and their relationships and scorecards via DX catalog tools

Learn more about the Model Context Protocol (MCP).

Demo

https://github.com/user-attachments/assets/c6ce12a5-4562-4b44-b235-2d04871c3142

Getting Started

There are two ways to use the DX MCP Server:

1. Remote hosting (recommended): Connect to our hosted server at https://ai.getdx.com/mcp

2. Local hosting: Run the server on your machine

Prerequisites

• A DX account with access to Data Cloud

• For remote hosting:

  • A web API token with read scopes granted (found in your DX account settings)

• For local hosting:

  • Python 3.10 or higher

  • Your database connection URL (configured on DX's DB Users settings page)

  • A web API token with read scopes granted (found in your DX account settings)

Option 1: Remote Hosting (Recommended)

The hosted MCP server uses streamable HTTP transport and is available at https://ai.getdx.com/mcp. This option requires no local installation; just configure your AI client with the mcp using http transport and provided with a valid Web API Token.

Claude Code

Run this command in your terminal:

Cursor

Add this configuration to your MCP settings (Cursor > Settings > Cursor Settings > MCP):

Option 2: Local Installation

If you prefer to run the DX MCP Server locally, you can install it via PyPI or run it from source.

Installation Method 1: Install from PyPI

Install the package using pip:

Note for macOS users: If you encounter an "externally-managed-environment" error, use pipx instead:

pipx install dx-mcp-server

Installation Method 2: Clone from Source

Clone this repository to run from source:

Configuration

Once installed, configure your AI client with the appropriate settings:

Claude Code

Run this command in your terminal (adjust based on your installation method):

Claude for Desktop

Click Claude > Settings > Developer > Edit Config and add:

If you installed via pip:

If you're running from source:

Cursor

Click Cursor > Settings > Cursor Settings > MCP > Add new global MCP Server and add:

If you installed via pip:

If you're running from source:

Configuration Parameters

• DB_URL (required): Your DX Data Cloud Postgres connection string. Get this from DX DB Users settings.

  • Format: postgresql://username:password@host:port/database

• WEB_API_TOKEN: Your DX Web API Token. This enables additional catalog and entity tools. Find this in your DX account settings.

Usage

After saving the configuration, restart your AI client. You should see "dx-mcp" in the available MCP servers. When you ask questions about your data or catalog, the AI will use these tools to query your database or hit the relevant web apis.

Troubleshooting

Path Resolution Issues

The most common issue involves the MCP client not finding the dx-mcp-server/uv command, as GUI applications don't inherit the same PATH environment variables as the terminal. The solution is to use the full path to the executable in the json config.

For pip/pipx installations:

Find the full path to dx-mcp-server:

Then use the full path in your configuration:

For source installations:

Find the full path to uv:

Then use the full path in your configuration:

Checking Logs

If you're still experiencing issues:

• Claude Desktop: Check logs at:

  • macOS: ~/Library/Logs/Claude/

  • Windows: %APPDATA%\Claude\logs\

• Cursor: Check logs at:

  • macOS: ~/Library/Application Support/Cursor/logs/[SESSION_ID]

  • Windows: %APPDATA%\Cursor\logs\[SESSION_ID]

The logs will show warning and error messages when starting or running the MCP server.