A web-based interactive playground to experiment with PostgreSQL queries in real-time. Built using Flask and Docker, this project provides a safe, isolated environment for learning and testing SQL queries with PostgreSQL.
- ✅ Run PostgreSQL queries in a sandboxed environment
- 🐳 Dockerized for easy local setup
- ⚡ Fast response with a clean and interactive UI
- 📦 Minimal dependencies, quick to get started
Click the preview above to watch the demo on YouTube.
- Backend: Python, Flask
- Database: PostgreSQL
- Frontend: HTML, CSS, JavaScript
- Containerization: Docker, Docker Compose
.
├── app.py
├── CONTRIBUTING.md
├── docker-compose.yml
├── Dockerfile
├── LICENSE
├── Readme.md
├── requirements.txt
├── static
│ ├── css
│ │ └── styles.css
│ ├── images
│ │ ├── favicon.png
│ │ └── screenshot.png
│ └── js
│ ├── editorManager.js
│ ├── script.js
│ └── tableManager.js
└── templates
└── index.html
Clone the repository and start the containers:
git clone https://github.com/YOUR_GITHUB_USERNAME/postgresql-playground.git
cd postgresql-playground
docker-compose up --buildThen open your browser and go to:
http://localhost:8080
- Type your SQL queries into the provided interface.
- Click Run to execute the query.
- See results immediately from the PostgreSQL database.
⚠️ This is for educational/demo purposes. Not recommended for production environments without modification.
Contributions are welcome!
Here’s how you can help:
- ⭐ Star this repo to show support
- 🐞 Report bugs or request features via Issues
- 📥 Fork the repo and submit a pull request
Please read the CONTRIBUTING.md for guidelines.
This project is licensed under the MIT License.
- Inspired by online SQL playgrounds and educational tools.
- Thanks to the open-source community for libraries and tools!
Created by [Aman Ranjan Verma] – Linkedin