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 https://rickbergfalk.github.io/sqlpad/.
- Clone/download repo
- Install node 6 or later (nvm recommended)
- Install npm5 via
npm i npm -g - run
npm start
At this point you should have both backend and front-end development servers running.
https://localhost:3000 serves react front-end in dev-mode https://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.
A docker-compose file is provided to provide a variety of SQL database services to develop and test against. To run these, first install docker and then run the following commands:
# Bring database containers up
docker-compose up
# To bring down
docker-compose down
# To remove dangling containers volumes etc
docker system pruneIf you have highlighted just part of your query, only that part will be executed when you click Run Query.
MIT