LiteDB
A modern, fast, and user-friendly database editor
with AI-powered Text-to-SQL and semantic search.
Modern tech stack
Everything you need
Built for developers who need a fast, reliable, and intuitive way to manage their databases.
Dual Database Support
Seamlessly work with both SQLite and PostgreSQL databases in a single interface.
Advanced Search
Filter and search through your data with powerful query capabilities.
Real-time Updates
Changes reflect immediately with live synchronization across views.
Data Sorting
Sort any column with a single click for quick data organization.
Responsive Design
Works beautifully on any screen size, from mobile to ultrawide.
Batch Operations
Execute multiple SQL statements with full transaction support.
SQL Script Management
Save, organize, and reuse your SQL scripts effortlessly.
Export Options
Export query results to CSV, Excel, or JSON with one click.
See your database
at a glance
Powerful Entity Relationship Diagram generator with interactive exploration. Understand your database structure instantly.
Interactive Graph
Drag, drop, zoom, and explore relationships
Visual Foreign Keys
Lines connect FKs to PKs automatically
Auto-Layout
Smart arrangement minimizes crossing lines
Export Ready
One-click export to PNG or SVG
Natural language to SQL
Turn your questions into precise SQL queries. Privacy-first with 100% local processing support via Ollama.
"Show me all orders from last month with total over $100"
Privacy-First AI
100% local Text-to-SQL support with Ollama. Your data never leaves your machine.
Schema-Aware
Schema is injected into the LLM upon initialization. The AI understands your exact database structure.
Multiple Providers
Supports OpenAI, GitHub, and Azure providers for flexible deployment options.
Semantic search
for your data
Find similar records using vector embeddings. Powered by pgvector with local embedding models for complete privacy.
Search by Text
Natural language queries
Local Models
Transformers.js in-browser
Privacy-First
No external API calls
Visual Feedback
Color-coded similarity
Ready to dive in?
Download LiteDB and start exploring your databases with a modern, intuitive interface.