SQLPage

SQLPage

SQL-only web app builder that generates UI from SQL queries

2.4kstars
162forks
Last commit: 16h ago
Repo age: 4y old
SQLPage screenshot

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:

Share:

Similar Services

n8n

n8n

Workflow automation platform with visual builder and code support

169.5k
53.7k
Last commit: 23h ago

Self-hostable workflow automation platform combining a visual builder with JavaScript/Python code steps, 400+ integrations, and AI-assisted automation.

Alternative to:
Zapier
Zapier
+17
Ansible

Ansible

Agentless IT automation and configuration management engine

67.7k
24.2k
Last commit: 22h ago

Open source, agentless automation engine for configuration management, app deployment, orchestration, and infrastructure provisioning using YAML playbooks over SSH.

Alternative to:
Red Hat Ansible Automation Platform
Red Hat Ansible Automation Platform
+4
NocoDB

NocoDB

No-code spreadsheet interface for SQL databases with APIs

61.5k
4.6k
Last commit: 1d ago

Open-source Airtable alternative that turns Postgres/MySQL/SQLite into a no-code spreadsheet UI with views, permissions, integrations, and REST APIs.

Alternative to:
Airtable
Airtable
+10
Huginn

Huginn

Open-source platform for self-hosted automation agents

48.5k
4.2k
Last commit: 24d ago

Huginn is an open-source automation platform that runs agents to monitor web data, process events, and trigger actions — self-hosted and extensible.

Alternative to:
IFTTT
IFTTT
+17
Apache Airflow

Apache Airflow

Platform to author, schedule, and monitor workflows as code

43.9k
16.3k
Last commit: 19h ago

Apache Airflow is a workflow orchestration platform to define, schedule, and monitor data pipelines and other batch jobs using Python-defined DAGs.

Alternative to:
Astronomer
Astronomer
+5
Appsmith

Appsmith

Open-source low-code platform for internal tools and dashboards

38.9k
4.4k
Last commit: 2d ago

Build and deploy internal tools, admin panels, and dashboards with a low-code UI builder that connects to databases and APIs and supports JavaScript logic and Git workflo...

Alternative to:
Retool
Retool
+14