Skip to content

Releases: hello-world-bfree/nvim-duckdb

v0.10.0

30 Jan 03:24

Choose a tag to compare

What's New in v0.10.0

This release adds significant new features for productivity and data workflow integration.

New Features

Query History

  • Persistent query history stored across sessions
  • :DuckDBHistory command to browse and re-execute past queries
  • <leader>dh keymap for quick access

SQL Scratch Buffer

  • :DuckDBScratch opens a persistent SQL editing buffer
  • Press <CR> to execute the statement under cursor
  • Auto-saves and persists across sessions

Result Buffer Actions

New keymaps in result windows:

  • f - Filter results (add WHERE clause)
  • s - Sort by column under cursor
  • ya - Yank as JSON array
  • yo - Yank JSON with format selection
  • yc - Yank as CSV
  • e - Export to file
  • r - Re-run query

Schema Statistics

  • :DuckDBSummary shows SUMMARIZE statistics
  • :DuckDBHover shows column stats under cursor
  • K mapping on CSV/JSON files for quick column info

HTTP Export

  • :DuckDBPost <url> to POST query results to APIs
  • Supports multiple JSON formats (array, object, single)

Data Transform with Diff

  • :DuckDBTransform <query> shows changes in diff view
  • Preview before applying transformations

Enhanced Completion

  • Buffer name tab-completion inside buffer('...') syntax

Telescope Integration (Optional)

  • :Telescope duckdb history for query history picker
  • :Telescope duckdb buffers for buffer picker

New Commands

Command Description
:DuckDBScratch Open persistent SQL scratch buffer
:DuckDBHistory Browse and rerun query history
:DuckDBSummary Show SUMMARIZE statistics
:DuckDBHover Show column stats under cursor
:DuckDBPost <url> POST query results to URL
:DuckDBTransform Transform with diff preview

New Configuration Options

require('duckdb').setup({
  history_limit = 500,
  scratch_path = nil,  -- custom path or default
  hover_stats = true,
  inline_preview = true,
  inline_preview_debounce_ms = 500,
})

Documentation

README completely rewritten using Diataxis methodology with:

  • Step-by-step tutorials
  • Task-oriented how-to guides
  • Complete API reference