A modern database visualizer with analytics and AI-powered query generation. Making database management cool again.

• 🔐 Secure Authentication - JWT-based auth with HTTP-only cookies
• 🔌 Multi-Database Support - Connect to PostgreSQL, MySQL, and more
• 📊 Visual Table Explorer - Browse, search, filter, and edit data
• 📈 Custom Dashboards - Build analytics dashboards with widgets
• 🤖 AI Query Generation - Write queries in plain English
• 🗺️ ERD Visualization - Auto-generated entity relationship diagrams
• ⚡ SQL Editor - Execute queries with syntax highlighting
• 📜 Query History - Save and reuse your queries

• Node.js >= 18.0.0
• PostgreSQL >= 14
• npm or yarn

1. Clone the repository

   git clone https://github.com/ayan-mn18/ChatSQL.git
   cd ChatSQL

2. Install dependencies

   npm install

3. Set up environment variables

   cp .env.example .env
   # Edit .env with your configuration

4. Set up the database

   # Create the database
   createdb chatsql
   
   # Run the complete schema migration
   psql -U postgres -d chatsql -f database/migration-v0/schema.sql
   
   # Optional: Add seed data for development
   psql -U postgres -d chatsql -f database/seed.sql

   See DATABASE_SETUP.md for detailed instructions.

5. Start the development server

   npm run dev

The API will be available at http://localhost:3000

ChatSQL/
├── database/
│   ├── migration-v0/
│   │   └── schema.sql      # Complete database schema (v0)
│   ├── seed.sql            # Seed data (optional)
│   └── README.md           # Database documentation
├── src/
│   ├── config/             # Configuration files
│   ├── controllers/        # Route controllers
│   ├── middleware/         # Express middleware
│   ├── routes/             # API routes
│   ├── services/           # Business logic
│   ├── types/              # TypeScript types
│   └── utils/              # Utility functions
├── server.ts               # Application entry point
└── package.json

More endpoints coming soon...

1. User registers with email/password
2. System sends 6-digit OTP to email
3. User enters OTP to verify email
4. User can now login with verified email
5. JWT token stored in HTTP-only cookie
6. Logout clears the cookie

# Run in development mode with hot reload
npm run dev

# Build for production
npm run build

# Start production server
npm start

• Project setup & authentication
• Connection management
• Schema & metadata APIs
• Table data CRUD
• SQL query execution
• AI query generation
• Dashboard & widgets
• ERD visualization

Contributions are welcome! Please feel free to submit a Pull Request.

1. Fork the repository
2. Create your feature branch (git checkout -b feature/AmazingFeature)
3. Commit your changes (git commit -m 'Add some AmazingFeature')
4. Push to the branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

This project is licensed under the MIT License - see the LICENSE file for details.

• Built with Express.js
• Database ORM by Sequelize
• AI powered by OpenAI & Anthropic

Made with ❤️ by Ayan