ZhaoDe Chee@JasonChee

LegacyLink AI is an AI-assisted legacy database modernization tool built for the IBM Bob Hackathon. It helps developers convert messy legacy SQL schemas into clean Python SQLAlchemy ORM project scaffolds, reducing the time needed to understand old database structures and generate boilerplate code. The system lets users upload a legacy SQL file, then automatically parses database objects such as tables, columns, data types, indexes, constraints, views, and functions. It normalizes cryptic names into readable conventions, such as converting tbl_CUST_MSTR_2012_v2 into Customer, fk_str_id into store_id, and dt_upd_dt into updated_at. LegacyLink AI generates a downloadable project containing SQLAlchemy 2.0 ORM models, database setup code, pytest test files, requirements.txt, README documentation, and a modernization report explaining the transformation. The generated project can be tested immediately using pytest. The project also includes an optional IBM watsonx.ai AI Assistant powered by IBM Granite. The assistant helps users explain schemas, summarize modernization reports, identify possible foreign-key-like fields, and understand generated ORM code in simple English. For enterprise traceability, AI Assistant interactions can be logged into PostgreSQL. IBM Bob can then connect through MCP to inspect the audit logs and summarize recent assistant activity, including the user question, model used, SQL file processed, table count, and status. IBM Bob was used as the development partner for planning, coding, debugging, testing, documentation, and MCP workflow validation. The final result combines Streamlit, SQLAlchemy, pytest, IBM watsonx.ai, PostgreSQL, MCP, and IBM Bob into a practical modernization workflow for legacy database teams.

Build solutions that improve how software is built. Work with an AI that understands your codebase, helping you reduce repetitive work and build with real context. ⏳ Build your project in 48 hours. 🚀 Get hands-on with IBM Bob and explore how AI fits into real development workflows before it becomes standard. 💡 Build tools and workflows that developers would actually use. ⭐ Learn directly from experts throughout the event. 🤝 Join a team or build solo. 💰 Prize pool: $10,000 🧑🏻‍💻 Register before the Kick-Off Stream and start building with Bob.