SQLPad

Free plan APILinuxSelf-hostedWeb

What SQLPad is

SQLPad is a free web application for writing and running SQL queries and visualizing results. It connects with documented drivers for PostgreSQL, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, Pinot, Drill, SAP HANA, BigQuery, SQLite, TiDB, Cassandra, Athena, and ODBC. Query history lets users revisit earlier work, while CSV, JSON, and XLSX downloads are enabled by default. Authentication options include local credentials, Google OAuth, OpenID Connect, SAML, LDAP, and an HTTP authentication proxy. Admin and Editor roles separate administration from query work, and service tokens can be scoped by role and time window. A configuration passphrase can encrypt stored connection details; local passwords use bcrypt hashing. SQLPad uses SQLite and the local file system by default, with external database options. Results default to 10,000 records and history results to 1,000. The project is MIT-licensed, archived on GitHub on August 23, 2025, and in maintenance mode.

Who it suits

It suits people who need a free, web-accessible SQL workspace across many database systems. It also fits self-hosted teams needing authentication, roles, exports, and query history.

What it does well

Broad database driver support
CSV, JSON, and XLSX exports
Multiple authentication options
Admin and Editor roles
Free plan

What to know first

10,000-record default result limit
1,000-record history-result limit
Project is in maintenance mode
GitHub repository archived August 23, 2025

Limits

Query results are limited to 10,000 records by default, while query-history results are limited to 1,000. Multi-statement transactions require requests to reach the same SQLPad instance consistently and are documented for MySQL, SQLite, Postgres, and ODBC.

Getting started

Open the SQLPad website
Deploy SQLPad on the web or self-host it
Use embedded SQLite or configure an external SQLite, MySQL, MariaDB, or SQL Server database
Configure a supported authentication method
Add database connections and assign Admin or Editor access
Run queries and download results as CSV, JSON, or XLSX

Verdict

SQLPad provides a broad database query interface with history, exports, authentication choices, and role controls at no listed cost. Its maintenance status and archived repository are important considerations for ongoing use.

Questions

How much does SQLPad cost?

SQLPad is free and has a free plan.

Which platforms and deployment models are supported?

It is available as a web app and supports API, Linux, and self-hosted deployments.

Which databases can SQLPad connect to?

Documented drivers include PostgreSQL, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, Pinot, Drill, SAP HANA, BigQuery, SQLite, TiDB, Cassandra, Athena, and ODBC.

What export formats are supported?

CSV, JSON, and XLSX downloads are enabled by default through configuration.

Does SQLPad provide authentication and roles?

Yes. Options include local credentials, Google OAuth, OpenID Connect, SAML, LDAP, and an HTTP proxy; Admin and Editor roles are documented.

Is SQLPad open source?

The project is MIT-licensed. Its GitHub repository was archived on August 23, 2025, and the project is in maintenance mode.

Facts from SQLPad's own pages

Access control: SQLPad has Admin and Editor roles; editors can create, run, and edit queries, while admins manage connections, access, and users. · sqlpad.github.io, 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. · sqlpad.github.io, 11 Oct 2026
Authentication: Authentication options include local email and password, Google OAuth, OpenID Connect, SAML, LDAP, and an authentication proxy. · sqlpad.github.io, 11 Oct 2026
Authorization: The docs describe admin and editor roles, and allow service tokens scoped to a role and a time window. · sqlpad.github.io, 10 Oct 2026
Company details: The maker pages opened do not state a company headquarters or founding year. · sqlpad.github.io, 10 Oct 2026
Connection credentials: A configuration passphrase can encrypt sensitive connection information, such as usernames and passwords, when stored in the backing database. · sqlpad.github.io, 11 Oct 2026
Credential protection: A configuration passphrase encrypts sensitive connection information, such as usernames and passwords, when stored in the backing database. · sqlpad.github.io, 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. · sqlpad.github.io, 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. · sqlpad.github.io, 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. · sqlpad.github.io, 11 Oct 2026
Exports: CSV, JSON, and XLSX downloads can be enabled through configuration and are enabled by default. · sqlpad.github.io, 10 Oct 2026
License and archive: The project is MIT-licensed, and its GitHub repository was archived on August 23, 2025. · github.com, 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. · github.com, 10 Oct 2026
Maintenance: The project is in maintenance mode, with security updates and critical bug fixes planned as needed and as possible. · sqlpad.github.io, 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. · sqlpad.github.io, 11 Oct 2026
Password security: Local account passwords are stored in SQLPad’s embedded database using bcrypt hashing. · sqlpad.github.io, 11 Oct 2026
Password storage: Local authentication passwords are stored in SQLPad’s embedded database using bcrypt hashing. · sqlpad.github.io, 10 Oct 2026
Purpose: SQLPad is a web app for writing and running SQL queries and visualizing results. · sqlpad.github.io, 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. · sqlpad.github.io, 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. · sqlpad.github.io, 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. · sqlpad.github.io, 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. · sqlpad.github.io, 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. · sqlpad.github.io, 11 Oct 2026

Where SQLPad stands on Freedom251

Database Client Software#28 of 53
SQL Query Tools#18 of 31