{"repo":"kristijanhusak/vim-dadbod-completion","free":true,"listed":false,"github":"https://github.com/kristijanhusak/vim-dadbod-completion","clone":"git clone https://github.com/kristijanhusak/vim-dadbod-completion.git","description":"Database autocompletion powered by https://github.com/tpope/vim-dadbod","language":"Vim Script","stars":795,"topics":["vim","vim-plugin","neovim","neovim-plugin","coc","autocompletions","database","deoplete","deoplete-source","vim-plugins"],"license":"MIT","category":"databases-storage","readme_excerpt":"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 For deoplete , completion-nvim , nvim-compe , ddc and omnifunc , install it with your favorite plugin manager. Configuration using lazy.nvim with vim-dadbod-ui 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 varia","default_branch":null,"files":null,"tree":[],"storefront":"/r/kristijanhusak","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/kristijanhusak/vim-dadbod-completion/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}