MCP 服务器

iceDQ MCP Server

Enables managing the full data quality lifecycle through Claude Desktop, including data exploration, profiling, validation, duplicate detection, reconciliation, workflows, schedules, and execution monitoring.

README

<h1 align="center">iceDQ MCP Server</h1>

Connect Claude Desktop to the iceDQ Data Quality Platform

<a href="https://icedq.com">Website</a> • <a href="https://docs.icedq.com/guides/mcp-server/intro">Documentation</a> • <a href="mailto:getsupport@icedq.com">Support</a> • <a href="https://icedq.com/privacy-policy">Privacy Policy</a>

What Is This?

The iceDQ MCP Server lets you manage your entire data quality lifecycle through conversation in Claude Desktop. Ask Claude to explore your data sources, create validation rules, run reconciliations, monitor executions, and analyze results — no UI switching required.

48 tools covering the full data quality lifecycle:

Capability	What you can do
Data Exploration	Browse workspaces, connections, databases, schemas, tables, and columns
Data Profiling	Fetch real sample data and analyze quality metrics (nulls, patterns, types)
AI Suggestions	Get intelligent check recommendations based on your data profile
Validation Rules	Create row-level rules with NotNull, Format, ValidValues, Length, Date, and Custom Groovy checks
Duplicate Detection	Identify duplicates on business keys, composite keys, or conditional criteria
Pushdown Rules	SQL-driven aggregate validation (GROUP BY, JOINs, referential integrity)
Checksum Rules	Cross-source comparison (row counts, sums) between two different connections
Reconciliation	Row-level cross-source matching with AI-powered join key and column mapping
Workflows	Chain multiple rules into sequential execution workflows
Schedules	Automate rule execution with one-time, daily, or weekly schedules
Execution & Monitoring	Run rules on demand, track status, and view exception reports
Organization	Manage folders, move rules in batch, create reusable parameters

Installation in Claude Desktop

Prerequisites

Requirement	Details
Claude Desktop	Latest version — download here
Operating System	Windows 10+ or macOS 10.15+
iceDQ	v7.5.0+ with a valid user account

Step 1 — Download the Extension

Download the latest icedq-mcp-server.mcpb file from the Releases page.

Step 2 — Get Your iceDQ Credentials

You need the following values from your iceDQ instance before configuring the extension:

Value	Where to find it
Base URL	Your iceDQ instance URL (e.g. `https://app.icedq.net`)
Realm	Authentication realm (default: `iam.icedq`)
Client ID	Administration → Security → Client Credentials
Client Secret	Administration → Security → Client Credentials
Username	Your iceDQ login email
Password	Your iceDQ login password
Organization ID	Visible in any rule's metadata (e.g. `org-iam.icedq`)

Step 3 — Install the `.mcpb` Extension

Windows

Open Claude Desktop
Click the menu icon (top-left) → Settings
Go to the Extensions tab
Click Install Extension
Browse to and select icedq-mcp-server.mcpb
Click Open — Claude Desktop installs the extension

macOS

Open Claude Desktop
Click Claude in the menu bar → Settings
Go to the Extensions tab
Click Install Extension
Browse to and select icedq-mcp-server.mcpb
Click Open — Claude Desktop installs the extension

Step 4 — Configure Your Credentials

After installation, Claude Desktop will prompt you to configure the extension:

In Settings → Extensions, find iceDQ Data Quality Platform and click Configure
Fill in the fields:

Field	Value
iceDQ Base URL	Your instance URL (e.g. `https://app.icedq.net`)
Realm Name	`iam.icedq` (or your custom realm)
Client ID	Your OAuth client ID
Client Secret	Your OAuth client secret
Username	Your iceDQ username
Password	Your iceDQ password
Organization ID	Your org ID (e.g. `org-iam.icedq`)

Click Save and enable the extension by clicking Enable toggle.

Step 5 — Verify the Installation

Start a new conversation in Claude Desktop
Type: List my iceDQ workspaces
Claude should respond with your workspace names and IDs

If it works — you're ready to go.

Usage Examples

Explore your data:

"List my iceDQ workspaces and show the connections in Production_DQ"

Profile a table:

"Fetch sample data from the Customers table and suggest quality checks"

Create a validation rule:

"Create a validation rule called Customer_Quality_Checks with those suggested checks"

Run and monitor:

"Execute Customer_Quality_Checks and show me the results"

Cross-source comparison:

"Compare row counts between SQL Server Orders and Snowflake FACT_ORDERS"

Reconciliation:

"Reconcile the Customers table between Oracle and Snowflake using email as the join key"

Troubleshooting

Issue	Solution
Extension not appearing	Restart Claude Desktop after installation
Authentication failed	Verify Client ID, Client Secret, username, and password
No workspaces returned	Check Base URL and ensure your user has workspace access
SSL certificate error	Set Verify SSL to `false` (for self-signed certs only)
Tools not responding	Enable Debug Mode in extension settings and check logs

Debug Logs

Enable Debug Mode in Settings → Extensions → iceDQ → Configure.

Log file locations:

Windows: %APPDATA%\Claude\Logs\extensions\
macOS: ~/Library/Logs/Claude/extensions/

Security & Privacy

Credentials are stored in your OS keychain — never on external servers
All communication uses HTTPS with OAuth 2.0
Data flows directly between Claude Desktop and your iceDQ instance — no third parties
No telemetry or tracking of any kind
No data persistence beyond the active session

Full details: https://icedq.com/privacy-policy