SQL Client · macOS · Linux · Windows

The SQL client
that stays out of
your way.

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

macOS Ubuntu AppImage Windows
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, Linux, and Windows. No Electron. The same keyboard-first interface whether you're on an M-chip Mac, an Ubuntu workstation, or a Windows PC.

macOS · Linux · Windows
🔗
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 →