This is full list of tools currently exposed by the Elementary MCP Server. These tools allow agents and interfaces to retrieve information from your Elementary environment, such as models, tests, lineage, incidents, and coverage, in a structured and consistent way. You won’t need to use these tools directly. They’re used behind the scenes by any MCP-compatible client.
CategoryTool NamePurposeOutput
Discovery & Lineageget_assetWhen you need info about any asset type, from source to BI (table assets, BI assets)Complete asset details with general information
get_upstream_assetsWhen investigating data lineage or debugging issues upstreamAsset dependencies with metadata (id, name, type, criticality, tags, owners, description, path)
get_downstream_assetsWhen assessing impact of changes or understanding data consumersAsset dependencies with metadata (id, name, type, criticality, tags, owners, description, path)
get_column_upstream_columnsWhen tracing column-level lineage for specific data fieldsColumn dependencies with their metadata (id, name, type, table info)
get_column_downstream_columnsWhen understanding column usage and impact analysisColumn dependencies with their metadata (id, name, type, table info)
get_table_assetWhen you need table-specific details like schema, columns, and testsTable asset with columns, materialization, execution status, and associated tests
get_table_assetsWhen searching for tables by name, tags, owners, or other criteriaList of table assets matching filter criteria
get_table_asset_compiled_queryWhen you need to see the actual SQL code being executedCompiled SQL query from the latest execution
get_table_asset_execution_historyWhen investigating table execution patterns or failures over timeHistorical execution records with timestamps and status
get_table_asset_executionWhen debugging a specific table execution failureDetailed execution logs, timing, and error information
Test & Coverageget_assets_sorted_by_coverageWhen prioritizing which assets need more test coverageAssets ranked by test coverage percentage
get_testWhen investigating test configuration or recent test resultsTest details including config, execution status, and quality dimensions
get_testsWhen searching for tests by name, type, or asset associationList of tests matching filter criteria
get_test_execution_metricsWhen analyzing specific test failure metrics that caused anomalyTest execution results, numerical metrics, and anomaly details
get_test_execution_historyWhen reviewing test performance patterns over timeHistorical test execution records and results
get_test_executionWhen debugging a specific test execution failureDetailed test execution logs, results, and error information
get_tests_catalogWhen helping users add tests to their dbt projectAvailable test types that can be defined in the dbt project
Incidentsget_incidentsWhen searching for incidents by time range, status, severity, or assigneeList of incidents with timing, assignee, status, severity, tags, and ticket information
get_incidentWhen investigating details of a specific incidentComplete incident details including source asset/test information and execution context
get_asset_incidents_historyWhen reviewing past incident patterns for a specific assetHistorical incident records for an asset with status and timing
Environment Managementget_environmentsWhen starting a session to discover available data environmentsDictionary mapping environment IDs to environment names