mcp-data-platform-v0.9.3

SQL Query Semantic Enrichment

Overview

Multi-table semantic enrichment for SQL queries. The enrichment middleware parses SQL to identify all referenced tables and fetches semantic context for each.

Features

• Multi-table extraction - Identifies all tables in FROM and JOIN clauses
• Elasticsearch raw_query support - Extracts indices from TABLE(elasticsearch.system.raw_query(...))
• CTE filtering - Excludes Common Table Expressions from enrichment (not physical tables)
• Trino 3-part names - Full support for catalog.schema.table syntax

Response Format

Query responses include semantic context for all referenced tables:

{
  "semantic_context": {
    "description": "Primary table description",
    "owners": [...],
    "tags": [...]
  },
  "additional_tables": [
    {"table": "catalog.schema.joined_table", "description": "..."}
  ]
}

Files Changed

File	Change
pkg/middleware/sqlextract.go	SQL parsing and table extraction
pkg/middleware/sqlextract_test.go	Extraction tests
pkg/middleware/semantic.go	Integration with enrichment pipeline
pkg/middleware/semantic_test.go	Enrichment tests

Test Coverage

95.5% coverage on middleware package.

Changelog

Others

• a16f26a: SQL Table Extraction for Semantic Enrichment (#33) (@cjimti)
• 8152041: SQL Table Extraction for Semantic Enrichment (#34) (@cjimti)

Installation

Homebrew (macOS)

brew install txn2/tap/mcp-data-platform

Claude Code CLI

claude mcp add mcp-data-platform -- mcp-data-platform

Docker

docker pull ghcr.io/txn2/mcp-data-platform:v0.9.3

Verification

All release artifacts are signed with Cosign. Verify with:

cosign verify-blob --bundle mcp-data-platform_0.9.3_linux_amd64.tar.gz.sigstore.json \
  mcp-data-platform_0.9.3_linux_amd64.tar.gz