microsoft / microsoft/DataFactory.MCP

Schema Discovery - Describe Table

Open
#40 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

enhancement schema-discovery
Dominant language
C#
Stars
42
Forks
19
PR merge metrics
No merged PRs in 30d

Description

Issue: Add describe_table tool

Labels: enhancement, schema-discovery, priority:high

Problem:
Understanding table structure requires multiple manual queries—listing tables, sampling rows, inferring types. This adds 3-4 round trips before any real analysis.

Proposed Solution:
Single tool that returns:

  • Column names and data types
  • Row count
  • Sample values (first N rows)
  • Nullable indicators

Acceptance Criteria:

  • Tool accepts: dataflow ID, table/entity name, sample size (default 5)
  • Returns structured response with columns, types, row count, sample data
  • Works with Lakehouse, SQL, and other common sources

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No files, tests, or entry points are named. Start by locating the existing MCP tool registrations and source integrations, then trace how dataflow IDs and table names are handled; done means one tool accepts the three listed inputs and returns columns, types, row count, nullable indicators, and up to the requested sample size across the stated source types.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp
Domain
databases
Issue type
Feature
Difficulty
5/5
Estimated time
Over a week
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.