SQL layer

Table of ContentsClose

1. Description
2. Install
3. Key bindings

1 Description

This layer adds key bindings and configuration for sql-mode, which manages interactive SQL buffers and highlights a wide range of SQL dialects.

2 Install

To use this configuration layer, add it to your ~/.spacemacs. You will need to add sql to the existing dotspacemacs-configuration-layers list in this file.

3 Key bindings

3.1 Highlighting

Key Binding	Description
`SPC m h k`	select a SQL dialect to highlight

3.2 Inferior Process Interactions (SQLi)

Key Binding	Description
`SPC m b b`	show the SQLi buffer name
`SPC m b s`	set the SQLi buffer
`SPC m l a`	List all objects
`SPC m l t`	list all objects in a table

3.2.1 Send SQL queries to SQLi:

Key Binding	Description
`SPC m s b`	Send the whole buffer to the SQLi buffer
`SPC m s B`	Send the whole buffer to the SQLi buffer and switch to it in `insert state`
`SPC m s i`	Start the SQLi process
`SPC m s f`	Send the paragraph around point to the SQLi buffer
`SPC m s F`	Send the paragraph around point to the SQLi buffer and switch to it in `insert state`
`SPC m s q`	Prompt for a string to send to the SQLi buffer
`SPC m s Q`	Prompt for a string to send to the SQLi buffer and switch to it in `insert state`
`SPC m s r`	Send the selected region to the SQLi buffer
`SPC m s R`	Send the selected region to the SQLi buffer and switch to it in `insert state`

3.3 SQLi buffer

Key Binding	Description
`SPC m b r`	rename buffer (follow up in the SQL buffer with `SPC m b s`)
`SPC m b S`	save the current connection