v3.4.0 StableLocal-First Native MySQL Client

Copy for AI: Prompts, @ Table Mentions & DDL Export | VloamDb

Replace rigid, heavy built-in BI dashboards. VloamDb lets you type @ to attach real table DDLs into prompts, generating context-rich prompts for frontier AI models.

Design Philosophy: AI Collaboration vs Built-in Charts

In traditional database GUIs, built-in charting engines add tens of megabytes of binary bloat and heavy runtime memory overhead, yet offer only rigid bar or line charts that fall short of multi-table joins, root-cause analysis, and custom data intelligence.

VloamDb focuses strictly on developer speed and on-device privacy. We delegate open-ended data science and visual reporting to state-of-the-art AI models (Claude, ChatGPT, DeepSeek, Kimi, Qwen). With our built-in "Copy for AI" feature, the tedious workflow of extracting schemas, fetching DDLs, and writing system prompts is compressed into seconds.

⚡

Zero Engine Bloat

No bloated BI graphing libraries loaded into RAM; maintaining instantaneous launch and minimal footprint.

🧠

Frontier LLM Reasoning

Feed exact DDL context to LLMs to generate complex SQL joins, Mermaid diagrams, or data audit reports.

Type @ to Mention Tables & Attach DDLs Automatically

Click "Copy for AI" in the workspace toolbar. In the prompt editor, typing <code>@</code> instantly brings up the table picker for the active database:

1

Type @ to Fuzzy Match Table Names

Type a few letters to filter tables in the active database. Press Enter or click to attach.

2

Automatic Schema & DDL Extraction

Attached tables appear as chips. VloamDb automatically extracts exact CREATE TABLE DDL definitions—including column types, comments, primary keys, and indexes.

3

Structured Markdown Prompt

Outputs clean, structured Markdown optimized for LLM attention heads, maximizing reasoning accuracy.

Markdown (Generated Prompt Format)
帮我为 @orders 和 @users 写一条按月统计高净值用户复购率的分析查询。

### Database Schema Context

#### Table: `orders`
```sql
CREATE TABLE `orders` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_created` (`user_id`, `created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```

#### Table: `users`
```sql
CREATE TABLE `users` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tier` varchar(32) NOT NULL DEFAULT 'standard',
  `status` tinyint NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
```

Minimize Floating Panel While Inspecting Data

When authoring prompts, you frequently need to double-check column values or inspect real sample rows. Modal dialogs that lock the screen or lose draft state create huge friction.

💡
Minimize to Non-Intrusive Capsule

Click "Minimize" in the title bar. The modal folds into a floating bottom capsule. Freely browse tables, check cell values, or test queries in the console. When ready, click "Restore" to pick up your draft without losing a keystroke.

One-Click Launch into External AI Models

The dialog offers one-click shortcuts to popular frontier and local AI assistants:

Chinese Ecosystem Models

Presets for Doubao, Kimi, Qwen, and DeepSeek.

Global Frontier Models

Direct targets for ChatGPT (OpenAI) and Claude (Anthropic).

Clicking any AI target copies the formatted Markdown prompt to your system clipboard and opens the model in your default browser. Simply press <kbd>⌘V</kbd> / <kbd>Ctrl+V</kbd> to paste and send!