microsoft / microsoft/DataFactory.MCP
Schema Discovery - List Relationships
Nobody has claimed this yet.
- Dominant language
- C#
- Stars
- 42
- Forks
- 19
- PR merge metrics
- No merged PRs in 30d
Description
Issue: Add list_relationships tool
Labels: enhancement, schema-discovery, priority:medium
Problem:
Join keys between tables must be inferred manually by inspecting column names and values. Error-prone and time-consuming.
Proposed Solution:
Tool that analyzes tables and infers likely foreign key relationships based on:
- Column name patterns (e.g.,
customer_idin both tables) - Value overlap analysis
Acceptance Criteria:
- Tool accepts: dataflow ID, list of tables (or all)
- Returns likely relationships with confidence score
- Indicates which columns to join on
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No files, tests, or entry points are named. Start by locating existing schema-discovery tools and the code that handles dataflow IDs and table selection, then inspect how tool results and confidence values are represented. Done means the tool accepts the requested scope and reports likely relationships, join columns, and confidence scores.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- csharp
- Domain
- data-engineering, databases, tooling
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100