SQLPage

SQLPage is an open-source web application builder that allows the creation of data-centric user interfaces using only SQL files. It transforms database queries into interactive websites by mapping query results to pre-defined UI components. The software is distributed as a single executable written in Rust and can be deployed via binaries, Docker containers, or Homebrew on macOS. It functions as a specialized web server that interprets SQL logic to generate frontend views.

Users build pages by writing .sql files that select, group, update, insert, or delete data. When a request is made to a URL ending in .sql, the server finds the corresponding file, executes it against the connected database, and streams the result to the browser as a formatted webpage. This approach enables the creation of CRUD applications, dashboards, and internal tools without writing traditional HTML, CSS, or JavaScript. The system handles the translation of database rows into visual elements automatically.

Key features

• Native support for SQLite, PostgreSQL, MySQL, and Microsoft SQL Server
• Connectivity to ODBC-compatible databases including DuckDB, Snowflake, and BigQuery
• UI components for displaying data as text, lists, grids, and plots
• Built-in form components for data insertion and validation
• Support for interactive elements such as tabs and cards
• Ability to read external Markdown files for content rendering
• Integration capabilities for JSON APIs and React components
• Session cookie management for user authentication systems

The server operates by passing web request information as SQL statement parameters to the database, allowing for dynamic content based on URL parameters. It is designed for developers and database administrators who want to build functional interfaces quickly using their existing SQL knowledge. The architecture supports various environments, including ARM-based hardware like Raspberry Pi through Docker images. It can be configured via a json file and supports the mounting of custom components and migrations for more complex deployments.

SQLPage serves as a low-code framework for transforming database queries into functional web interfaces.