What is Lite queen?
Lite Queen is an open‑source SQLite database manager that runs on your server.
It provides a command‑based interface (Cmd + K) for navigating tables, executing SQL, and querying the database in plain English with OpenAI integration.
Automatic database backup is accessible via a keyboard shortcut, and a simple search bar lets users find tables or records quickly.
A visual relationship viewer groups related tables and displays schema and index information in a side pane.
Record view features sticky column headers, relative timestamps, and JSON pop‑overs for foreign‑key data.
The UI is responsive on desktops, tablets, and phones and supports deployment via Docker, Systemd, or Coolify with one‑click installation.
Lite queen user reviews
Would you recommend Lite queen?
Recommend this tool?
Lite queen's key features
-
Manage SQLite databases on server
-
Open-source SQLite management software
-
Simple backup functionality
-
God Mode SQL chat with OpenAI
-
Command menu navigation via Cmd+K
-
Query results in JSON format
Lite queen use cases
-
Create a quick, command-line interface for developers to manage SQLite databases on their server without manual SQL queries, utilizing Lite Queen’s plain‑English to SQL feature
-
Automate daily backups and visual schema updates for a web application’s SQLite database, allowing non‑technical admins to monitor data relationships through the responsive UI
-
Deploy Lite Queen inside a Docker container for a lightweight, secure SQLite manager that can be integrated into CI/CD pipelines and monitored via the visual relationship view
Who is it for?
-
Database admins
-
Software developers
-
Data analysts
-
Sqlite administrators
-
System integrators