Schema Craft AI 🧠✨

Database Schema Design & Code Generation Powered by AI

✨ Project Overview

Schema Craft AI is an open-source tool that helps you quickly design database schemas and generate boilerplate code for various technology stacks. It streamlines the development process by allowing you to:

1. 💬 Design your database schema using natural language (powered by AI)
2. 📊 Visualize your entities and relationships with an interactive diagram
3. 🛠️ Generate code for your chosen tech stack
4. 📦 Download a complete bundle with models, routers, and schemas

🚀 Live Demo

Try out Schema Craft now: https://schemacraftai.vercel.app/

Note: You will need to provide your own OpenAI API key in the sidebar for the AI functionality to work.

🔧 Technologies Used

This project is built with:

• Vite - Fast development environment
• TypeScript - Type-safe JavaScript
• React - UI framework
• shadcn-ui - Beautiful UI components
• Tailwind CSS - Utility-first CSS
• ReactFlow - Interactive node-based UI
• OpenAI API - AI-powered schema generation

🏁 Getting Started

To run this project locally:

# Step 1: Clone the repository
git clone https://github.com/turazashvili/SchemaCraftAI.git

# Step 2: Navigate to the project directory
cd SchemaCraftAI

# Step 3: Install the necessary dependencies
npm install

# Step 4: Start the development server
npm run dev

🌐 Deployment on Vercel

This project is configured for easy deployment on Vercel:

1. Push your code to GitHub

   git add .
   git commit -m "Ready for deployment"
   git push
   

2. Deploy to Vercel

   • Create a Vercel account if you don't have one
   • Import your GitHub repository (SchemaCraftAI)
   • Vercel will automatically detect the Vite configuration
   • Click "Deploy"

3. Environment Variables
   No special environment variables are required for basic functionality.

✅ Features

• Natural Language Schema Generation: Describe your database in plain English ✅
• Visual Schema Designer: See and edit your database entities and relationships ✅
• Multiple Technology Stacks: Generate code for TypeScript, JavaScript, Python, and more ✅
• Multiple Database Types: Support for PostgreSQL, MongoDB, MySQL, and others ✅
• Code Generation: Automatically create models, routes, and schemas ✅
• Auto-save: All changes are automatically saved ✅

📋 TODOs

• Support for additional AI providers (Claude, Gemini, etc.)
• Custom schema templates
• Team collaboration features
• Integration with version control systems
• Automated database migration scripts
• More advanced relationship mapping
• Improved error handling and validation
• User accounts and saved projects

📖 How to Use

1. Visit the live demo
2. Enter your OpenAI API key in the sidebar
3. Describe your database schema in the left sidebar
4. Review and modify the generated schema visualization
5. Select your preferred technology stack
6. Generate and download the code bundle

👨‍💻 Creator

This project was created by Nikoloz Turazashvili.

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

📄 License

MIT