dblite.nvim — query Oracle & SQL Server straight from Neovim (native binary, no JVM at runtime)
Most of the great DB plugins (vim-dadbod and nvim-dbee) are fantastic — until $DAYJOB hands you an Oracle or SQL Server box and the experience falls off a cliff. I was tired of alt-tabbing to SQL Developer / SSMS just to run a SELECT, so I built dblite.nvim.
You write SQL in any buffer, run it, and get paginated results in a split — named connections, typed bind params, history, exports, and schema-aware completion.
What it does
- Run the whole buffer, or just the statement under your cursor (treesitter-aware)
- Paginated result split with column types, query timing, and a per-session history you can page back through (
[/]) - Named connections with
$ENV_VARpassword refs, storedchmod 600 - Typed bind params from a
dblite.binds.json— numbers, auto-quoted strings, and raw SQL expressions - Export the entire result set (not just the visible page) to CSV/JSON
- SQL autocomplete via blink.cmp — tables, columns, and bind names pulled from the live schema
The nerdy bit
Oracle/SQL Server drivers are JDBC — i.e. Java. I didn't want to make anyone install a JVM, so the DB layer is compiled to a native binary with GraalVM native-image and shipped pre-built. It's downloaded on install; there's no JVM at runtime. Falls back to a source build only if there's no binary for your platform.
Requirements: Neovim 0.11+ (optional: jq, telescope.nvim, blink.cmp).
Roadmap is MySQL next. It's early, so I'd genuinely love feedback — especially from anyone else stuck in Oracle/SQL Server land. Bug reports and "this workflow feels weird" takes equally welcome.