SQLPage
Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.
What is SQLPage?
Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.
Overview of SQLPage
What it is
SQLPage is an SQL-only web application builder. It transforms simple database queries into interactive websites. Users write .sql files containing queries to select, group, update, insert, and delete data, and SQLPage renders the results as clean webpages with text, lists, grids, plots, and forms. It is a web server written in Rust and distributed as a single executable file.
Key features
- Converts SQL queries directly into interactive UI components such as lists, charts, forms, cards, and tabs.
- Supports multiple database backends: SQLite, PostgreSQL, MySQL, Microsoft SQL Server, and any ODBC-compatible database (e.g., ClickHouse, MongoDB, DuckDB, Oracle, Snowflake, BigQuery).
- Runs as a standalone web server; no additional runtime or framework required.
- Passes HTTP request parameters as SQL statement parameters, enabling dynamic filtering and data manipulation.
- Provides pre-defined component templates that map query result columns to visual properties.
Use cases
- Building data-centric applications quickly, such as dashboards, CRUD interfaces, and data exploration tools.
- Examples from the repository include a TODO list application, a shared expense tracker (Tiny splitwise clone), a board game (Corporate Conundrum), and master-detail forms for inserting data into related tables.
Getting started
Download the latest release binary for your operating system (Linux, macOS, Windows) from the releases page. On macOS, Homebrew is recommended. bash # Binary installation (Linux/macOS/Windows) tar -xzf sqlpage-*.tgz ./sqlpage.bin # Docker installation docker run -it --name sqlpage -p 8080:8080 --volume $(pwd):/var/www --rm lovasoa/sqlpage # macOS Homebrew brew install sqlpage After starting SQLPage, create an index.sql file with a query and open http://localhost:8080 in a browser.
License and pricing
MIT license. Open source.
Based on the project's public README and repository metadata.