# LunoDB

> LunoDB is an AI-powered database client for developers. Manage MySQL, PostgreSQL, MongoDB, SQLite, MariaDB, SQL Server, Redis, Turso, and more from a beautiful desktop and mobile interface.

LunoDB combines a powerful query editor, AI assistant, and data visualization tools into one fast, cross-platform database application. Available on macOS, Windows, and Linux with a mobile app for iOS (Android coming soon).

## Supported Databases

- MySQL (5.7+, 8.0+)
- PostgreSQL (10–15+)
- SQLite
- MariaDB (10.0+)
- MongoDB
- SQL Server (2017+)
- Redis
- Turso (LibSQL)

## Key Features

- **LunoDB 2.1** (current desktop version, October 2026): builds on the 2.0 ground-up redesign with near-instant tab switching and faster, exact MySQL/MariaDB exports
- Connect to 8 database engines from a single app
- Connections home: search, filter by environment (Production, Staging, Local), paste a connection URL to fill the form, test before saving
- Reconnects last session's connections side by side; auto-reconnect banner keeps cached rows on screen and unsaved edits safe
- One filter bar: type a condition (`plan = pro`) or describe it in plain words and let AI build it
- Review the exact SQL before saving; saves run in one transaction (all or nothing)
- 6 AI tools: Write with AI, Filter with AI, AI Assistant, Data Insights, Optimize, Suggest graphs
- AI Assistant answers questions from your data (Pro): runs a safe, read-only query and shows a one-line answer, a chart, and the SQL
- 9 AI providers: OpenAI, Anthropic Claude, Google Gemini, xAI Grok, DeepSeek, OpenRouter, Ollama (fully local/private), Apple Intelligence (on-device), and custom endpoints
- Voice dictation via OpenAI Whisper for hands-free SQL generation
- Redesigned SQL editor (Pro) with schema-aware suggestions, per-statement results tabs, and safer Run all (one connection, stops on error, optional single transaction)
- Data visualization (Pro) with 5 built-in chart types
- ER diagram generation with PNG export
- Seed empty tables with realistic fake data
- SSH tunneling (password, key file, or SSH agent incl. 1Password and Secretive) and SSL/TLS encryption
- Saved passwords encrypted by the operating system (macOS Keychain, Windows account, Linux secret service)
- Export to CSV (free), JSON and SQL INSERT (Pro); import CSV files with column mapping and SQL dumps (.sql/.sql.gz); gzip for whole-database exports
- Multi-window workspace with cross-window settings sync
- Jump to… command palette (⌘P / Ctrl+P) for tables and actions
- QR code sync between desktop and mobile
- Built-in automatic updates on all platforms
- About 280 MB installed on a Mac (down from about 470 MB)

## Platforms

- **macOS**: 12+ (Intel and Apple Silicon)
- **Windows**: 10+ (x64)
- **Linux**: AppImage, .deb, .rpm (x64 and arm64)
- **iOS**: Available on the App Store
- **Android**: Coming soon

## Pricing

- **Free**: 2 saved connections, basic editor, table browsing, CSV export, Write with AI, Filter with AI, Data Insights and Optimize with your own API key, Ollama or Apple Intelligence
- **Pro** ($10 one-time or $1.99/month, 1 device): Unlimited connections, advanced SQL editor, Graphs and AI graph suggestions, AI answers from your data, SSH, required/verified SSL, JSON and SQL export, SQL history, copy & paste rows, editor themes, priority support. One-time licenses include 1 year of updates; Pro keeps working after that, and updates can be renewed for another year
- **Pro Bundle** ($20 one-time or $3.99/month, up to 3 devices): Everything in Pro for multiple devices
- 14-day Pro free trial available in-app, no credit card required

## Affiliate Program

- Earn **40% commission** on every LunoDB Pro sale you refer ($4 per Pro sale, $8 per Pro Bundle sale)
- 30-day referral cookie window
- Monthly payouts via PayPal or bank transfer
- Built for influencers, YouTubers, developer content creators, technical bloggers, podcasters, newsletter authors, course creators, and agencies
- Apply and learn more at [https://lunodb.app/affiliate](https://lunodb.app/affiliate)

## Docs

- [Homepage](https://lunodb.app/)
- [Desktop App](https://lunodb.app/desktop)
- [Documentation](https://lunodb.app/docs)
- [Download](https://lunodb.app/download)
- [Subscribe / Pricing](https://lunodb.app/subscribe)
- [Purchase (one-time)](https://lunodb.app/purchase)
- [FAQ](https://lunodb.app/faq)
- [Changelog](https://lunodb.app/changelog)
- [Blog](https://lunodb.app/blog)
- [Contact](https://lunodb.app/contact)
- [About](https://lunodb.app/about)
- [Affiliate Program](https://lunodb.app/affiliate)
- [Mobile App](https://lunodb.app/mobile)
- [Mobile Docs](https://lunodb.app/mobile/docs)
- [Mobile FAQ](https://lunodb.app/mobile/faq)
- [Mobile Changelog](https://lunodb.app/mobile/changelog)
- [Self-Host Mobile Proxy](https://lunodb.app/mobile/proxy)
- [Press Kit](https://lunodb.app/press)
- [Beta Download](https://lunodb.app/beta-download)
- [Beta Changelog](https://lunodb.app/beta-changelog)
- [License Recovery](https://lunodb.app/license/recover)
- [Account Management](https://lunodb.app/account)
- [Privacy Policy](https://lunodb.app/privacy-policy)
- [Terms of Service](https://lunodb.app/terms-of-service)
- [EULA](https://lunodb.app/eula)

## Optional

- [Full reference for AI assistants (llms-full.txt)](https://lunodb.app/llms-full.txt)