A Node.js web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, and SQL Server.
SqlPad is meant to be run on an internal network for a single team. All connections added to the app can be used by all individuals with access to the SqlPad server. All queries written can be run and edited by everyone on the server.
If you want to be bold and daring, you can expose your SqlPad instance to the outside world. Please make sure you fully understand the risks associated with doing this and use SSL.
First, install Node.js and then
npm install sqlpad -gFor more info visit the project page at http://rickbergfalk.github.io/sqlpad/.
If you want to hack on SqlPad, here's a guide as to what my workflow has been like:
First clone or download this repo. Then install dependencies.
npm installInstall nodemon for automatic server restarts when developing
npm install nodemon -gInstall browserify to compile client-side scripts
npm install browserify -gOptionally install watchify to automatically browserify your client-side scripts
npm install watchify -gTo start SqlPad on port 3000 with datafiles in ./db run
npm startTo bundle client-side scripts run
npm run bundleor to auto-browserify as changes happen
npm run watchifyMIT