SQL Client · macOS · Linux

The SQL client
that stays out of
your way.

Melocoton runs on macOS and Linux, speaks Vim fluently, and lets you move through queries, schemas, and results without touching a mouse.

macOS Ubuntu AppImage
melocoton — production_db
-- NORMAL --

Powerful where it
matters. Quiet everywhere else.

Vim key bindings, first-class

Navigate tables, edit queries, and move through results using the motions you already know. Not an afterthought — core to how Melocoton works.

hjkl · dd · yy · gg · G
Multi-platform, one experience

Built natively for macOS and Linux. No Electron. The same keyboard-first interface whether you're on an M-chip Mac or an Ubuntu workstation.

macOS · Linux
🔗
Multiple connections, live

Manage connections to production, staging, and local databases simultaneously. Switch contexts without losing your query history.

PostgreSQL · SQLite · MySQL
🗂
Schema browser

Inspect tables, columns, indexes, and foreign keys without writing a single INFORMATION_SCHEMA query. Navigate with keyboard shortcuts.

\dt · \d tablename
📊
Results as data, not just rows

Sort, filter, and page through query results. Export to CSV. Visualize numeric data inline. Designed to handle real result sets.

CSV export · inline charts
🤖
AI agent chat

Ask questions about your data in plain language. The AI agent understands your schema, writes queries on your behalf, and explains results — without leaving the app.

Claude · OpenAI · MiniMax · OpenRouter · Ollama
New

Talk to your database.
In plain English.

Melocoton's built-in AI agent knows your schema. Ask it anything — it'll write the query, run it, and explain what it found. No tab-switching, no copy-pasting into ChatGPT. Works with Claude, OpenAI, MiniMax, OpenRouter, and Ollama.

"Which users signed up this week but haven't activated yet?"
"Show me the top 5 tables by row count"
"Why is this query slow? Add an index if needed."

Your muscle memory
is a feature.

Melocoton's modal editing follows Vim conventions. Switch modes, navigate results, and edit queries without lifting your hands from the home row.

PostgreSQL SQLite MySQL More coming
Query editor
i
Enter INSERT mode
dd
Delete current line
yy
Yank (copy) current line
p
Paste below cursor
Execution
Ctrl+Enter
Run query
Ctrl+r
Query history

Free and
open source.

Melocoton is free to use and openly developed. If it saves you time, consider supporting the project.


View source on GitHub → ☕ Buy me a coffee →
macOS
⚠ Not notarized

macOS may block the app on first launch. Run this command in Terminal after installing to remove the quarantine flag:

xattr -cr /Applications/melocoton.app