Emacs as SQL client with LSP

This page summarizes the projects mentioned and recommended in the original post on dev.to

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • sqlfmt

    SQL formatter with width-aware output

  • gem install sqlint go get github.com/lighttiger2505/sqls wget -q -O - https://github.com/mjibson/sqlfmt/releases/download/v0.4.0/sqlfmt_0.4.0_darwin_amd64.tar.gz | tar -xpvzf - --directory "$HOME/go/bin" # for other distros you can check out the releases # here: https://github.com/mjibson/sqlfmt/releases # remember to extract the files to your go path

  • laurisp

    My elisp and emacs snippets aside .spacemacs and .emacs.d

  • Those are in my elisp repo

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
  • ohmyzsh

    🙃 A delightful community-driven (with 2,300+ contributors) framework for managing your zsh configuration. Includes 300+ optional plugins (rails, git, macOS, hub, docker, homebrew, node, php, python, etc), 140+ themes to spice up your morning, and an auto-update tool so that makes it easy to keep up with the latest updates from the community.

  • You need to export gopath on your .bashrc or similar, in my case I use Oh My Zsh:

  • go

    The Go programming language

  • We need to install the LSP support, the SQL linter and the SQL formatter, to do that we first need to install Go and Ruby.

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