A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, Crate, Vertica, and Presto. Written in Node.js.
Visit project page at http://rickbergfalk.github.io/sqlpad/.
Using docker
# To build initial image (and force rebuild)
docker-compose build --no-cache web
docker-compose create --force-recreate web
# Start sqlpad in dev mode and bring dockerized db's up
docker-compose up
# To bring down
docker-compose down
# To remove dangling containers volumes etc
docker system pruneLocally
- Clone/download repo
- Install node 6 or later
- Install npm5
- run
npm startfrom command line
Once Running At this point you should have both backend and front-end development servers running.
http://localhost:3000 serves react front-end in dev-mode http://localhost:3010 serves front-end compiled for production
Both front-end/back-end should auto-refresh/auto-reload on file change.
To build front-end production files run npm run build.
See wiki for additional development details and project information.
If you have highlighted just part of your query, only that part will be executed when you click Run Query.
MIT