Skip to content

Database Access from Emacsλ︎

Add the Spacemacs SQL layer to use Emacs as an SQL database client, defining connections to access databases and running SQL queries.

sqls language server (LSP) as an SQL layer backend provides autocompletion, code actions, documentation and formatting. sqlint (linting) and sqlfmt (formatting) are also supported when installed.

Syntax highlighting for SQL queries supports the dialects of ANSI, DB2, Informix, Ingres, Interbase, Linter, Microsoft, MySQL, Oracle, Postgres, Solid, SQLite, Sybase, Vertica.

SQLi is integrated in Emacs and supports these databases if their client executable is available on the Emacs PATH

Connection configuration can be defined for a specific database, e.g. sql-mysql-login-params. Multiple database connections are defined using the sql-connection-alist variable.

Space f e d to open the Spacemacs configuration and add database connection configuration to the dotspacemacs/user-config section.

Space h Space sql-help for help with SQL query syntax.