easySQL is an innovative SQL database interaction platform that enables natural language conversations with your PostgreSQL database. With its modern, minimalist interface and powerful backend processing, easySQL makes database operations more intuitive and accessible for both technical and non-technical users.
- 🤖 Natural Language Processing: Interact with your database using conversational language
- 🔒 Secure Database Connection: Encrypted credential handling and secure session management
- 💫 Modern UI: Clean, responsive interface with smooth animations
- ⚡ Real-time Validation: Instant feedback on connection status and query execution
- 🛠️ Comprehensive Error Handling: User-friendly error messages with suggested solutions
Main interface showing natural language query input
Query results with interactive data visualization
- Node.js (v14 or higher)
- Python (v3.8 or higher)
- PostgreSQL database
- Clone the repository:
git clone https://github.com/yourusername/easysql.git
cd easysql- Install backend dependencies:
cd app
pip install -r requirements.txt- Install frontend dependencies:
cd frontend
npm install- Set up environment variables:
Create a
.envfile in the root directory with the following variables:
DB_HOST=localhost
DB_PORT=5432
DB_NAME=your_database
DB_USER=your_username
DB_PASSWORD=your_password- Start the backend server:
cd app
uvicorn main:app --reload- Start the frontend development server:
cd frontend
npm start- Open your browser and navigate to
http://localhost:3000
- React.js
- Framer Motion for animations
- CSS Modules for styling
- FastAPI
- SQLAlchemy
- Langchain for NLP
- PostgreSQL
- Connect to your database using the configuration form
- Start chatting with your database using natural language
- View query results in real-time
- Explore database structure and relationships naturally
easySQL takes security seriously:
- All database credentials are encrypted
- Secure session management
- No storage of sensitive information
- Automatic connection timeout handling
Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.
- Fork the repository
- Create your feature branch (
git checkout -b feature/AmazingFeature) - Commit your changes (
git commit -m 'Add some AmazingFeature') - Push to the branch (
git push origin feature/AmazingFeature) - Open a Pull Request
This project is licensed under the MIT License - see the LICENSE file for details.
- FastAPI for the powerful backend framework
- React for the frontend library
- Framer Motion for the smooth animations
- Langchain for natural language processing capabilities
Your Name - @Amansoni
Made with ❤️ for better database interactions