Image of Visual Data Stories with Gen-AI
( ERD )( Database Schema )( Data Visualization )

Visual Data Stories with Gen-AI

Text by Takafumi Endo

Published

Explore how Liam ERD combines AI and visual data storytelling to enhance database design, bridging AI suggestions with human expertise & context.
Table of Contents

Have you ever felt like product development is moving so fast that it’s hard to keep up? One moment, you’re hashing out a new database schema. It won’t be long before a large language model (LLM) can suggest indexes, draft migration scripts, or even hint at performance optimizations you haven’t considered. That day is coming fast. And while it’s an exciting shift, it also highlights just how much context a purely AI-driven approach can still overlook.

A recent MIT Sloan Management Review article examines the evolving role of AI in analytics. According to the article, while tools like ChatGPT and Gemini can process natural language inputs and uncover patterns in data, they don’t always capture the strategic nuance or business-specific complexities required for high-stakes decision-making. The piece highlights a framework that helps leaders decide when to rely on AI and when traditional visual storytelling is still necessary—particularly for sophisticated scenarios like presenting a business case to executives.

That’s where Liam ERD comes in. At first glance, it might look like just another diagram tool. But once you see how data stories come alive in Liam ERD within a cross-functional team, you’ll appreciate how powerful visualization and shared context can be.

Beyond AI-Generated Schemas

I’ve spent years working on everything from e-commerce backends to analytics pipelines, and I’ll admit I love the convenience of having an AI propose a schema outline or whip up a boilerplate migration. It saves time and can spark ideas you might not have considered. However, AI-driven suggestions often mirror patterns from training data rather than reflecting your unique business rules, emergent features, or evolving compliance requirements.

Imagine refactoring an in-house inventory system that initially seemed straightforward—just a table for products, one for inventory, and foreign keys to maintain consistency. In theory, an AI could handle that without much trouble. But when product bundles were introduced—where items could come from multiple suppliers and arrive in separate shipments—unexpected challenges emerged. AI-generated recommendations included new join tables but overlooked edge cases such as partial restocks or concurrency bottlenecks in shipping. The result? A schema that looked “correct” in theory but didn’t fully address real usage.

  • Context Over Patterns: AI can’t automatically “know” your specific constraints—like region-specific tax laws or ephemeral promotions in your marketing pipeline.
  • Human Adaptability: Product teams iterate in real time. The moment you spot a concurrency conflict or an unusual edge case, you talk it through, weigh trade-offs, and refine. AI can’t fully replicate that spontaneous interplay of perspectives.

Why Diagrams Still Matter in an AI World

One of my favorite moments in building or refactoring a product is when the team sees a visual data flow and everything clicks. Numbers and queries are fine, but the big-picture view often uncovers hidden issues or opens up new ideas.

In a scenario like an inventory revamp, Liam ERD could save a ton of headaches. Say you import an AI-generated schema and visually map out how bundles, shipping, and restocking should work. Right away, some big questions pop up:

  • Are partial restocks handled per bundle item, or all lumped together?
  • Could overlapping shipments lead to concurrency issues we didn’t see coming?
  • How do we make sure multi-region shipping stays compliant with local regulations?

Seeing these relationships in an ERD makes it easier for everyone—product managers, QA, and engineers—to get on the same page. Instead of a rigid, top-down process or trial and error, teams can refine relationships, test them in code, and roll out changes with confidence.

Generative AI grows smarter by the day and can accelerate routine tasks like summarizing table relationships or drafting documentation. But if you rely solely on text-based suggestions, you may overlook how a new column or table interacts with the rest of your system.

Data storytelling bridges that gap by providing a visual language to:

  1. Pinpoint friction points
  2. Keep non-technical contributors in the loop
  3. Align the entire team on a single source of truth

It’s not just about making things look pretty; it’s about uncovering insights that a purely text-based approach might miss.

Turning Database Schemas into a Living Data Narrative

Managing Rapidly Evolving Requirements

No matter how robust your AI tool is, product requirements often shift under your feet. Maybe marketing decides to launch location-based promotions that demand a new table, or a new regulation forces data into a specific format. AI can propose quick workarounds, but only a human-driven conversation—ideally supported by a shared, visual representation—can confirm that the fix won’t break other parts of the system.

To adapt to these real-time shifts, teams will rely on tools like Liam ERD to maintain a living diagram. Whenever a new table or relationship is introduced, everyone sees the updated model. This ensures a single source of truth, preventing misunderstandings and unnecessary rework.

Building a Long-Term Data Story

One big lesson I’ve learned is that database schemas are never truly done; they evolve along with your product. That’s why we’re pushing Liam ERD to be more than just a diagram generator. We envision it as a living platform for data storytelling:

  • Cross-Functional Collaboration:
    Product owners can annotate tables with user stories, data analysts can highlight performance bottlenecks, and engineers can track each migration’s effect on the schema.
  • Real-Time Updates:
    Whenever the schema changes, your diagrams stay in sync, so your entire organization knows how data is flowing through your system.

Generative AI can (and should) feed into this process by drafting new relationships or flagging suspicious table joins. However, the synergy between AI output and a visually guided, human discussion is what ultimately drives better results.

We believe the future of Liam ERD lies in bridging this gap—combining AI’s ability to generate insights with a platform that helps teams refine and validate them in real contexts. Our goal is to make AI-powered schema design not just automated, but truly collaborative, helping teams stay agile as their products and data needs evolve.

Embrace Data Storytelling

I have yet to see a fully automated approach that captures every subtlety of real database design—and honestly, I’m relieved. The most engaging product conversations happen when you blend the raw horsepower of AI with the domain expertise of the people who understand why certain constraints or user flows matter.

Liam ERD isn’t trying to replace AI or overshadow your team’s talents. We aim to unify everything into one cohesive story. That’s how you spot hidden constraints, bring your organization together, and ensure every table, column, and index truly serves your vision.

Keep an eye on how Liam ERD continues to evolve. If you're curious about how visual storytelling can enhance AI-driven workflows, take a look. We'd love to hear how you're leveraging AI while staying focused on the bigger picture.

At the end of the day, it’s not about man versus machine—it’s about humans and AI working together to build stronger, more adaptable products, one data story at a time.

GitHub - liam-hq/liam: Automatically generates beautiful and easy-to-read ER diagrams from your database.

github.com

Text byTakafumi Endo

Takafumi Endo, CEO of ROUTE06, which develops Liam. After earning his MSc in Information Sciences from Tohoku University, he founded and led an e-commerce startup acquired by a retail company. He also served as an EIR at Delight Ventures.

Last edited on