kristijanhusak / vim-dadbod-completion

# vim-dadbod-completion
Database auto completion powered by vim-dadbod.
Supports:
* coc.nvim
* deoplete.nvim
* nvim-compe
* nvim-cmp
* ddc.vim
* blink.cmp
* Built in `omnifunc`
Video presentation by TJ:
## Install
**Dependencies**:
* vim-dadbod
For coc.nvim
 [code] 
For `deoplete`, `completion-nvim`, `nvim-compe`, `ddc` and `omnifunc`, install it with your favorite plugin manager.
 [code] 
Configuration using lazy.nvim with vim-dadbod-ui
 [code] 
## Features
* Autocomplete table names, with automatic quoting where needed. Works for all schemes that vim-dadbod supports.
* Autocomplete table columns, context aware. Also knows to read aliases (`select * from mytable tbl where tbl.id = 1`). Currently works for `PostgreSQL`, `MySQL`, `Oracle`, `SQLite` (requires version `3.37.0 (2021-11-27)`) and `SQLserver/MSSQL`.
* Out of the box integration with vim-dadbod-ui
## How it works
* If an sql buffer is created by vim-dadbod-ui, it reads all the configuration from there. It should work out of the box.
* If `vim-dadbod-ui` is not used, there are multiple ways to define the connection string, prioritized by this order:
 * Window variable - example: `let w:db = 'postgresql://user:pass@localhost:5432/db_name'`
 * Tab variable - example: `let t:db = 'postgresql://user:pass@localhost:5432/db_name'`
 * Buffer variable - example: `let b:db = 'postgresql://user:pass@localhost:5432/db_name'`. You can also add `let b:db_table = 'table_name'` to limit column completions only to this table
 * Global variable - example: `let g:db = 'postgresql://user:pass@localhost:5432/db_name'`
 * `$DATABASE_URL` env variable, defined outside of Vim, or inside with `let $DATABASE_URL = 'postgresql://user:pass@localhost:5432/db_name'`
## Settings
Default mark for completion items is `[DB]`. To change it, add this to vimrc:
 [code] 
## Commands
This plugin caches the database tables and columns to leverage maximum performance. If you want to clear the cache at any point just run:
 [code] 
## Todo
* [ ] Integration for column autocompletion with more database types