Lite Queen

Lite Queen is an open-source, web-based tool that lets you manage SQLite databases directly on your server. Instead of using a desktop client or command-line tools, you get a full-featured graphical interface in your browser to browse tables, edit records, run SQL queries, and visualize your database structure. It's designed to be self-hosted, giving you complete control over your data while providing a modern, intuitive way to interact with your databases.

What makes Lite Queen stand out is its 'God Mode' feature, activated with Cmd+K. This mode integrates with OpenAI's API (using your own key) to let you query your database using plain English. It understands your schema, indexes, and triggers to generate accurate SQL or answer questions about your data. Beyond AI, the tool offers a robust set of features like a visual relationship mapper between tables, a detailed schema sidebar, smart table ordering, and simple search across your data. It's built with practicality in mind, including guides for easy deployment with Docker, Systemd, or one-click install on Coolify.

This tool is a perfect fit for developers, DBAs, and DevOps professionals who regularly work with SQLite databases, whether for local development, embedded applications, or smaller server-side projects. It simplifies tasks like data inspection, debugging application data, performing ad-hoc analysis, or explaining complex database relationships to team members. By combining a clean, responsive web UI with powerful query capabilities and optional AI assistance, Lite Queen turns database management from a chore into a streamlined part of your workflow.