How raghuraj09/schemamorph-ai works
SchemaMorph AI turns uploaded PostgreSQL schemas and workload queries into proposed microservice boundaries, validation findings, per-service DDL, and reports. Its principal workflow is upload → parse → build and partition a weighted dependency graph → add AI narration → validate → generate outputs → inspect them in the dashboard. Authentication and project history support that workflow. The README documents the analysis stages and major UI capabilities; some backend orchestration and frontend page wiring were not sampled, so those links rely on README statements rather than inspected call sites.
Main entry points: analysis.py Analysis endpoint · Dashboard.jsx Analysis dashboard · router.py Versioned API routes · client.js HTTP API client
Components 25
Web experience
- Web app routing
frontend/src/App.jsx - Schema upload
frontend/src/pages/Upload.jsx - Analysis dashboard
frontend/src/pages/Dashboard.jsx - Project history
frontend/src/pages/History.jsx - Graph visualization
frontend/src/components/GraphView.jsx - Service details
frontend/src/components/ServicePanel.jsx - Query findings
frontend/src/components/QueryDiff.jsx - HTTP API client
frontend/src/api/client.js - Authentication state
frontend/src/store/authStore.js
API and persistence
- Versioned API routes
backend/app/api/v1/router.py - Schema endpoints
backend/app/api/v1/schema.py - Query endpoints
backend/app/api/v1/queries.py - Analysis endpoint
backend/app/api/v1/analysis.py - Project and run store
backend/app/models/database.py
Decomposition engine
- DDL parser
backend/app/parsers/schema_parser.py - Workload parser
backend/app/parsers/query_parser.py - Dependency graph
backend/app/graph/builder.py - Community detection
backend/app/graph/clusterer.py - AI narration
backend/app/ai/engine.py - Analysis prompts
backend/app/ai/prompts.py - Integrity validation
backend/app/validation/validator.py - DDL and reports
backend/app/reports/generator.py
Identity
- Authentication endpoints
backend/app/api/v1/auth.py - JWT and passwords
backend/app/core/security.py
Other components
- Engineer
Connections 27
- Engineer → Web app routing: uses
README.md - Web app routing → Schema upload: routes to
frontend/src/App.jsx - Web app routing → Analysis dashboard: routes to
frontend/src/App.jsx - Web app routing → Project history: routes to
frontend/src/App.jsx - Schema upload → HTTP API client: uploads inputs
README.md - Analysis dashboard → HTTP API client: requests analysis
README.md - Analysis dashboard → Graph visualization: shows graph
README.md - Analysis dashboard → Service details: shows services
README.md - Analysis dashboard → Query findings: shows query findings
README.md - Project history → HTTP API client: loads projects
README.md - HTTP API client → Authentication state: reads token
frontend/src/api/client.js - HTTP API client → Versioned API routes: calls endpoints
README.md - Versioned API routes → Schema endpoints: registers routes
backend/app/api/v1/router.py - Versioned API routes → Query endpoints: registers routes
backend/app/api/v1/router.py - Versioned API routes → Analysis endpoint: registers routes
backend/app/api/v1/router.py - Schema endpoints → DDL parser: parses DDL
README.md - Query endpoints → Workload parser: parses queries
README.md - Analysis endpoint → Dependency graph: builds graph
README.md - Analysis endpoint → Community detection: partitions graph
README.md - Analysis endpoint → AI narration: requests narration
README.md - AI narration → Analysis prompts: formats prompts
backend/app/ai/engine.py - Analysis endpoint → Integrity validation: validates partitions
README.md - Analysis endpoint → DDL and reports: generates outputs
README.md - Analysis endpoint → Project and run store: persists runs
- Authentication endpoints → Project and run store: reads and writes users
backend/app/api/v1/auth.py - Authentication endpoints → JWT and passwords: hashes and signs
backend/app/api/v1/auth.py - Versioned API routes → Authentication endpoints: registers routes
backend/app/api/v1/router.py