Liam ERD is a full-stack application for database schema visualization, design, and collaboration. It parses schemas from multiple formats (PostgreSQL, Prisma, Drizzle, Rails, tbls) and renders interactive ER diagrams in the browser via a CLI tool and a Next.js web app. The system integrates AI agents built with LangGraph that assist users in evolving schemas: a lead agent classifies intent, a PM agent analyzes requirements, a DB agent generates migrations via JSON Patch operations, and a QA agent produces and validates pgTAP tests. The web app supports organization/project management, GitHub OAuth, real-time streaming chat with agents, schema versioning with diff view, public sharing, and a command palette for navigating ERDs. The backend uses Supabase for auth, database, realtime, and blob-based checkpoint persistence. The monorepo also includes a component library, MCP server for Cursor IDE, schema evaluation benchmarks, and comprehensive test coverage (Vitest, Playwright, Storybook).
drawDB is a free, open-source, client-side web application for designing relational database schemas and generating SQL. It provides an interactive ER diagram editor with support for multiple database dialects (MySQL, PostgreSQL, SQLite, MariaDB, MSSQL, Oracle), import/export in SQL, DBML, JSON, Mermaid, and Markdown, and features like auto-arrange, auto-connect foreign keys, schema validation, migration generation, and versioning via GitHub Gists. The architecture is a React single-page application (Vite + Tailwind CSS + Semi UI) with state managed through custom React Contexts and hooks, persistence via IndexedDB (Dexie), and an optional cloud backend through an extension system. It is primarily an application, with no data research or ML components.