QueryGate is a full-stack, cloud-ready Database Management Studio built for the modern web. It provides developers with a seamless, high-performance interface to connect to databases, visualize schemas, and execute SQL queries without ever leaving the browser.
Designed with a premium glassmorphism UI, QueryGate combines the power of enterprise database tools with the aesthetics and speed of a modern single-page application.
- 💻 VS-Code-like SQL Editor: Powered by the Monaco Editor, featuring syntax highlighting, auto-completion, and multi-tab support.
- 🔐 Secure Authentication: Seamless Google OAuth 2.0 integration and stateless JWT authentication with BCrypt hashing and brute-force protection.
- 📊 ER Diagram Visualization: Automatically reverse-engineers database schemas to generate interactive Entity-Relationship diagrams.
- 📱 Responsive Glassmorphism UI: A stunning, mobile-first design with built-in Dark/Light mode toggling.
- 👥 Team Collaboration: Built-in team panel for managing workspaces and collaborating with multiple developers.
- ☁️ Cloud-Ready Architecture: Designed to be easily containerized and deployed across AWS infrastructure (EC2, RDS, Amplify).
- Frontend: React.js 18, Vite, React Router, React-Helmet-Async, Monaco Editor, Lucide Icons.
- Backend: Java 17, Spring Boot, Spring Data JPA, Spring Security, JSON Web Tokens (jjwt), Google API Client.
- Database: MySQL.
- Node.js (v18+)
- Java JDK 17
- Maven
- MySQL Server
git clone https://github.com/GarvXlearner/QueryGate.git
cd QueryGateEnsure your local MySQL server is running, then configure application.properties with your database credentials.
cd Backend
./mvnw spring-boot:runThe backend will start on http://localhost:8080
Open a new terminal window:
cd Frontend
npm install
npm run devThe frontend will start on http://localhost:5173
- Stateless JWTs: Secure token validation through custom Spring Security filters.
- Account Lockouts: Mitigates brute-force attacks by locking accounts after 3 failed password attempts.
- OAuth Verification: Cryptographic backend validation of Google ID tokens ensures completely secure third-party sign-ins.
Contributions, issues, and feature requests are welcome! Feel free to check the issues page.
Built with ❤️ by Garv