A Neovim plugin that lets you edit database tables like Vim buffers with live SQL preview, transaction undo, and cross-database federation.
dadbod-grip.nvim is a Neovim plugin that turns database tables into editable Vim buffers. It provides a full-featured database client inside Neovim, allowing developers to edit data inline, preview SQL changes, navigate schemas, and even query across multiple database engines simultaneously. It solves the problem of context switching between code editors and external database tools by bringing database interaction directly into the editor workflow.
Database administrators, data analysts, and backend developers who use Neovim and work regularly with PostgreSQL, MySQL, SQLite, or DuckDB databases. It's particularly valuable for those who want to explore, edit, and analyze data without leaving their editor.
Developers choose dadbod-grip.nvim because it offers a uniquely Vim-native experience for database work, with powerful features like visual change staging, transaction undo, cross-database federation, and AI-assisted SQL generation—all without requiring external applications or disrupting their editing workflow.
Edit database tables like Vim buffers. Staged mutations + live SQL preview, transaction undo, schema browser + ER diagrams + DDL, FK navigation, cross-database federation, data profiling, SQL notebooks, AI SQL via Anthropic/OpenAI/Gemini/Ollama, Parquet/CSV/remote files. PostgreSQL · SQLite · MySQL · DuckDB · MotherDuck
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Transforms database tables into editable Vim buffers with full Vim motions, undo/redo, and color-coded staging, allowing inline cell editing like a spreadsheet as described in the Editable Database Grids feature.
Enables querying across PostgreSQL, MySQL, SQLite, and DuckDB simultaneously using DuckDB as a hub via :GripAttach, supporting complex JOINs without leaving Neovim.
Integrates with Anthropic, OpenAI, Gemini, or local Ollama to convert natural language to SQL queries, with schema context caching for accuracy, accessible via the A key or :GripAsk.
Provides column statistics, sparkline distributions, and plain-English EXPLAIN plans through the Query Doctor feature, aiding in data analysis and performance tuning directly in the editor.
Requires specific database CLI tools (psql, sqlite3, mysql, duckdb) to be installed and available in PATH, adding setup complexity and potential compatibility issues across different systems.
Exclusively designed for Neovim 0.10+, making it inaccessible for users of other editors or IDEs, and restricting adoption in teams with mixed tooling preferences.
AI SQL generation requires API keys and provider setup, which can be cumbersome and may involve security risks if not handled properly, as noted in the configuration section.