17:I[76037,["5661","static/chunks/e0368f7a-821c8da51238c08a.js","4277","static/chunks/4277-bfec1f44484d71f2.js","8644","static/chunks/8644-53ba90288eed001f.js","9756","static/chunks/app/dean/projects/%5BprojectsSlug%5D/page-adeb69d10a5081a3.js"],"Separator"] 18:I[44562,["5661","static/chunks/e0368f7a-821c8da51238c08a.js","4277","static/chunks/4277-bfec1f44484d71f2.js","8644","static/chunks/8644-53ba90288eed001f.js","9756","static/chunks/app/dean/projects/%5BprojectsSlug%5D/page-adeb69d10a5081a3.js"],"default"] 19:T625,

SeeQL is an intuitive web-based visualizer for SQL databases that allows users to easily showcase the relations between their tables and the values within them. Designed to be as lightweight as possible, its core features can be run locally without the need for any servers, ensuring that it remains consistently functional and secure.

Inspired by how difficult it is for many beginners to get into backend design, particularly when trying to understand databases and how to work with them, my team and I made SeeQL for JamHacks 9 to help these people in particular by providing a universal medium - visuals - through which they can plan out what they need.

Technologies

ReactJS
Firebase
MaterialUI
Google Gemini
- Database normalization on user schemas

Features

Whiteboard interface
- Allows users to drag tables around, zoom in/out and pan throughout the page
Import of existing schemas
- Users can paste in SQL schemas and have them automatically imported to the whiteboard
Export to format of choice
- Upon finishing with their designs, users can export them as either Drizzle, Prism, SQL or Spring JPA schemas, ensuring there's no friction between ideation and implementation
Database normalization
- Using Gemini API, SeeQL can normalize the schemas created by users to optimize their programs