Table Relation Analyzer

1. What This Tool Does

Scans MyBatis XML files, parses table and JOIN relationships in SQL, and visualizes the table dependency graph to help you quickly understand data relationships and impact scope.

2. Tech Stack

• Next.js (App Router)
• React + TypeScript
• Node.js file scanning and parsing

3. Project Structure

• src/app: Pages and components
• src/app/components: Core UI components
• public: Static assets
• sample-data/mybatis: Sample MyBatis XML data
• .cache/table-relations: Scan cache output (default)

4. How To Use

1. Install dependencies and start the dev server:

npm install
npm run dev

2. Open http://localhost:3000
3. Load data in one of the following ways:

• Click “Use sample XML data” in the UI
• Or input the directory: sample-data/mybatis

4. Enter a table name (e.g. ORDERS or USERS) and start scanning

5. Notes

• Scan results are cached in the browser (tabs and pagination) and on the server (by file hash).
• The default cache directory is .cache/table-relations and can be cleared as needed.