sql-language-server vs lsp-mssql

With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

surveyjs.io

featured

InfluxDB - Power Real-Time Data Analytics at Scale

Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

www.influxdata.com

featured

sql-language-server		lsp-mssql
	Project
4	Mentions	2
645	Stars	32
-	Growth	-
6.4	Activity	3.2
4 months ago	Latest Commit	about 1 month ago
TypeScript	Language	Emacs Lisp
MIT License	License	MIT License

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.

sql-language-server

Posts with mentions or reviews of sql-language-server. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-08-04.

SQL LSP dialect
2 projects | /r/neovim | 4 Aug 2023

I'm struggling to get [sqlls](https://github.com/joe-re/sql-language-server) with [nvim-lspconfig](https://github.com/neovim/nvim-lspconfig) to use Postgres syntax.
What SQL formatter do you use? What can give you Intellij like formatting for SQL?
5 projects | /r/neovim | 19 Apr 2023

I also use sql-language-server for completion. It works for me with a .sqlrc.json config file, which allows me to change database config based on parent directory. I have not been able to configure sqlls with nlsp-settings for some reason.
A postgres plugin for neovim
2 projects | /r/neovim | 15 Mar 2022

Nice. I'm going to try it out. This would go well with sql-language-server.
BigQuery Language Server
2 projects | /r/bigquery | 6 Jul 2021

Has anyone attempted to develop a custom language server protocol for BigQuery? I've been looking online, and I see one that supports MySQL, SQLite3 and Postgre (https://github.com/joe-re/sql-language-server) but does one exist for BigQuery?

lsp-mssql

Posts with mentions or reviews of lsp-mssql. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-05-28.

Neovim as an alternative to SSMS or Azure Data Studio - is it a pipe dream?
2 projects | /r/neovim | 28 May 2023

The state of mssql support in text editors is not very good as far as I've seen. I think the shortest path would be getting sqltoolservice working, but there are some bumps in the emacs attempt. (For instance, I can't get completions to work at all).
What SQL formatter do you use? What can give you Intellij like formatting for SQL?
5 projects | /r/neovim | 19 Apr 2023

I couldn't find any LSPs that work with mssql using Windows authentication. There's lsp-mssql that could be the basis for something, but that's an emacs package, and I wasn't getting completions to work anyhow (issue)

What are some alternatives?

When comparing sql-language-server and lsp-mssql you can also consider the following projects:

oslint - Open-Source Good Practices Analysis

lsp-ui - UI integrations for lsp-mode

commitlint - 📓 Lint commit messages

lsp-java - lsp-mode :heart: java

zetasql - ZetaSQL - Analyzer Framework for SQL

sleek - Sleek is a CLI tool for formatting SQL. It helps you maintain a consistent style across your SQL code, enhancing readability and productivity.

jupyterlab-lsp - Coding assistance for JupyterLab (code navigation + hover suggestions + linters + autocompletion + rename) using Language Server Protocol

sqltoolsservice - SQL Tools API service that provides SQL Server data management capabilities.

nlsp-settings.nvim - A plugin for setting Neovim LSP with JSON or YAML files

null-ls.nvim - Use Neovim as a language server to inject LSP diagnostics, code actions, and more via Lua.