A Node.js web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server and Vertica.
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/.
To change the maximum records returned by a SQL query, add a new item with key "queryResultMaxRows" and set the value to the max number of rows you would like returned. If the key is missing or set to a non-number, SqlPad will return a maximum of 50,000 rows.
To disable CSV downloads, visit the "Configuration" page and add a new item with key allowCsvDownload and value false. If the key is missing or set to any other value, CSV downloads will be enabled.
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