SQLPage
SQL-only web app builder that generates UI from SQL queries
2.6k stars 177 forks last commit first released MIT
Actively maintained
Last commit 3 Sept 2026.
SQLPage is an SQL-only web application builder that turns SQL files into interactive web pages, forms, charts, and APIs. It runs as a web server and maps query results to prebuilt UI components, letting you build data-centric apps without writing backend code.
Key Features
- SQL-driven pages: serve routes by executing corresponding .sql files
- Built-in UI components for lists, tables, cards, charts, forms, and navigation
- CRUD workflows via SQL statements (SELECT/INSERT/UPDATE/DELETE) with request parameters
- Database connectivity for SQLite, PostgreSQL, MySQL/MariaDB, and Microsoft SQL Server, plus ODBC-compatible engines
- Custom components and theming via Handlebars templates and optional HTML/CSS/JS
- Can expose JSON endpoints to build simple REST-style APIs
- Single-binary deployment with Docker support
Use Cases
- Internal admin tools and operational dashboards with drill-down navigation
- Lightweight CRUD apps for teams that already use a relational database
- Rapid prototyping of database-backed tools and simple data APIs
SQLPage is a good fit when you want a maintainable, database-first approach to building web interfaces, keeping logic close to SQL while still allowing optional frontend customization as needed.
Categories:
Tags:
Tech Stack:
Similar to SQLPage
NocoDB
No-code spreadsheet interface for SQL databases with APIs
Open-source Airtable alternative that turns Postgres/MySQL/SQLite into a no-code spreadsheet UI with views, permissions, integrations, and REST APIs.
Datasette
Explore and publish SQLite data as a web UI and JSON API
Open source tool to publish SQLite databases as an interactive website with a JSON API, with a powerful plugin system for search, auth, and customization.
Chartbrew
Open-source self-hosted data visualization dashboards
Chartbrew is an open-source platform to build live dashboards and reports by connecting SQL/NoSQL databases and REST APIs.
ARA Records Ansible
Ansible run recording and reporting with a web UI and REST API
ARA records Ansible playbook runs and provides searchable reports via a CLI, REST API, and local-first web interface to troubleshoot and understand automation results.
Teable
Spreadsheet-like database app builder for PostgreSQL
Teable is an Airtable alternative for building database apps with a spreadsheet UI, multiple views, real-time collaboration, and a plugin system, backed by PostgreSQL.
Thrifty
Simple monthly income and expenses web application
Open-source SvelteKit frontend and Go API for tracking monthly income and expenses; runs with Docker and stores data in SQLite.
