Oracle EIM Data Quality

Standalone MCP server for governed EIM data-quality checks against On-Prem Oracle and Oracle ATP. This is not the Oracle MCP chatbot.

The chatbot project (oracle-mcp-chatbot) answers natural-language questions. This project only loads ACTIVE rules from EIM_APPS.EIM_DQ_RULES_LOOKUP, runs approved read-only aggregate SQL, and returns a director-ready Markdown report.

pip install --target .pydeps -r requirements-dev.txt
PYTHONPATH=.pydeps:src pytest
cp .env.example .env                          # add credentials
PYTHONPATH=.pydeps:src python -m oracle_mcp.server --profile both --check
PYTHONPATH=.pydeps:src python -m oracle_mcp.server --profile both

Rule workflow and report contract: docs/data-quality-framework.md.

What it does

Related MCP server: database-mcp

MCP tools

• list_active_dq_rules

• execute_data_quality_rule

• plus the same read-only discovery/validate/execute tools used to confirm objects

Cursor MCP

Point Cursor at mcp-clients/cursor-mcp.json (replace absolute paths). The workspace .cursor/mcp.json should register oracle-eim-dq with cwd set to this repository, not oracle-mcp-chatbot.

Test locally

Run these commands from this repository:

# 1. Unit and security tests (no database required)
PYTHONPATH=.pydeps:src .pydeps/bin/pytest -q

# 2. Verify both Oracle connections
PYTHONPATH=.pydeps:src python3 -m oracle_mcp.server --profile both --check

# 3. Verify the MCP tool surface and read the live ACTIVE-rule catalog
PYTHONPATH=.pydeps:src python3 scripts/verify_dq.py

Expected live verification:

{
  "status": "OK",
  "server": "oracle-eim-dq",
  "databases": ["ATP", "ONPREM"],
  "dq_tools": ["execute_data_quality_rule", "list_active_dq_rules"]
}

If active_rule_count is 0, connectivity and MCP are working but the governed catalog has no ACTIVE rules yet. Populate and approve catalog rows outside this read-only application, then rerun the verification.

After changing .cursor/mcp.json, reload Cursor's MCP servers. In chat, first ask: List the active EIM data-quality rules. Do not attempt a rule execution until that call returns an ACTIVE rule ID.