Skip to main content
SQLPage - SQL-only web application builder

​
What is SQLPage?

SQLPage is an SQL-only web application builder that transforms simple .sql files into interactive, professional-looking websites. Write SQL queries to select, update, insert, and delete data—SQLPage handles everything else, from HTML rendering to HTTP request handling. Instead of juggling multiple languages and frameworks, you write straightforward SQL: 
SELECT 'list' as component,
    'Popular websites' as title;

SELECT 
    name as title,
    url as link,
    description,
    icon
FROM website;
SQLPage executes your queries and automatically renders them using pre-built, beautiful UI components.
SQLPage is perfect for internal tools, admin dashboards, data exploration interfaces, and rapid prototyping.

​
Why SQLPage?

Simple

Write only SQL. No JavaScript, HTML, or CSS required. Perfect for database developers and analysts.

Fast

Built with Rust and actix-web. Pages load instantly, even on slow mobile networks.

Beautiful

Professional-looking components powered by Tabler UI. No design skills needed.

Powerful

Supports PostgreSQL, MySQL, SQL Server, SQLite, and any ODBC-compatible database.

​
How It Works

SQLPage is a web server that:
  1. Receives HTTP requests for .sql files
  2. Executes your SQL queries against your database
  3. Maps query results to UI component parameters
  4. Streams beautiful HTML back to the browser
-- index.sql
SELECT 'form' as component,
    'Create User' as title,
    'Save' as validate;

SELECT 'Name' as name, TRUE as required;
SELECT 'Email' as name, 'email' as type;

-- Handle form submission
INSERT INTO users (name, email)
SELECT $Name, $Email
WHERE $Name IS NOT NULL;
Form parameters are automatically available as SQL variables prefixed with $.

​
Core Features

​
Rich Component Library

SQLPage includes 40+ pre-built components for common UI patterns:
  • Display: Lists, tables, cards, charts, timelines
  • Input: Forms, buttons, file uploads
  • Layout: Tabs, columns, modals, shells
  • Special: Maps, authentication, JSON APIs

​
Database Support

Connect to any major database: 
DATABASE_URL="sqlite://app.db?mode=rwc"

​
Built-in HTTPS

Automatic SSL certificate management with Let’s Encrypt: 
SQLPAGE_HTTPS_DOMAIN=myapp.example.com
No manual certificate configuration needed—SQLPage handles everything.

​
Authentication & Security

Built-in support for:
  • OpenID Connect (OIDC) authentication
  • Password hashing functions
  • Secure session management
  • Content Security Policy headers

​
Quick Example: Todo App

Here’s a complete todo application in one SQL file: 
-- Display the list of todos
SELECT 'list' as component,
    'My Todos' as title;

SELECT 
    title,
    'todo_form.sql?id=' || id as edit_link,
    'delete.sql?id=' || id as delete_link
FROM todos;

-- Add new todo button
SELECT 'button' as component;
SELECT 
    'todo_form.sql' as link,
    'Add Todo' as title,
    'green' as color;

​
Real-World Examples

SQLPage powers production applications:
  • Internal Tools: Employee directories, inventory management, reporting dashboards
  • Data Exploration: Interactive database browsers, query builders, analytics interfaces
  • CRUD Applications: User management, content management systems
  • API Backends: RESTful JSON APIs built entirely in SQL
  • Prototypes: Rapid MVP development before committing to a full framework
SQLPage excels at data-centric applications. For apps requiring heavy client-side interactivity (like real-time collaboration), consider traditional frameworks.

​
Next Steps

Quickstart

Build your first SQLPage app in 5 minutes

Installation

Install SQLPage on your system

Components

Explore the component library

Examples

Learn from real applications

​
Community & Support

GitHub

Source code, issues, and discussions

Official Site

Documentation and examples

Docker Hub

Official Docker images

Build docs developers (and LLMs) love

Get started for freeTalk to us