SQLPad

Spec sheet

Purpose

SQLPad is a web app for writing and running SQL queries and visualizing results.Read 11 Oct 2026 · sqlpad.github.io

Deployment

SQLPad can be built from source or run as a Docker image; the Docker image listens on port 3000 by default.Read 11 Oct 2026 · sqlpad.github.io

API

SQLPad provides a REST-style API and supports bearer service tokens scoped to an admin or editor role and an optional time window.Read 11 Oct 2026 · sqlpad.github.io

Access control

SQLPad has Admin and Editor roles; editors can create, run, and edit queries, while admins manage connections, access, and users.Read 11 Oct 2026 · sqlpad.github.io

Authentication

Authentication options include local email and password, Google OAuth, OpenID Connect, SAML, LDAP, and an authentication proxy.Read 11 Oct 2026 · sqlpad.github.io

Authorization

The docs describe admin and editor roles, and allow service tokens scoped to a role and a time window.Read 10 Oct 2026 · sqlpad.github.io

Company details

The maker pages opened do not state a company headquarters or founding year.Read 10 Oct 2026 · sqlpad.github.io

Connection credentials

A configuration passphrase can encrypt sensitive connection information, such as usernames and passwords, when stored in the backing database.Read 11 Oct 2026 · sqlpad.github.io

Credential protection

A configuration passphrase encrypts sensitive connection information, such as usernames and passwords, when stored in the backing database.Read 10 Oct 2026 · sqlpad.github.io

Database connections

Documented database drivers include Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, Pinot, Drill, SAP HANA, BigQuery, SQLite, TiDB, Cassandra, Athena, and ODBC.Read 10 Oct 2026 · sqlpad.github.io

Database support

It supports PostgreSQL, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, BigQuery, SQLite, TiDB, and other databases through ODBC.Read 11 Oct 2026 · sqlpad.github.io

Exports

CSV, JSON, and XLSX downloads can be enabled through configuration and are enabled by default.Read 10 Oct 2026 · sqlpad.github.io

License and archive

The project is MIT-licensed, and its GitHub repository was archived on August 23, 2025.Read 11 Oct 2026 · github.com

License and project status

The project’s GitHub repository identifies SQLPad as MIT-licensed and says the repository was archived on August 23, 2025.Read 10 Oct 2026 · github.com

Maintenance

The project is in maintenance mode, with security updates and critical bug fixes planned as needed and as possible.Read 10 Oct 2026 · sqlpad.github.io

Maintenance status

The project says it is in maintenance mode, with security updates and critical bug fixes made as needed and as possible.Read 11 Oct 2026 · sqlpad.github.io

Password security

Local account passwords are stored in SQLPad’s embedded database using bcrypt hashing.Read 11 Oct 2026 · sqlpad.github.io

Password storage

Local authentication passwords are stored in SQLPad’s embedded database using bcrypt hashing.Read 10 Oct 2026 · sqlpad.github.io

Query results

Configuration enables CSV, JSON, and XLSX downloads by default, and query results are limited to 10,000 records by default.Read 11 Oct 2026 · sqlpad.github.io

Query transactions

Opt-in multi-statement transaction support is documented for MySQL, SQLite, Postgres, and ODBC, and requires requests to reach the same SQLPad instance consistently.Read 10 Oct 2026 · sqlpad.github.io

Result limit

Query results are limited to 10,000 records by default, and query history results to 1,000 records by default.Read 10 Oct 2026 · sqlpad.github.io

Storage

By default, it uses SQLite and the local file system to store queries, query results, and web sessions; SQLite can be replaced with an external database.Read 11 Oct 2026 · sqlpad.github.io

Webhooks

Configurable webhooks send HTTP POST payloads for events including user creation, query creation, and batch completion, and can include a configured secret header.Read 11 Oct 2026 · sqlpad.github.io

Where Specifiction places it

• Database Client Software#38 of 537.2
• SQL Query Tools#24 of 317.3