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, Snowflake, Google BigQuery, SQLite, TiDB and many more via ODBC.
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.
For instructions on installing/running SQLPad from git repo see DEVELOPER-GUIDE.md
Documentation located at https://getsqlpad.com.
Documentation source located in docs directory, built/rendered by docsify.
Despite recent development this last year and move to GitHub org, SQLPad is mostly "finished" in that it won't radically be changing from what it is today.
Maintenance releases and bugfixes guaranteed through 2021.
MIT
On the "ODBC connection string" field, provide the following:
Driver={Oracle 21 ODBC driver}; dbq=<address>:<port>/<service_name>
On the "Database SQL for lookup schema" field, input the following query:
select
t.owner table_schema,
t.table_name table_name,
c.column_name column_name,
c.data_type data_type
from all_tables t inner join all_tab_columns c
on t.owner = c.owner and t.table_name = c.table_name