DB-builder

• 

  screenshot 1(Dashboard to manage your working projects)

• 

  screenshot 2(workspace with infinity space to work in)

• 

  screenshot 3(tidy up the tables)

• 

  screenshot 4(generating the SQL code)

DB-Builder: Visual Database Schema Designer with Real-Time SQL Generation

Description: DB-Builder is a modern, interactive web application for visually designing database schemas. It provides a drag-and-drop canvas where users can create tables, define columns with data types, establish relationships (foreign keys), and instantly generate production-ready SQL code. Traditional database design often requires switching between ERD tools, documentation, and manual SQL writing. This tool streamlines the entire workflow into a single, intuitive interface that combines visual design with automatic code generation, making database architecture accessible to both beginners and experienced developers.

Features: • Interactive Canvas with Real-Time Collaboration: Built with React Flow, featuring pan, zoom, minimap navigation, and an intelligent auto-layout ("Tidy Up") function using graph algorithms • Instant SQL Generation: Automatically converts your visual schema into PostgreSQL/MySQL-compatible CREATE TABLE statements with proper foreign key constraints • Cloud Persistence with Supabase: Projects are saved to the cloud with authentication, allowing you to work from anywhere and collaborate with others • Smart Validation & Error Recovery: Built-in compiler that validates your schema, detects issues (orphaned relations, missing IDs), and auto-fixes common problems • Export & Screenshot Features: Download SQL files or capture high-quality screenshots of your database architecture for documentation • Production-Ready Stack: TypeScript, React 19, Zustand for state management, Monaco Editor for code viewing, and a glassmorphic UI with Tailwind CSS for a polished developer experience The combination of visual design, instant feedback, and production-quality SQL output makes this tool a practical solution for rapid prototyping, teaching database concepts, or planning complex data architectures.

Built With

• beautiful-soup
• fastapi
• json
• kaggle
• node.js
• opencv
• postgresql
• python
• qwen-2.5-(7b-instruct
• react
• sql
• supabase
• tesseractocr
• transformers
• typescript
• vercel