SQL Compiler bridges the gap between theoretical SQL learning and practical execution. Dive into extensive tutorials, practice queries in real-time within your browser, and get instant, proactive feedback on syntax errors powered by state-of-the-art AI integration.

⚡ Live SQL Editor

Execute queries in real-time straight from your web browser without the hassle of spinning up local database GUI tools.

✨ AI Query Fixer (Powered by Gemini)

Never get stuck on a syntax error again! The integrated Gemini 2.5 Flash API automatically catches mistakes, offers deep insights, and reconstructs invalid SQL operations.

📚 Interactive Learning Hub

Features extensive, pre-built SQL tutorials ranging from basic SELECT statements to masterful JOIN operations and complex sub-queries.

🔒 Secure Authentication & Sandboxing

Secure account creation, password resets via SMTP, CSRF protections, and sandboxed database sessions ensure every user query is isolated and perfectly secure.

• Backend: Native PHP 8.0+
• Database: MySQL / MariaDB (Managed via PDO)
• AI Integration: Google Generative AI (Gemini API)
• Frontend / UI: Vanilla HTML/CSS with JavaScript execution layers

Ensure your host server is running:

• PHP 8.0+ with PDO/MySQL extensions enabled
• MariaDB (10.6+) or native MySQL

1. Import the stripped schema layout onto your local/development database using the included unmqwlgl_sql.sql file.
2. Open config/db_control.php and configure the constants to match your server instance:

   define('DB_HOST', 'localhost');
   define('DB_CONTROL_NAME', 'your_db_name');
   define('DB_USER', 'your_db_user');
   define('DB_PASS', 'your_db_password');

1. Go to Google AI Studio and generate a free API key.
2. In includes/AIHelper.php, replace the placeholder with your key:

   $this->apiKey = 'YOUR_GEMINI_API_KEY'; 

3. Open forgot_password.php and configure the SimpleSMTP initiation block with your mail server's credentials.

Launch via PHP's built-in webserver. From the project root, simply run:

php -S localhost:8000

Open your browser to http://localhost:8000 to begin.