Visual Schema Designer
Deep dive into our drag-and-drop interface for modeling complex databases.
Visual Schema Designer
The FluxStack Visual Designer is built for speed, accuracy, and enterprise-scale modeling.
1. The Infinite Canvas
Our engine is powered by React Flow, optimized for hundreds of tables.
- Panning: Click and drag the background or use your trackpad.
- Zooming: Use your scroll wheel or pinch to zoom.
- Auto-Layout: Use the layout button in the toolbar to instantly organize your schema into logical clusters.
2. Table Modeling
Each table is represented as a node on the canvas.
- Columns: Click any column to edit its name, type, and constraints.
- Relationships: Drag from one table to another to create a relationship. FluxStack automatically creates the Foreign Key columns and indexes.
- Validation: Look for the "Validation" badge in the sidebar. We catch circular dependencies and missing Primary Keys before you deploy.
3. Real-time SQL Preview
Toggle the "SQL Preview" drawer to see exactly what SQL is being generated as you move tables and edit columns. We support:
- PostgreSQL (JSONB, UUID, Arrays)
- MySQL (ENUMs, Datetime)
- SQLite & SQL Server
4. AI Copilot
The AI Assistant panel (Cmd+J) allows you to describe changes in natural language.
"Change the orders table to use UUIDs instead of Serial IDs and add a JSONB metadata field." The AI will apply these changes directly to your visual model.