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/.
Quickstart:
# Assuming node 6 or later is installed
npm install sqlpad -g
sqlpad --helpTo update sqlpad installed via npm run
npm install sqlpad -gUsing docker
docker-compose run --rm web npm -i
docker-compose upLocally
- Clone/download repo
- Install node 6 or later
- Install npm5
- run
npm startfrom command line
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