Eval SQL in Org Babel using sql-connection-alist for credentials

Question

I would like to evaluate SQL source blocks in Org Babel using the connections I have set up in sql-connection-alist from sql-mode. This way I can save database credentials in a private (Elisp) file and share the files with the queries.

Is there any way to configure this in Org Mode?

score 4 · Accepted Answer · answered May 08 '19 at 13:48

4

I submitted a patch to do this: ob-sql.el: Option to reference connections in `sql-connection-alist'. It should be included in the next version of Org Mode.

answered May 08 '19 at 13:48

larsen

231
3
10

It's out with Org 9.3 – larsen Dec 06 '19 at 08:33
Last time I tried using this I was looking for exactly this and gave up, glad to see it has been added. Super useful - thanks! – actionshrimp Dec 17 '20 at 10:01

Eval SQL in Org Babel using sql-connection-alist for credentials

1 Answers1