Detect Primary Keys and Foreign Key Relationships Using an AI Agent | Live Demo

Defining keys and relationships in a reverse-engineered legacy database is one of the most time-consuming parts of data modeling. Profiling data, identifying unique values, validating candidate keys, and mapping relationships across entities; it all adds up quickly. Astera takes a different approach. An AI agent orchestrates built-in profiling tools to detect potential primary and foreign keys, evaluates each candidate using semantic understanding, and leaves the final decision in your hands. Watch how Astera's AI agent detects keys and relationships, combining data profiling with semantic evaluation, surfacing confidence-scored recommendations, and keeping you in control of every decision. Try for free: https://www.astera.com/ Chapters: 0:00 – AI-Coordinated Key & Relationship Detection 0:11 – Starting with a Reverse-Engineered Model 0:17 – Running the Primary Key Detection Agent 0:44 – AI Semantic Evaluation and Confidence Scoring 0:59 – Reviewing Recommendations in the Dialog 1:06 – Filtering by AI, Profiler, or Selected Candidates 1:27 – Running the Foreign Key Detection Agent 2:00 – Profiler Does the Work, AI Adds the Intelligence