Imagine running a full PostgreSQL database directly in your browser without any server setup—pure, instant, and local. Meet PSQLab, an innovative UI built on pglite, that lets you experiment with PostgreSQL natively on the frontend. Whether you’re a college student learning SQL, a developer prototyping new ideas, or a curious mind exploring in-browser databases, PSQLab is designed just for you. 🧑‍💻📘

🔍 What is PSQLab?

PSQLab is a free, interactive playground that harnesses the power of pglite—a lightweight WebAssembly build of PostgreSQL—to deliver a full-fledged SQL database experience right in your browser. It comes with a modern, notebook-style interface reminiscent of Jupyter notebooks 🧪 where each executable block ties its own query result. This setup not only makes learning fun and interactive but also transforms the way you prototype and test database-driven applications.

⚙️ How It Works

At its core, PSQLab leverages pglite to run a complete PostgreSQL database in-browser. Here’s how it transforms your workflow:

  • 🖥️ In-Browser PostgreSQL: Forget about installing and configuring a server. With pglite, PostgreSQL runs seamlessly in your browser.
  • 📒 Notebook Interface: Write, execute, and view SQL queries in distinct blocks, just like a Jupyter notebook. Each block maintains its own query history and results.
  • 💾 Persistent Changes: All your modifications and data are stored in your browser’s local storage, ensuring that your work is preserved between sessions.
  • 🤖 Smart Suggestions: As you type your queries, the UI offers intelligent suggestions to speed up your workflow.
  • 🌗 Customizable Themes: Switch effortlessly between dark and light themes for a personalized coding environment.

✨ Key Features

  • 🧩 Full PostgreSQL Experience: Run almost any psql query and leverage many PostgreSQL features, all within your browser.
  • 🧱 Interactive Blocks: Execute multiple query blocks with their own output, making experimentation and debugging a breeze.
  • 🧑‍🤝‍🧑 Preloaded Social Media Schema: Dive straight into exploring a sample Social Media network database schema, complete with sample data.
  • 🧠 Intelligent Autocomplete: Get suggestions while typing to reduce errors and boost productivity.
  • 🎨 Responsive Design: Enjoy a polished UI with support for both dark and light themes.

🎓 Who Can Benefit?

PSQLab is perfect for:

  • 🧑‍🎓 College Students: Learn SQL hands-on without needing expensive software or backend setups.
  • 👨‍💻 Developers and Hobbyists: Prototype, test, and share database experiments quickly.
  • 🧑‍🏫 Educators: Use it as a teaching tool in the classroom for interactive database lessons.
  • 🌐 Anyone Curious About Databases: Explore PostgreSQL in a friendly, accessible environment.

🛠️ Contribute & Expand

While PSQLab already packs powerful features, there’s plenty of room for innovation:

  • 🧰 UI Add-Ons: Enhance the interface with custom widgets, more advanced themes, or additional query visualization tools.
  • 🧠 AI Integration: Imagine an assistant that not only suggests code but can also debug your queries or optimize them in real-time.
  • 🆕 New Features: Extend support for additional PostgreSQL functionalities or integrate collaborative features for multi-user sessions.

Your contributions can make PSQLab even better. Whether you’re a seasoned developer or a newcomer, your ideas and code are welcome! 💡

🌐 Try It Out!

👉 Visit the live demo at: psqlab.neetigya.me\
🔗 Check out the source code on GitHub: github.com/neetigyachahar/PSQLab

Below is a screenshot of the PSQLab interface:

PSQLab Editor

🤝 Let’s Connect

I’m always excited to discuss ideas, get feedback, and collaborate on this project. Feel free to reach out:

Jump in, explore, and help shape the future of in-browser databases. PSQLab is completely free—built with passion and open for contributions. Let’s build something amazing together! ✨

Happy querying! 🐘💻