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
Space f e d to open the Spacemacs configuration and add database connection configuration to the
Space h Space
sql-help for help with SQL query syntax.
- MySQL installation guide documents many options for installing MySQL