dadbod-grip.nvim

nvim is a Neovim plugin designed to provide editable database grids directly within the editor, enabling users to interact with databases such as Postgres, MySQL, SQLite, DuckDB, MotherDuck, and data sources like Parquet, CSV, S3, and HTTPS. The tool allows users to edit database tables as if they were Vim buffers, with every Vim motion supported, and no installation required outside of Neovim itself. It is intended for users who want to manage and manipulate databases without leaving their code editor.

A key feature is its full edit cycle: users can stage changes—such as inserts, updates, and deletes—before any modification is committed to the database. Staged changes are color-coded for clarity and can be reviewed in a live SQL preview float, showing the exact DML statements that will be applied. All changes are committed in a single transaction, with the ability to roll back the entire batch if any failure occurs. The plugin also provides a mechanism to generate compensating statements to reverse commits after applying changes.

nvim supports cross-database federation by using DuckDB as a hub, allowing users to attach multiple databases and data sources, and perform JOIN operations across them in one SQL statement. The results appear as live, editable grids. Additional editing features include batch editing in visual mode, multi-level undo within staging, undo of applied transactions, and schema DDL operations such as renaming, adding, and dropping columns and tables. Users can also generate staged rows using AI, with support for models like Anthropic, OpenAI, Gemini, or local Ollama, leveraging full schema context for generation.

Navigation features include foreign key relationship navigation, a schema sidebar with primary and foreign key markers, a searchable command palette, row view transpose, and an ER diagram float. Analytical tools are provided to profile column distributions, explain query plans with cost and index suggestions, and diff tables by primary key. The tool also supports advanced sorting, filter building with multiple conditions, and saving/loading filter presets. cmp, and nvim-cmp, as well as SQL notebooks and named query management. Data can be exported to CSV, TSV, JSON, SQL, Markdown, or Grip Table formats, and the plugin supports watch mode for auto-refresh and write mode for persisting edits back to disk. nvim is distributed under the MIT License.