Lite Queen

Lite Queen is an open-source SQLite database management tool that runs on your server. It provides a convenient interface to manage SQLite databases locally on your infrastructure, with features designed to simplify database exploration, querying, and administration.

Overview

• Open-source SQLite database management software that runs on your server
• Integrated into environments like Coolify for easy hosting
• Designed to improve database visibility, editing, and querying without leaving your server

Key Highlights

• In-app SQL querying with natural language interaction (via Go Mode) using your own OpenAI-compatible keys
• Local data privacy: API keys and data can remain on your server; you bring your own API key
• Regular updates with improvements in search, errors handling, setup, and UI enhancements
• Supports server-side deployment and various setup methods (Systemd, Docker, Docker Compose with Coolify)
• Features like simple backup, table relationships visualization, and a responsive UI for mobile and desktop

How to Use Lite Queen

1. Install and run Lite Queen on your server (via Systemd, Docker, or Coolify with Docker Compose).
2. Connect to a SQLite database file. Browse tables, columns, and records.
3. Use the God Mode (Cmd + K) to query your SQLite databases with SQL and also chat in plain English. Your schema, indexes, triggers, and metadata are available to provide accurate results.
4. Explore features like search, editing, and quick navigation to tables and records. Leverage built-in shortcuts to enhance productivity.

Disclaimer: Lite Queen runs locally on your server. Ensure you manage access controls and API keys securely.

Core Features

• Local server-run SQLite database management
• Open-source and self-hosted for privacy and control
• God Mode: SQL query with natural language support and schema awareness
• Quick navigation: Cmd + K to access tables, databases, and settings
• Advanced search, error reporting, and easier setup
• Table relationships viewer and foreign key insights
• Responsive UI with mobile and desktop support
• Quick setup guides for Systemd, Docker, and Coolify with Docker Compose
• In-app backups and simple data entry improvements
• Real-time or near-real-time feedback and improved error handling

Why Choose Lite Queen?

• Keeps your data on your own server
• Actively maintained with open-source transparency
• Flexible deployment options for various hosting environments
• Rich UI with powerful database insight tools and shortcuts