TheBits/sqlpad

Web-based SQL editor run in your own private cloud. Supports MySQL, Postgres, SQL Server, Vertica, Crate, ClickHouse, Presto, SAP HANA, Cassandra, Snowflake, BigQuery, SQLite, and more with ODBC

SQLPad

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

Docker Image

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

latest tag is continuously built from latest commit in repo. Only use that if you want to live on the edge, otherwise use specific version tags to ensure stability.

See docker-examples directory for example docker-compose setup with SQL Server.

Development

For instructions on installing/running SQLPad from git repo see developer guide

Configuration

• project page - configuration
• docs/configuration.md

Connection configuration

• project page - connections
• docs/connections.md

Seed Data (experimental)

• project page - seed data
• docs/seed-data.md

Logging

• project page - logging
• docs/logging.md

License

MIT