How rohan28107/schemagit works
SchemaGit versions database schemas through a user-facing workflow: import a SQL schema, branch and commit changes, compare branches, merge (resolving conflicts when needed), then apply the selected schema to a live MySQL/TiDB database. The server parses SQL, models and diffs structured snapshots, plans migrations, and executes and verifies changes; Prisma-backed metadata tracks project history. The README also describes online schema change for risky operations. Some subsystems are documented but not fully sampled, so their internal links are omitted where source evidence is unavailable.
Main entry points: App.jsx App workflow · projectRoutes.js Project routes · schemaEngine.js Schema engine · projectApi.js Project API client
Components 19
SchemaGit UI
- App workflow
client/src/App.jsx - Project import
client/src/components/ProjectInitializer.jsx - Branch manager
client/src/components/BranchManager.jsx - Commit form
client/src/components/CommitForm.jsx - Schema explorer
client/src/components/SchemaExplorer.jsx - Diff results
client/src/components/DiffResults.jsx - Conflict resolver
client/src/components/ConflictResolver.jsx - Merge request
client/src/components/MergeRequest.jsx - Status banner
client/src/components/ProjectStatusBanner.jsx
API and Workflow
- Project API client
client/src/api/projectApi.js - Project routes
server/src/routes/projectRoutes.js
Schema Processing
- SQL parser
server/src/engine/sqlParser.js - Schema engine
server/src/engine/schemaEngine.js - Conflict service
server/src/services/ConflictService.js - Execution engine
server/src/engine/executionEngine.js
Persistence and Database
- Connection manager
server/src/utils/connectionManager.js - Schema history
server/prisma/schema.prisma
Other components
- Engineer
- MySQL / TiDB
Connections 21
- Engineer → App workflow: uses
README.md - App workflow → Project import: renders
client/src/App.jsx - App workflow → Branch manager: renders
client/src/App.jsx - App workflow → Commit form: renders
client/src/App.jsx - App workflow → Schema explorer: renders
client/src/App.jsx - App workflow → Diff results: renders
client/src/App.jsx - App workflow → Conflict resolver: renders
client/src/App.jsx - App workflow → Merge request: renders
client/src/App.jsx - App workflow → Status banner: renders
client/src/App.jsx - App workflow → Project API client: calls
client/src/App.jsx - Project API client → Project routes: sends REST requests
client/src/api/projectApi.js - Project routes → Schema history: reads and writes
server/src/routes/projectRoutes.js - Project routes → SQL parser: parses imports
server/src/routes/projectRoutes.js - Project routes → Schema engine: diffs and plans
server/src/routes/projectRoutes.js - Project routes → Conflict service: detects conflicts
server/src/routes/projectRoutes.js - Project routes → Connection manager: opens connections
server/src/routes/projectRoutes.js - Project routes → Execution engine: executes plans
README.md - Connection manager → MySQL / TiDB: connects
server/src/utils/connectionManager.js - Schema engine → MySQL / TiDB: inspects schema
README.md - Execution engine → MySQL / TiDB: applies DDL
README.md - Conflict service → Schema engine: uses schema logic
server/src/services/ConflictService.js