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 prune

Locally

• Clone/download repo
• Install node 6 or later
• Install npm5
• run npm start from 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