SQLPad
SQLPad is a free web application for writing and running SQL queries and viewing their results.
What SQLPad is
SQLPad is a free web application for writing and running SQL queries and viewing their results. It connects to many documented database systems, including PostgreSQL, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, Pinot, Drill, SAP HANA, BigQuery, SQLite, TiDB, Cassandra, Athena, and ODBC sources. Query history lets users revisit earlier work, while CSV, JSON, and XLSX downloads are enabled by default. Authentication options include local accounts, Google OAuth, OpenID Connect, SAML, LDAP, and an HTTP authentication proxy. Admin and Editor roles separate user, access, and connection management from query tasks. Local passwords use bcrypt hashing, and a configuration passphrase can encrypt stored connection credentials. SQLPad uses SQLite and local storage by default, with external SQLite, MySQL, MariaDB, or SQL Server backing databases available. Its REST-style API supports bearer service tokens. Results default to 10,000 records, with query-history results limited to 1,000. The project is MIT-licensed, in maintenance mode, and its GitHub repository was archived on August 23, 2025.
Good
- Supports many databases and ODBC connections
- Exports CSV, JSON, and XLSX
- Offers query history
- Provides multiple authentication methods
- Includes Admin and Editor roles
Watch out
- Project is in maintenance mode
- GitHub repository was archived August 23, 2025
- Results default to 10,000 records
- Query-history results default to 1,000 records
Who it suits
SQLPad suits users who need browser-based querying across several database systems. It also fits teams wanting query history, downloadable results, role-based access, and API authentication.
Verdict
SQLPad provides broad database connectivity, browser query work, history, exports, and administrative controls at no listed cost. Its archived repository and maintenance status should be considered before adopting it for an actively evolving platform.
The facts
Each one read from SQLPad's own pages, with the date it was checked.
What it does
- Access control
- SQLPad has Admin and Editor roles; editors can create, run, and edit queries, while admins manage connections, access, and users.checked 11 Oct 2026
- API
- SQLPad provides a REST-style API and supports bearer service tokens scoped to an admin or editor role and an optional time window.checked 11 Oct 2026
- Authentication
- Authentication options include local email and password, Google OAuth, OpenID Connect, SAML, LDAP, and an authentication proxy.checked 11 Oct 2026
- Authorization
- The docs describe admin and editor roles, and allow service tokens scoped to a role and a time window.checked 10 Oct 2026
- Connection credentials
- A configuration passphrase can encrypt sensitive connection information, such as usernames and passwords, when stored in the backing database.checked 11 Oct 2026
- Credential protection
- A configuration passphrase encrypts sensitive connection information, such as usernames and passwords, when stored in the backing database.checked 10 Oct 2026
- 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.checked 10 Oct 2026
- Database support
- It supports PostgreSQL, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, SAP HANA, Cassandra, BigQuery, SQLite, TiDB, and other databases through ODBC.checked 11 Oct 2026
- Deployment
- SQLPad can be built from source or run as a Docker image; the Docker image listens on port 3000 by default.checked 11 Oct 2026
- Exports
- CSV, JSON, and XLSX downloads can be enabled through configuration and are enabled by default.checked 10 Oct 2026
- License and archive
- The project is MIT-licensed, and its GitHub repository was archived on August 23, 2025.checked 11 Oct 2026
- License and project status
- The project’s GitHub repository identifies SQLPad as MIT-licensed and says the repository was archived on August 23, 2025.checked 10 Oct 2026
- Maintenance
- The project is in maintenance mode, with security updates and critical bug fixes planned as needed and as possible.checked 10 Oct 2026
- Maintenance status
- The project says it is in maintenance mode, with security updates and critical bug fixes made as needed and as possible.checked 11 Oct 2026
- Password security
- Local account passwords are stored in SQLPad’s embedded database using bcrypt hashing.checked 11 Oct 2026
- Password storage
- Local authentication passwords are stored in SQLPad’s embedded database using bcrypt hashing.checked 10 Oct 2026
- Purpose
- SQLPad is a web app for writing and running SQL queries and visualizing results.checked 11 Oct 2026
- Query results
- Configuration enables CSV, JSON, and XLSX downloads by default, and query results are limited to 10,000 records by default.checked 11 Oct 2026
- 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.checked 10 Oct 2026
- Result limit
- Query results are limited to 10,000 records by default, and query history results to 1,000 records by default.checked 10 Oct 2026
- 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.checked 11 Oct 2026
- Webhooks
- Configurable webhooks send HTTP POST payloads for events including user creation, query creation, and batch completion, and can include a configured secret header.checked 11 Oct 2026
The company
- Company details
- The maker pages opened do not state a company headquarters or founding year.checked 10 Oct 2026
Alternatives to SQLPad
- 1
Outerbase Studio
Free planOpen sourceAndroidiOSWebAPI8.5From $9 a month - 2
DBeaver
Free planOpen sourceWebAPIExtensionLinux8.2From $113 a year - 3
Beekeeper Studio
Free planOpen sourceAPIExtensionLinuxmacOS8.0From $18 a month - 4
MySQL
Free planAPILinuxmacOSSelf-hosted7.9Free plan - 5
Database Workbench
Free planLinuxmacOSWindows7.5€199 one-time - 6
dbForge Studio for PostgreSQL
Free planLinuxmacOSWindows7.5From $89.95 a year