Skip to content

Ritikgit789/sqlgpt

Repository files navigation

SQLGPT 🧠💾

Your Smart Database Companion

SQLGPT is a full-stack AI-powered web app designed to simplify learning and working with SQL and database concepts. Whether you're a beginner exploring databases or a professional writing complex queries, SQLGPT provides instant answers, explanations, and code samples using natural language understanding.


🚀 Features

  • Ask anything: Get answers to SQL queries, database concepts, optimization tips, and best practices.
  • 💡 Natural Language Understanding: Type your questions in plain English — SQLGPT understands you.
  • 💬 Code Generation: Automatically generate SQL code snippets based on your input.
  • 🎨 Theme Toggle: Switch between light and dark mode for comfort.
  • Fast & Responsive UI: Built with Vite and Tailwind CSS.
  • 🌐 Deployed on Vercel: Easily accessible online, can be used by no of people, scaled system.

🛠 Tech Stack

Layer Technology
Frontend React, Vite
Styling Tailwind CSS
AI/NLU Gemini (LLM)
Deployment Vercel

📚 Use Cases

  • 🧑‍🎓 Students learning SQL or databases
  • 🧑‍💻 Developers working with relational databases
  • 🔍 Quick reference for SQL syntax, clauses, joins, functions, etc.
  • 🏗️ Generate real-world SQL queries from English prompts

🧪 Example Prompts

  • "Write a SQL query to get the top 5 highest paid employees."
  • "What's the difference between INNER JOIN and LEFT JOIN?"
  • "How do I optimize a slow SELECT query?"
  • "Give a sample code to find the second highest salary from an employees table without using LIMIT or TOP."
  • "Explain normalization with examples."

📦 Getting Started (Local Development)

# Clone the repo
git clone https://github.com/yourusername/sqlgpt.git
cd sqlgpt

# Install dependencies
npm install

# Run the development server
npm run dev

🌍 Deployment The project is deployed on Vercel. To deploy your own version: Fork this repo Connect your GitHub account to Vercel Import the repo and deploy with default settings

Configuration

    • Replace the API integration with your own Gemini API key if required for production use.

🤝 Contributing Pull requests are welcome! For major changes, please open an issue first to discuss what you’d like to change.

Its an normal application rather than chatgpt or any other GPTs like here only user can get SQL queries and concepts and answers responses

🙋‍♂️ Why SQLGPT? Because every developer, analyst, or data enthusiast needs a reliable assistant while working with databases. SQLGPT makes it easier, faster, and smarter.

About

SQLGPT – Your AI-powered companion for writing, learning, and mastering SQL.

Resources

Stars

Watchers

Forks