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/.
The docker image runs on port 3000 and uses /var/lib/sqlpad for the embedded database directory.
Some configuration is exposed via environment variables. See configItems.js for details on environment variables considered (envVar field).
See docker-validation folder for example docker-compose setup with SQL Server.
- 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.
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.
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 pruneMIT