# SQLPage

SQLPage is an open-source, SQL-only web application builder that turns database queries into shareable web pages with tables, forms, charts, and maps for teams that need lightweight, data-driven internal UIs.

Canonical page: https://ourlocalhost.com/app/8782/sqlpage

## Description

SQLPage is an open-source, SQL-only web application builder that turns database queries into shareable web pages with tables, forms, charts, and maps for teams that need lightweight, data-driven internal UIs.

## Platform availability

Available on 4 of 10 platforms: Mac, Windows, Linux, Any server.

## Desktop and other devices

Mac, Windows, Linux.

## Health score

84/100 (Excellent), based on 4 of 5 factors.
- Maintained: 100 (last commit 0 days ago)
- Popular: 68 (2,585 GitHub stars)
- Easy to install: 55 (4 install platforms, install notes)
- Security check: 100 (no serious findings, CI, tests)

## Links

- Official website: https://sql-page.com
- GitHub: https://github.com/sqlpage/SQLPage
- desktop: https://github.com/sqlpage/SQLPage/releases/latest
- Documentation: https://sql-page.com/documentation.sql

## Common questions

### How do I configure SQLPage's database connection, and what file must be kept private?

Create or edit the .env settings file with DATABASE_URL and, if separate, DATABASE_PASSWORD. If these values are missing or wrong, SQLPage may start but cannot connect to data, so pages and forms fail. Keep the .env file private because it contains the database address and password.

### How can I retrieve HTTP request variables in SQLPage?

Use SQLPage's .variables() function, which returns GET/POST variables and variables set with standalone SET statements. A table component can be used to output those variables.

### Is checking authentication only when rendering a SQLPage page sufficient?

No. A SQLPage action is the protected resource, so checking authentication only when rendering the page is not enough. A crafted request can still reach the action.

### How do I install and start SQLPage on macOS?

On macOS, install it with Homebrew using brew install sqlpage. Then start the program with sqlpage to run a local web app that can be opened in a browser.

## Alternatives

- Budibase: Budibase is a self-hosted platform for building internal tools, forms, and portals from your own data.
- DBeaver: A versatile, open-source database tool for developers and administrators supporting multiple databases via JDBC drivers with extensive plug…
- DbGate: DbGate is a cross-database SQL and NoSQL client that lets you manage MySQL, PostgreSQL, Microsoft SQL Server, Oracle, MongoDB, SQLite, and…
- DbVisualizer
- LibreOffice - Base: Base is a full-featured desktop database front end, designed to meet the needs of a broad array of users, for all kinds of usages, such as…
- Microsoft Office Access
- Retool
- Sequel Pro: Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases.

---
Source: Our Local Host (https://ourlocalhost.com/app/8782/sqlpage), the self-hosted and open-source app directory.
