LegacyLink AI

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.