SchemaCraft

Tech Stack
Overview
Problem Solved
Solution
Workflow
- Schema Design: Visually create data models with fields, types, validations, and relationships
- Configuration: Set authentication rules, rate limits, and access controls
- Generation: Click generate to produce Go source code with full CRUD operations
- Review: Inspect the generated Swagger documentation and test endpoints
- Deployment: Deploy to AWS EC2 with a single click using pre-built Docker images
- Monitoring: Track API usage, errors, and performance from the admin dashboard
- Iteration: Modify schemas and redeploy with automatic database migrations
Technical Highlights
- Frontend: React with TypeScript, DnD libraries for schema design, Tailwind CSS
- Backend: Go with a custom code generation engine using Go's text/template
- Code Quality: Generated code includes input validation, SQL injection protection, and RBAC
- Database: MongoDB for schema storage; generated APIs support PostgreSQL, MySQL, or MongoDB
- DevOps: Docker containers, AWS EC2 deployment, GitHub Actions CI/CD
- Documentation: Auto-generated Swagger/OpenAPI specs for every created API
Key Takeaways
Features
Visual schema designer with instant API generation
Auto-generated CRUD endpoints with authentication
Admin dashboard for user and role management
Swagger UI for interactive API documentation
Real-time collaboration on schema changes
One-click deployment to AWS EC2 with Docker
GitHub Actions CI/CD pipeline
Rate limiting and API key management
Architecture
SchemaCraft is a SaaS platform with a React TypeScript frontend and Go backend. The backend includes a dynamic code generation engine that translates visual schemas into Go source code with full CRUD handlers, middleware, and database migrations. MongoDB persists schemas and generated API configs. The platform is containerized with Docker and deployed on AWS EC2. CI/CD is handled by GitHub Actions.
API & System Flow
User defines a schema via the React frontend → Frontend sends schema JSON to Go backend → Backend validates and generates Go structs, handlers, and routes → Generated code is compiled into a microservice → Microservice is deployed as a Docker container → End user receives Swagger docs and live API endpoints with JWT authentication.
Challenges & Solutions
Built a Go code generation engine using text/template with built-in security patterns including input validation, SQL injection prevention, and RBAC middleware.
Related Projects

App Lens
AppLens is a full-stack web application designed to help developers and designers create professional app store screenshots and promotional graphics for iOS and Android applications. With an intuitive visual editor, pre-designed templates, and powerful customization options.

Schema Builder
Intelligent full-stack database schema designer that revolutionizes database modeling: visually design schemas with AI-powered chat assistance, create tables and relationships through an intuitive canvas, get instant SQL generation and real-time collaboration. Built with React TypeScript + Vite frontend, Go backend with MongoDB, Firebase authentication with Google OAuth, and AI-driven schema recommendations for seamless database architecture planning.

Funutrition
Developed Funutrition, an interactive kids' app designed by a dietitian to make learning about healthy eating fun. Features include educational games, healthy recipes, expert nutrition tips, and progress tracking. The app helps children build lifelong healthy habits while supporting parents with guidance and insights.
