SQLPage

SQLPage

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

2.5kstars
166forks
Last commit: 20d 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

176.3k
55.2k
Last commit: 8h 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

68.1k
24.2k
Last commit: 1d 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

62.2k
4.6k
Last commit: 10h 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.8k
4.2k
Last commit: 5d 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

44.4k
16.5k
Last commit: 7h 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

39.2k
4.5k
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