SQL in Org-Mode

In org-babel-load-languages turn on sqlite. (You can use customize for this if you don't have another method in use.)

Then you have a source block that looks like

1
2
3
4
5

  _#+begin_src sqlite :db test.db :colnames yes
  create table if not exists  greeting(one varchar(10), two varchar(10));
  insert into greeting values( 'Hello', 'world!');
  select * from greeting;
  _#+end_src

(Remove the _ if you are copy and pasting.)

And that will print out

  create table if not exists  greeting(one varchar(10), two varchar(10));
  insert into greeting values( 'Hello', 'world!');
  select * from greeting;

You can also set the :db property globally in your org file with:

1

#+PROPERTY: header-args :db test-sqlite.db

And then reload the file.

Install ob-sql-mode using the normal methods. This will use sql-mode to run queries, which lets you use other databases than sqlite3.

1
2

  (use-package ob-sql-mode
    :ensure t)

In org-babel-load-languages turn on sql.

And then you can run queries like so:

1
2
3

  _#+begin_src sql-mode :product postgres
    select * from commits;
  _#+end_src

There's more to it but that gives you the rough idea!

1. https://www.reddit.com/r/emacs/comments/bb5mnv/sql_workflows_inside_emacs_anyone_have_a_nice/
2. https://orgmode.org/worg/org-contrib/babel/languages/ob-doc-sqlite.html
3. https://github.com/nikclayton/ob-sql-mode
4. https://orgmode.org/manual/Using-Header-Arguments.html#Using-header-arguments