sqmeow.nvim

Your database, right inside Neovim. Explore schemas, run queries, and edit results without leaving your editor.

Rust, Lua, Neovim

sqmeow.nvim puts your database inside Neovim. Browse schemas, run queries, and edit results without leaving the editor. A separate Rust process runs the queries and pages large results, so Neovim stays responsive.

#From a connection to a result

Keep several connections open, browse schemas and tables, then run the statement under the cursor, a visual selection, or an entire buffer. Scratchpads and query history persist across restarts. Query plans from EXPLAIN and errors appear alongside results.

The same interface supports PostgreSQL and CockroachDB, MySQL and MariaDB, SQLite, DuckDB, ClickHouse, Redis-compatible servers, MongoDB, ScyllaDB and Cassandra, SurrealDB, Oracle Database, and Microsoft SQL Server. ClickHouse results are read-only.

PostgreSQL columns, indexes, and table definition displayed inside Neovim — Inspect types, keys, indexes, and the table definition without opening another tool.

#Edit, review, apply

Edit a cell, stage a new row, or mark rows for deletion in the result grid. Open the review window to inspect the generated SQL before applying changes. Editing requires the source table's full primary or unique key; joined results can update each table through its own key, while adding rows requires a single-table result.

Staged deletions and a cell update with generated SQL in the review window — The review window shows exactly which statements will run.

#Project connections and completion

A project can declare its databases in .sqmeow/connections.toml, one section per connection, so cloning the repo is enough to share the setup. Scratchpads complete schema, table, and column names through blink.cmp or nvim-cmp, with query-aware column suggestions when the sql Treesitter parser is installed.

#Everyday database tools

Filter and sort: SQL queries rerun on the database; MongoDB uses filter and sort documents. Redis, ScyllaDB, SurrealDB, and closed connections filter cached results in memory.
History and export: reopen saved results and export to CSV, JSON, or SQL INSERT statements, to a file or the clipboard.
Connections and secrets: use SSH tunnels and read credentials from environment variables, files, or commands. Passwords are masked in displayed URLs.
Destructive-query checks: confirmations precede operations such as an unqualified DELETE or UPDATE, DROP, and TRUNCATE. Read-only connections add protection; for drivers that check commands rather than enforce a database session, use a read-only database account.

#Get started

Requires Neovim 0.10+ and nui.nvim. Install with lazy.nvim, run :checkhealth sqmeow, then open :Sqmeow and add a connection. The repository README contains the installation snippet, supported connection URLs, and keymap reference, with extra setups for mini.deps and vim.pack.

Introducing sqmeow.nvim: a closer look at the features.
How I use Neovim as a database client: my setup and daily workflow.