Skip to content

neetigyachahar/PSQLab

Repository files navigation

🚀 PSQLab – Your In-Browser PostgreSQL Playground

PSQLab is a free, interactive UI built on top of pglite, allowing you to run a full PostgreSQL database natively in your browser — no server or setup required.

✨ Features

  • 🧠 Jupyter-style interface – Write and run SQL in multiple executable blocks.
  • 🗃️ Example social media schema – Preloaded for hands-on experimentation.
  • 💾 Persistent storage – Your data and changes are saved in browser local storage.
  • Smart autocomplete – Suggestions while typing to speed up querying.
  • 🌗 Light/Dark themes – Customize the look to suit your vibe.
  • 🐘 Real PostgreSQL in-browser – Built with pglite (WASM-based Postgres).

🎯 Who is it for?

  • 👩‍🎓 Students – Learn and practice SQL without any installation.
  • 👨‍💻 Developers – Quickly prototype or test queries.
  • 🧑‍🏫 Educators – Use in classrooms as a lightweight teaching tool.
  • 🤹 Anyone curious about databases.

💡 Contribute!

Want to help shape the future of in-browser SQL tools? You can:

  • Add AI-based query suggestions 🤖
  • Improve UI/UX components 🧩
  • Add multi-user or collaborative features 🔄

🔗 Useful Links

Let’s build the future of database playgrounds together. Star ⭐️ the repo, use it, and contribute!



React + TypeScript + Vite

This template provides a minimal setup to get React working in Vite with HMR and some ESLint rules.

Currently, two official plugins are available:

Expanding the ESLint configuration

If you are developing a production application, we recommend updating the configuration to enable type aware lint rules:

  • Configure the top-level parserOptions property like this:
export default tseslint.config({
  languageOptions: {
    // other options...
    parserOptions: {
      project: ["./tsconfig.node.json", "./tsconfig.app.json"],
      tsconfigRootDir: import.meta.dirname,
    },
  },
})
  • Replace tseslint.configs.recommended to tseslint.configs.recommendedTypeChecked or tseslint.configs.strictTypeChecked
  • Optionally add ...tseslint.configs.stylisticTypeChecked
  • Install eslint-plugin-react and update the config:
// eslint.config.js
import react from "eslint-plugin-react"

export default tseslint.config({
  // Set the react version
  settings: { react: { version: "18.3" } },
  plugins: {
    // Add the react plugin
    react,
  },
  rules: {
    // other rules...
    // Enable its recommended rules
    ...react.configs.recommended.rules,
    ...react.configs["jsx-runtime"].rules,
  },
})

About

Write PSQL query in browser, natively.

Topics

Resources

Stars

Watchers

Forks