Build data-centric web applications by writing SQL queries that automatically generate interactive user interfaces.
SQLPage is a web application builder that transforms SQL queries into fully functional, interactive websites. It enables developers and data professionals to create data-centric user interfaces quickly by writing .sql files, which automatically generate UI components like lists, charts, and forms without requiring frontend code.
Data professionals, backend developers, and analysts who need to build internal tools, dashboards, or data-centric web applications quickly without deep frontend expertise. It's also suitable for developers prototyping applications where the data model and business logic are the primary focus.
Developers choose SQLPage for its unique SQL-only development approach, allowing rapid prototyping and building of functional web interfaces directly from database queries. It stands out by offering pre-built, styled UI components that render automatically from query results, support for a wide range of databases (including ODBC-compatible ones), and features like automatic HTTPS and serverless deployment options.
Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Enables quick prototyping by writing .sql files to generate UI, as shown in examples where simple queries create lists, charts, and forms without frontend code.
Works natively with SQLite, PostgreSQL, MySQL, SQL Server, and any ODBC-compatible database like Snowflake or BigQuery, making it versatile for data sources.
Includes out-of-the-box components (e.g., cards, tabs, charts) with Tabler styling, providing professional looks without CSS work, as demonstrated in the demo images.
Simplifies secure hosting with automatic TLS certificate provisioning when setting SQLPAGE_HTTPS_DOMAIN, reducing configuration overhead.
Can be compiled for AWS Lambda, as noted in the README, allowing cost-effective, scalable deployments without managing servers.
Advanced UI customizations require creating Handlebars templates, which adds complexity compared to modern frontend frameworks and may not support dynamic client-side logic well.
All business logic must be expressed in SQL, which can be cumbersome for complex algorithms or workflows, as hinted in the FAQ defending SQL's Turing-completeness.
Each HTTP request triggers SQL queries, potentially leading to database bottlenecks for high-traffic sites, with no built-in caching mentioned in the README.
Being a specialized tool, it lacks the extensive community, plugins, and detailed guides of full-stack frameworks, which might slow down troubleshooting or scaling.
SQLPage is an open-source alternative to the following products: