Hey all — wanted to share the last two releases of LunoDB (a cross-platform database client for MySQL, PostgreSQL, MariaDB, SQLite, MongoDB, SQL Server, Redis, and Turso). v1.27.0 shipped in early April, and v1.27.1 just went out on May 1st. Bundling them together since they tell one story.
If you don't know LunoDB: it's a desktop client with built-in AI features (natural-language SQL, AI chat, smart filters, AI graph suggestions, data insights, and a query optimizer) — and it works with both cloud providers and local models via Ollama.
## What's new
### AI models
Every major frontier model is now wired into every AI feature:
-
**GPT-5.5**
— OpenAI's newest frontier model
-
**Claude Opus 4.7**
— Anthropic's most capable Claude
-
**Grok 4.3**
— xAI's flagship, now the new Grok default
-
**Grok 4.20 Multi-Agent**
— xAI's deep-research model with an Agents picker (4 sub-agents for focused queries, 16 for deep multi-faceted research)
-
**GPT-5.4**
also landed earlier in v1.27.0 with advanced reasoning + configurable effort levels
### Ollama (private/local AI) finally caught up
If you don't want anything leaving your machine, this is the big one:
-
**Web search for Ollama**
— local models can now pull in up-to-date context from the web. Configure your search API key in Settings, then toggle web search on/off per AI feature. Database data stays local; only the search query goes out.
-
**Thinking mode for Ollama**
— extended, step-by-step reasoning on supported models, with adjustable effort levels.
-
**Independent toggles**
— enable/disable web search and thinking per AI component (chat, SQL gen, filters, etc.).
-
**Model sync**
— fetched models now show up in every AI dropdown across the app instead of falling back to a default. Lists are saved locally so they're available immediately on next launch.
-
**Full cloud catalog**
— fetching now includes every cloud model in Ollama's catalog, with the correct hosted tag so they actually run (fixed a bug where things like `gemma4:cloud` returned 404).
### Connection handling polish
Small things that added up:
- Clicking a connection you're already viewing now gives a quick confirmation instead of doing nothing
- The sidebar auto-scrolls the selected connection into view in long lists
- "Connect to Database" no longer pre-highlights the first entry — pressing Enter won't accidentally connect you to something
- Older saved connections are automatically backfilled with any missing fields for consistent behavior
### MySQL imports
- Import failures now produce clearer, more actionable error messages instead of cryptic stack traces
### AI Assistant fixes
- Fixed an issue where the AI sidebar would show "No tables available" / "Schema: 0 tables" even when the connected DB clearly had tables. The table picker now populates as soon as a database is selected.
- Schema context sent to the AI now includes your tables by default instead of being empty.
### Performance touches
- AI features load with fewer background requests
- Settings dialog opens faster (loads everything in one step)
- Smoother search on large tables
---
Free to try with a 14-day Pro trial. Stable + beta channels both available. Works on macOS, Windows, and Linux.
Download / changelog: https://lunodb.app
Happy to answer questions about any of it — especially curious if anyone's tried Ollama web search or the multi-agent Grok yet.
Hey all — wanted to share where LunoDB's private-AI story has landed after the last two releases (v1.27.0 in early April, v1.27.1 on May 1st). If you've been holding off on AI features in your database client because you don't want your schema, queries, or data passing through OpenAI / Anthropic / Google's servers, this update is for you.
If you don't know LunoDB: it's a cross-platform desktop database client (MySQL, PostgreSQL, MariaDB, SQLite, MongoDB, SQL Server, Redis, Turso) with built-in AI features — natural-language SQL, AI chat, smart filters, graph suggestions, data insights, and a query optimizer. The big thing: **all of it works with local Ollama models**, and the cloud providers are strictly opt-in.
## How privacy actually works in LunoDB
- **Ollama is fully local.** Run any model on your own machine. No API key needed, no account, no telemetry, nothing leaves your device. Cell values, schema, queries, results — all stay on your hardware.
- **Cloud providers are opt-in per feature.** You choose which provider (and which model) for each AI feature individually. Nothing routes to a cloud unless you explicitly select one.
- **Even when you do use a cloud provider, only schema metadata is sent — never your actual row data.** That's a deliberate design choice from day one.
- **API keys are stored in your OS keychain** (Keychain on macOS, DPAPI on Windows, Secret Service on Linux). They never touch LunoDB's servers — they go directly from your machine to the AI provider you chose.
- **No analytics or tracking on AI calls.** We don't see prompts, responses, or usage.
## What's new for Ollama in v1.27
This is where it got really good:
- **Web search for Ollama models** — local models can now pull in up-to-date context from the web for things they don't know (e.g., new SQL syntax, recent library changes). You configure your own search API key in Settings, and only the search *query* goes out — your database data still never leaves the machine. Toggle it on/off per AI feature, so you can keep certain features fully airgapped.
- **Thinking mode** — extended, step-by-step reasoning on supported Ollama models, with adjustable effort levels (quick answer → deep analysis). Independent toggle per feature.
- **Model sync across the app** — models you pull in Settings now show up in every AI dropdown (chat, SQL gen, filters, etc.) instead of falling back to a default. Lists are cached locally so they're there the moment you launch.
- **Full Ollama cloud catalog** supported — and v1.27.1 fixed a bug where cloud-hosted entries like `gemma4:cloud` showed the wrong tag and returned 404. Now they show the correct hosted tag (`gemma4:31b-cloud`, `gpt-oss:120b-cloud`, etc.) and run as expected.
In practice: if you point LunoDB at a local model like `llama3.3:70b` or `qwen2.5-coder:32b` over Ollama, you can do natural-language SQL, filter generation, schema-aware chat, and query optimization without a single byte of your database leaving your laptop. With thinking mode on, the local-model output is genuinely competitive for query work — even on a single workstation.
## What else shipped
For folks who do want the frontier cloud models (still strictly opt-in, schema-only):
- **GPT-5.5** (OpenAI), **Claude Opus 4.7** (Anthropic), **Grok 4.3** (xAI) — all available across every AI feature
- **Grok 4.20 Multi-Agent** — xAI's deep-research model, with a picker for 4 sub-agents (focused queries) or 16 (deep multi-faceted research)
Plus some non-AI polish:
- Clicking a connection you're already viewing gives a quick confirmation instead of silently doing nothing
- Sidebar auto-scrolls the selected connection into view
- "Connect to Database" no longer pre-highlights the first entry — pressing Enter won't accidentally connect you to something
- Older saved connections are automatically backfilled with any missing fields
- Clearer error messages on MySQL import failures
- Fixed an AI Assistant bug where the table picker showed "No tables available" even when the DB had tables (schema context now includes your tables by default)
- Lighter background load, faster Settings dialog, smoother search on large tables
---
Free to try with a 14-day Pro trial. Stable + beta channels both available. Works on macOS, Windows, and Linux.
Download / changelog: https://lunodb.app
Happy to answer any questions — especially privacy/threat-model questions, or about how Ollama compares to the cloud providers for SQL work in practice. We've put a lot of effort into making local-only the default path that *actually works*, not just a checkbox.
u/Equivalent_Cut_7938 — 22 days ago