sqls

sqls: SQL Language Server

An implementation of the Language Server Protocol for SQL.

Note

This project is currently under development and there is no stable release. Therefore, destructive interface changes and configuration changes are expected.

Features

sqls aims to provide advanced intelligence for you to edit sql in your own editor.

Support RDBMS

• MySQL(Go-MySQL-Driver)
• PostgreSQL(pgx)
• SQLite3(go-sqlite3)
• MSSQL(go-mssqldb)
• H2(pgx)
• Vertica(vertica-sql-go)

Language Server Features

Auto Completion

• DML(Data Manipulation Language)
  • SELECT
    • Sub Query
  • INSERT
  • UPDATE
  • DELETE
• DDL(Data Definition Language)
  • CREATE TABLE
  • ALTER TABLE

Join completion

If the tables are connected with a foreign key sqls can complete JOIN statements

CodeAction

• Execute SQL
• Explain SQL
• Switch Connection(Selected Database Connection)
• Switch Database

Hover

Signature Help

Document Formatting

Installation

go install github.com/sqls-server/sqls@latest

Editor Plugins

• sqls.vim
• vscode-sqls
• sqls.nvim
• Emacs LSP mode

DB Configuration

The connection to the RDBMS is essential to take advantage of the functionality provided by sqls. You need to set the connection to the RDBMS.

Configuration Methods

There are the following methods for RDBMS connection settings, and they are prioritized in order from the top. Whichever method you choose, the settings you make will remain the same.

1. Configuration file specified by the -config flag
2. workspace/configuration set to LSP client
3. Configuration file located in the following location
   • $XDG_CONFIG_HOME/sqls/config.yml ("$HOME/.config" is used instead of $XDG_CONFIG_HOME if it's not set)

Configuration file sample

…

Workspace configuration Sample

• setting example with vim-lsp.

…

• setting example with coc.nvim.

In coc-settings.json opened by :CocConfig

{
    "languageserver": {
        "sql": {
            "command": "sqls",
            "args": ["-config", "$HOME/.config/sqls/config.yml"],
            "filetypes": ["sql"],
            "shell": true
        }
    }
}

• setting example with nvim-lspconfig.

require'lspconfig'.sqls.setup{
  on_attach = function(client, bufnr)
    require('sqls').on_attach(client, bufnr) -- require sqls.nvim
  end
  settings = {
    sqls = {
      connections = {
        {
          driver = 'mysql',
          dataSourceName = 'root:root@tcp(127.0.0.1:13306)/world',
        },
        {
          driver = 'postgresql',
          dataSourceName = 'host=127.0.0.1 port=15432 user=postgres password=mysecretpassword1234 dbname=dvdrental sslmode=disable',
        },
      },
    },
  },
}

• Setting example for Sublime Text 4

  Install the LSP Client by Opening the command palette and run Package Control: Install Package, then select LSP.

  Open Preferences > Package Settings > LSP > Settings and add the "sqls" client configuration to the "clients":

{
    "show_diagnostics_count_in_view_status": true,
    "clients": {
        "sqls": {
            "enabled": true,
            "command": ["/path/to/sqls binary"],
            "selector": "source.sql"
        }
    }
}

I'm sorry. Please wait a little longer for other editor settings.

Configuration Parameters

The first setting in connections is the default connection.

connections

dataSourceName takes precedence over the value set in proto, user, passwd, host, port, dbName, params.

sshConfig

DSN (Data Source Name)

See also.

Contributors

This project exists thanks to all the people who contribute.

Inspired

I created sqls inspired by the following OSS.

• dbcli Tools
  • mycli
  • pgcli
  • litecli
• non-validating SQL parser
  • sqlparse