MCP

Model Context Protocol - Connecting Coalesce Quality to AI applications

What is MCP?

The Model Context Protocol (MCP) is an open standard that enables AI applications to securely connect with external data sources and tools. MCP is supported by various AI tools including Claude Desktop, Cursor, and other AI development environments.

For detailed information about MCP, see:

• Anthropic’s MCP Documentation
• Introduction to MCP

Coalesce Quality MCP Tools

Coalesce Quality provides an MCP server that connects AI assistants to your data infrastructure, enabling AI-powered data discovery, lineage analysis, incident management, and direct data querying.

Discovery and Search

Tool	Description
search_entities	Search for entities by name, description, and other metadata with optional filtering by entity types
sample_entities	Get entity count sampling by type for search queries to understand distribution before detailed searches
list_annotations	List all available annotations with their usage counts across entities

Core Entity Operations

Tool	Description
get_entity_details	Retrieve detailed information about a specific data entity including properties, metadata, and current state
batch_entity_details	Get details for multiple entities simultaneously - more efficient than multiple individual calls
get_schema	Retrieve schema definition including column names, types, and constraints for table-like entities
get_database_coordinates_from_entity	Retrieve physical DWH coordinates (dialect, connection, instance, database, schema, object) for table entities
get_entity_from_database_coordinates	Map SQL table references (fully/partially/unqualified) to Coalesce Quality entity IDs
get_code	Access the latest version of source code that defines or implements data entities (SQL definitions, dbt models, etc.)

Data Lineage Analysis

Comprehensive Lineage

Tool	Description
get_lineage	Advanced dependency analysis with directional control (upstream, downstream, or both) and configurable depth

Upstream Analysis

Tool	Description
get_upstream_dependencies	Find all upstream dependencies with configurable traversal distance
get_immediate_upstream_dependencies	Find only direct upstream dependencies for quick analysis
get_upstream_sources	Trace data lineage to find original data sources (dbt sources, SQLMesh external models, Coalesce sources)

Downstream Analysis

Tool	Description
get_downstream_dependencies	Find all downstream dependencies with configurable traversal distance
get_immediate_downstream_dependencies	Find only direct downstream dependencies for quick analysis

Cross-Entity Analysis

Tool	Description
get_common_upstream_dependencies	Find shared dependencies between two entities using connected components analysis

Orchestration

Tool	Description
get_orchestration	Get orchestration relationships for entities - shows what orchestrates them (upstream) and what they orchestrate (downstream)

Issue and Incident Management

Tool	Description
list_open_issues	List all open issues currently requiring attention with optional entity filtering
list_open_incidents	List all currently open incidents that need attention or resolution with optional entity filtering
get_issue	Get basic details of a specific data issue
get_issue_details	Get detailed information about a specific data issue
get_issue_comments	Get comments and discussions on issues if available
list_history	Find historical incidents and issues to identify patterns and recurring problems

Impact Analysis

Tool	Description
get_entity_impact	Get impact analysis showing all entities and systems affected if there was an issue on the entity
get_issue_impact	Get impact analysis showing all entities and systems affected by a specific issue

Data Quality and Monitoring

Tool	Description
list_checks	Retrieve all data quality checks configured for a specific entity (direct and inherited)
get_monitor	Retrieve detailed information about a specific monitor including configuration and status
execute_monitor	Execute a monitor and get its data from the database with optional segmentation and filtering

Executions

Tool	Description
get_latest_executions	Get the most recent execution for each specified entity (monitors, dbt models, airflow tasks, etc.)
list_executions	List execution history for specific entities with filtering by time range, status, and execution type
batch_executions	Get detailed information for specific executions by their IDs
summarise_executions	Get aggregated execution statistics - counts by type and status, time ranges, and latest execution per entity

Data Analysis

Tool	Description
profile_columns	Compute statistical information about column values (supports String, Numeric, and Time columns)
sample_column_values	Get frequency distribution of values for specific columns with optional time-based filtering

Change Tracking and History

Database Changes

Tool	Description
list_database_changes	Retrieve history of schema and SQL definition changes for specific entities
get_database_change_details	Return full change details for specific change IDs

Git Integration

Tool	Description
list_commits	List commits that affect a specific entity, providing git history and change information
get_commit_diff	Retrieve exact diff content of specific commit changes with optional path filtering

Utilities

Tool	Description
batch_urls	Generate Coalesce Quality application URLs for multiple entities and issues for easy navigation

Getting Started

Contact the Coalesce Quality team to set up MCP for your organization.