Tools API Reference

Complete specification for all MCP tools provided by mcp-data-platform.

Trino Tools

trino_query

Execute a SQL query against the Trino cluster.

Parameters:

Parameter	Type	Required	Default	Description
query	string	Yes	-	SQL query to execute
limit	integer	No	1000	Maximum rows to return (capped by max_limit config)
connection	string	No	first configured	Trino connection name

Response Schema:

{
  "columns": [
    {"name": "column_name", "type": "varchar"}
  ],
  "rows": [
    ["value1", "value2"]
  ],
  "row_count": 100,
  "execution_time_ms": 250,
  "query_id": "20240115_123456_00001_xxxxx"
}

Enrichment (when enabled):

{
  "semantic_context": {
    "description": "Table description from DataHub",
    "owners": [{"name": "Team Name", "type": "group"}],
    "tags": ["tag1", "tag2"],
    "domain": {"name": "Domain Name"},
    "quality_score": 0.95,
    "deprecation": null
  }
}

Error Codes:

Code	Cause
SYNTAX_ERROR	Invalid SQL syntax
TABLE_NOT_FOUND	Referenced table doesn't exist
PERMISSION_DENIED	Insufficient privileges
TIMEOUT	Query exceeded timeout

---

trino_explain

Get the execution plan for a SQL query.

Parameters:

Parameter	Type	Required	Default	Description
query	string	Yes	-	SQL query to explain
connection	string	No	first configured	Trino connection name

Response Schema:

{
  "plan": "Query Plan\n- TableScan[table = ...]\n  ...",
  "format": "text"
}

---

trino_list_catalogs

List available catalogs.

Parameters:

Parameter	Type	Required	Default	Description
connection	string	No	first configured	Trino connection name

Response Schema:

{
  "catalogs": ["hive", "iceberg", "memory"]
}

---

trino_list_schemas

List schemas in a catalog.

Parameters:

Parameter	Type	Required	Default	Description
catalog	string	No	configured default	Catalog name
connection	string	No	first configured	Trino connection name

Response Schema:

{
  "catalog": "hive",
  "schemas": ["default", "sales", "marketing"]
}

---

trino_list_tables

List tables in a schema.

Parameters:

Parameter	Type	Required	Default	Description
catalog	string	No	configured default	Catalog name
schema	string	No	configured default	Schema name
connection	string	No	first configured	Trino connection name

Response Schema:

{
  "catalog": "hive",
  "schema": "sales",
  "tables": [
    {"name": "orders", "type": "TABLE"},
    {"name": "customers", "type": "TABLE"},
    {"name": "daily_revenue", "type": "VIEW"}
  ]
}

---

trino_describe_table

Get table schema and metadata.

Parameters:

Parameter	Type	Required	Default	Description
table	string	Yes	-	Table name (can be catalog.schema.table)
connection	string	No	first configured	Trino connection name

Response Schema:

{
  "table": {
    "catalog": "hive",
    "schema": "sales",
    "name": "orders"
  },
  "columns": [
    {
      "name": "order_id",
      "type": "bigint",
      "nullable": false,
      "comment": "Unique order identifier"
    }
  ],
  "partitioning": ["order_date"],
  "properties": {
    "format": "PARQUET"
  }
}

---

trino_list_connections

List configured Trino connections.

Parameters: None

Response Schema:

{
  "connections": [
    {
      "name": "primary",
      "display_name": "Production",
      "host": "trino.example.com",
      "catalog": "hive",
      "schema": "default"
    }
  ]
}

---

DataHub Tools

datahub_search

Search for entities in the catalog.

Parameters:

Parameter	Type	Required	Default	Description
query	string	Yes	-	Search query
type	string	No	-	Entity type: dataset, dashboard, chart, dataflow
platform	string	No	-	Platform filter: trino, snowflake, s3, etc.
limit	integer	No	10	Maximum results (capped by max_limit config)
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "results": [
    {
      "urn": "urn:li:dataset:(urn:li:dataPlatform:trino,hive.sales.orders,PROD)",
      "name": "orders",
      "description": "Customer orders",
      "platform": "trino",
      "type": "dataset",
      "owners": ["Data Team"],
      "tags": ["pii", "financial"]
    }
  ],
  "total": 150,
  "has_more": true
}

Enrichment (when enabled):

{
  "query_context": {
    "urn:li:dataset:...": {
      "queryable": true,
      "connection": "primary",
      "table_identifier": {
        "catalog": "hive",
        "schema": "sales",
        "table": "orders"
      },
      "sample_query": "SELECT * FROM hive.sales.orders LIMIT 10"
    }
  }
}

---

datahub_get_entity

Get detailed entity information.

Parameters:

Parameter	Type	Required	Default	Description
urn	string	Yes	-	Entity URN
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "urn": "urn:li:dataset:...",
  "type": "dataset",
  "name": "orders",
  "description": "Customer orders from e-commerce platform",
  "platform": "trino",
  "created": "2024-01-01T00:00:00Z",
  "modified": "2024-01-15T12:00:00Z",
  "owners": [
    {"name": "Data Team", "type": "group", "email": "[email protected]"}
  ],
  "tags": ["pii", "financial"],
  "glossary_terms": ["Order", "Transaction"],
  "domain": {
    "urn": "urn:li:domain:sales",
    "name": "Sales"
  },
  "deprecation": null,
  "custom_properties": {
    "refresh_schedule": "daily"
  }
}

---

datahub_get_schema

Get dataset schema.

Parameters:

Parameter	Type	Required	Default	Description
urn	string	Yes	-	Dataset URN
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "urn": "urn:li:dataset:...",
  "fields": [
    {
      "name": "order_id",
      "type": "NUMBER",
      "native_type": "bigint",
      "nullable": false,
      "description": "Unique order identifier",
      "tags": ["pii"],
      "glossary_terms": ["Order ID"]
    }
  ],
  "primary_keys": ["order_id"],
  "foreign_keys": []
}

---

datahub_get_lineage

Get data lineage.

Parameters:

Parameter	Type	Required	Default	Description
urn	string	Yes	-	Entity URN
direction	string	No	downstream	upstream or downstream
depth	integer	No	3	Maximum traversal depth
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "root": "urn:li:dataset:...",
  "direction": "downstream",
  "entities": [
    {
      "urn": "urn:li:dataset:...",
      "name": "daily_orders_agg",
      "type": "dataset",
      "depth": 1
    }
  ],
  "relationships": [
    {
      "source": "urn:li:dataset:orders",
      "target": "urn:li:dataset:daily_orders_agg",
      "type": "TRANSFORMED"
    }
  ]
}

---

datahub_get_queries

Get popular queries for a dataset.

Parameters:

Parameter	Type	Required	Default	Description
urn	string	Yes	-	Dataset URN
limit	integer	No	10	Maximum queries to return
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "urn": "urn:li:dataset:...",
  "queries": [
    {
      "query": "SELECT * FROM orders WHERE status = 'completed'",
      "user": "[email protected]",
      "executed_at": "2024-01-15T10:00:00Z",
      "execution_count": 150
    }
  ]
}

---

datahub_get_glossary_term

Get glossary term details.

Parameters:

Parameter	Type	Required	Default	Description
urn	string	Yes	-	Glossary term URN
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "urn": "urn:li:glossaryTerm:Revenue",
  "name": "Revenue",
  "description": "Total monetary value from sales transactions",
  "parent": "urn:li:glossaryTerm:FinancialMetrics",
  "related_terms": ["Gross Revenue", "Net Revenue"],
  "custom_properties": {
    "calculation": "SUM(line_item_amount)"
  }
}

---

datahub_list_tags

List available tags.

Parameters:

Parameter	Type	Required	Default	Description
limit	integer	No	100	Maximum tags to return
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "tags": [
    {"urn": "urn:li:tag:pii", "name": "pii", "description": "Contains PII"},
    {"urn": "urn:li:tag:financial", "name": "financial", "description": "Financial data"}
  ]
}

---

datahub_list_domains

List data domains.

Parameters:

Parameter	Type	Required	Default	Description
limit	integer	No	100	Maximum domains to return
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "domains": [
    {
      "urn": "urn:li:domain:sales",
      "name": "Sales",
      "description": "Sales and revenue data",
      "entity_count": 45
    }
  ]
}

---

datahub_list_data_products

List data products.

Parameters:

Parameter	Type	Required	Default	Description
domain	string	No	-	Filter by domain URN
limit	integer	No	100	Maximum products to return
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "data_products": [
    {
      "urn": "urn:li:dataProduct:customer360",
      "name": "Customer 360",
      "description": "Unified customer view",
      "domain": "urn:li:domain:marketing",
      "assets": 12
    }
  ]
}

---

datahub_get_data_product

Get data product details.

Parameters:

Parameter	Type	Required	Default	Description
urn	string	Yes	-	Data product URN
connection	string	No	first configured	DataHub connection name

Response Schema:

{
  "urn": "urn:li:dataProduct:customer360",
  "name": "Customer 360",
  "description": "Unified customer view combining all customer data sources",
  "domain": {
    "urn": "urn:li:domain:marketing",
    "name": "Marketing"
  },
  "owners": ["Marketing Data Team"],
  "assets": [
    {"urn": "urn:li:dataset:customers", "name": "customers", "type": "dataset"},
    {"urn": "urn:li:dataset:customer_events", "name": "customer_events", "type": "dataset"}
  ],
  "custom_properties": {
    "sla": "99.9%",
    "refresh": "hourly"
  }
}

---

datahub_list_connections

List configured DataHub connections.

Parameters: None

Response Schema:

{
  "connections": [
    {
      "name": "primary",
      "display_name": "Primary Catalog",
      "url": "https://datahub.example.com"
    }
  ]
}

---

S3 Tools

s3_list_buckets

List available S3 buckets.

Parameters:

Parameter	Type	Required	Default	Description
connection	string	No	first configured	S3 connection name

Response Schema:

{
  "buckets": [
    {
      "name": "data-lake",
      "creation_date": "2024-01-01T00:00:00Z",
      "region": "us-east-1"
    }
  ]
}

---

s3_list_objects

List objects in a bucket.

Parameters:

Parameter	Type	Required	Default	Description
bucket	string	Yes	-	Bucket name
prefix	string	No	-	Key prefix filter
delimiter	string	No	-	Delimiter for hierarchy (typically /)
max_keys	integer	No	1000	Maximum objects to return
connection	string	No	first configured	S3 connection name

Response Schema:

{
  "bucket": "data-lake",
  "prefix": "sales/orders/",
  "objects": [
    {
      "key": "sales/orders/2024/01/data.parquet",
      "size": 52428800,
      "last_modified": "2024-01-15T10:30:00Z",
      "storage_class": "STANDARD"
    }
  ],
  "common_prefixes": ["sales/orders/2024/02/"],
  "is_truncated": false
}

---

s3_get_object

Get object contents.

Parameters:

Parameter	Type	Required	Default	Description
bucket	string	Yes	-	Bucket name
key	string	Yes	-	Object key
connection	string	No	first configured	S3 connection name

Response Schema:

{
  "bucket": "data-lake",
  "key": "config/settings.json",
  "content": "{\"setting\": \"value\"}",
  "content_type": "application/json",
  "size": 25,
  "last_modified": "2024-01-15T10:30:00Z"
}

Note: Content is limited by max_get_size configuration.

---

s3_get_object_metadata

Get object metadata without downloading content.

Parameters:

Parameter	Type	Required	Default	Description
bucket	string	Yes	-	Bucket name
key	string	Yes	-	Object key
connection	string	No	first configured	S3 connection name

Response Schema:

{
  "bucket": "data-lake",
  "key": "sales/orders/data.parquet",
  "size": 52428800,
  "content_type": "application/octet-stream",
  "last_modified": "2024-01-15T10:30:00Z",
  "etag": "\"d41d8cd98f00b204e9800998ecf8427e\"",
  "metadata": {
    "x-amz-meta-created-by": "etl-pipeline"
  }
}

---

s3_presign_url

Generate a pre-signed URL.

Parameters:

Parameter	Type	Required	Default	Description
bucket	string	Yes	-	Bucket name
key	string	Yes	-	Object key
expires	string	No	15m	URL expiration (e.g., 1h, 30m)
connection	string	No	first configured	S3 connection name

Response Schema:

{
  "url": "https://bucket.s3.amazonaws.com/key?X-Amz-...",
  "expires_at": "2024-01-15T11:00:00Z"
}

---

s3_list_connections

List configured S3 connections.

Parameters: None

Response Schema:

{
  "connections": [
    {
      "name": "primary",
      "display_name": "Data Lake",
      "region": "us-east-1",
      "read_only": true
    }
  ]
}

---

s3_put_object

Upload an object. Only available when read_only: false.

Parameters:

Parameter	Type	Required	Default	Description
bucket	string	Yes	-	Bucket name
key	string	Yes	-	Object key
content	string	Yes	-	Object content
content_type	string	No	application/octet-stream	MIME type
connection	string	No	first configured	S3 connection name

Response Schema:

{
  "bucket": "data-lake",
  "key": "uploads/file.json",
  "etag": "\"d41d8cd98f00b204e9800998ecf8427e\"",
  "size": 1024
}

---

s3_delete_object

Delete an object. Only available when read_only: false.

Parameters:

Parameter	Type	Required	Default	Description
bucket	string	Yes	-	Bucket name
key	string	Yes	-	Object key
connection	string	No	first configured	S3 connection name

Response Schema:

{
  "bucket": "data-lake",
  "key": "uploads/file.json",
  "deleted": true
}

---

s3_copy_object

Copy an object. Only available when read_only: false.

Parameters:

Parameter	Type	Required	Default	Description
source_bucket	string	Yes	-	Source bucket name
source_key	string	Yes	-	Source object key
dest_bucket	string	Yes	-	Destination bucket name
dest_key	string	Yes	-	Destination object key
connection	string	No	first configured	S3 connection name

Response Schema:

{
  "source": {
    "bucket": "data-lake",
    "key": "original/file.json"
  },
  "destination": {
    "bucket": "data-lake",
    "key": "backup/file.json"
  },
  "copied": true
}