Do you give use Vim for SQL. It took me a while to setup this. sqls - lang server (auto complete), dadbodUI (view table, execute and save query), prettier-sql (format code on save).

This page summarizes the projects mentioned and recommended in the original post on /r/SQL

CodeRabbit: AI Code Reviews for Developers
Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.
coderabbit.ai
featured
Nutrient – The #1 PDF SDK Library, trusted by 10K+ developers
Other PDF SDKs promise a lot - then break. Laggy scrolling, poor mobile UX, tons of bugs, and lack of support cost you endless frustrations. Nutrient’s SDK handles billion-page workloads - so you don’t have to debug PDFs. Used by ~1 billion end users in more than 150 different countries.
www.nutrient.io
featured
  1. sqls

    Discontinued SQL language server written in Go.

    I used sqls as lang server for LSP, after install you config your localhost with config.yml as the doc said https://github.com/lighttiger2505/sqls

  2. CodeRabbit

    CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

    CodeRabbit logo
  3. vim-dadbod

    dadbod.vim: Modern database interface for Vim

    I used dadbodUI for viewing table, before you install dadbodUI, remember to install dadbod https://github.com/tpope/vim-dadbod

  4. vim-dadbod-ui

    Simple UI for https://github.com/tpope/vim-dadbod

  5. prettier-sql

    Discontinued [ARCHIVED] Please use https://github.com/sql-formatter-org/sql-formatter

    I also use auto format to auto indent and give uppercase to the code because I like SQL in uppercase but very lazy to hold the shift key to type them I used prettier-sql as my formatter https://github.com/inferrinizzard/prettier-sql

  6. format.nvim

    Discontinued A wrapper around Neovims native LSP formatting. [Moved to: https://github.com/lukas-reineke/lsp-format.nvim]

    To format on save you need to install format https://github.com/lukas-reineke/format.nvim

  7. NeoVimLua

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Show HN: PostgreSQL Sessions in Vim

    5 projects | news.ycombinator.com | 3 Nov 2022
  • Any handy plug-ins to set up a workflow for Java?

    2 projects | /r/vim | 5 Sep 2022
  • [plugin woes] Any vim-lsp-ale alternatives for built-in lsp client?

    15 projects | /r/neovim | 16 Apr 2022
  • nvim ignoring my ~/.local/share/nvim/site/pack/coc/start

    8 projects | /r/neovim | 3 Nov 2021
  • vim-lsp + ALE bridge

    4 projects | /r/vim | 28 Apr 2021