This Project is Archived

Node and React are unkind to long-lived projects. Libraries and trends are constantly changing. Dependencies will be abandoned.

If you’re using this project or interested in it, I recommend forking it, gutting the features you don’t want or need, and then incrementally rewriting the bits that are left. Or perhaps start fresh, and borrow the parts of this you like.

Most of this codebase is from the 2016-2020 era of JavaScript. To modernize it without breaking things would be a huge time commitment, and I no longer have that time.

SQLPad

A web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, Google BigQuery, SQLite, TiDB and many more via ODBC.

As of version 7, semver is no longer followed. Going forward patch updates may require major Node.js version updates, or contain removal of functionality.

Docker Image

The docker image runs on port 3000 and uses /var/lib/sqlpad for the embedded database directory.

See docker-examples for docker-compose examples.

Project Documentation

The most recently used documentation site’s astro code is located under /docs directory.

Development

For instructions on installing/running SQLPad from git repo see DEVELOPER-GUIDE.md

License

MIT