Query databases in Neovim (DBUI)

• backend: tpope/vim-dadbod: Modern database interface for Vim
• UI: kristijanhusak/vim-dadbod-ui: Simple UI for above backend

General:

As of 2025-02-23, supports a modern array of backends, including NoSQL databases:
- Big Query
- ClickHouse: clickhouse://[<host>[:port]]/[<database>]
- DuckDB: duckdb:/Users/sspaeti/Documents/duckdbs/playground-v1-1-1.duckdb
- Impala
- jq
- MongoDB
- MySQL
- MariaDB
- Oracle
- osquery
- PostgreSQL: postgresql:///foobar
- Presto
- Redis
- Snowflake
- SQL Server
- SQLite: sqlite:myfile.sqlite3 select count(*) from widgets
- Your own easily implemented adapter

• Easily configurable based on a project directory (as seen in rails.vim, for example), rather than just globally or in a per-file modeline
• For those that just can’t live without some piece of dbext functionality, the option g:dadbod_manage_dbext is provided to force dbext to use Dadbod’s default database.

E.g. DuckDB

1

duckdb:/Users/sspaeti/Documents/duckdbs/playground-v1-1-1.duckdb

My configs in database.lua:

1
2
3
4
5

      vim.g.dbs = {
        local_postgres_sspaeti = 'postgres://postgres@localhost:5432/sspaeti',
        duckdb_memory = 'duckdb:',
        duckdb_file = 'duckdb:///tmp/analytics.duckdb',
      }

In Action:

• Vim Dadbod - My Favorite SQL Plugin - YouTube

• nvim-dbee: Interactive database client for neovim
• Use Neovim features only with exporting database into a variable and run the cli for the data base such as psql and return to vim. Great example by Henry Misc here: Run SQL in Vim Without Plugins.

• Neovim

Origin:
References: SQL IDEs
Created 2023-10-19