CloudBeaver

This is an Obsidian community plugin for CloudBeaver - a web-based database management tool. It lets you run SQL against any database connected to your CloudBeaver server directly from your vault.

Usage

After enabling the plugin, open the results panel from the ribbon icon (database symbol) or the Open CloudBeaver command. Configure your server and connections once under Settings -> CloudBeaver, then write SQL in a cloudbeaver code block anywhere in your notes:

```cloudbeaver prod
SELECT id, name, created_at
FROM users
WHERE active
```

prod is a connection alias you name in settings - leave it out to use your default connection. Place your cursor inside the block and press Run in the panel, or Cmd/Ctrl+Enter.

Features

• Run SQL against any connection your CloudBeaver server has, from a results panel docked in the sidebar or a tab.
• Keep queries next to your notes as runnable cloudbeaver code blocks, instead of copy-pasting them from elsewhere.
• Read-only by default. A connection refuses anything that isn't SELECT, WITH, SHOW, EXPLAIN, or DESCRIBE until you explicitly enable writes for it.
• Point a connection at a specific database or schema, separate from its own default.
• Browse your last 50 queries and copy one back to the clipboard.

This plugin does not include a schema browser, autocomplete, result editing, or writing results back into your notes. It runs the SQL you give it and shows you the table - nothing more.

Settings

Configure the plugin under Settings -> CloudBeaver:

Compatibility

Requires Obsidian 1.7.2 or later, desktop only. Designed for self-hosted CloudBeaver instances (Community or PRO).

Installation

1. Open Settings -> Community plugins and select Browse.
2. Search for CloudBeaver and select Install.
3. Enable the plugin.

FAQ

Why doesn't Run do anything when my cursor is in Reading view? Reading view has no text cursor at all, so there's nothing to detect a block from. Switch to Edit mode (or Live Preview), click inside a cloudbeaver block, then press Run.

Where are my credentials stored? In this plugin's data.json, inside your vault, unencrypted. See Where your data lives.

Can I run more than one statement per block? No. One statement per block, no transactions, no ;-separated batches.

Protips

• Bind a hotkey to the Run SQL block at cursor command under Settings -> Hotkeys so you never need the mouse.
• The copy icon in a result's status line copies the whole table as a Markdown table - paste it straight into a note.
• Enable Allow writes on a connection only when you mean to run INSERT / UPDATE / DELETE there - it asks for a one-time confirmation and stays off by default for a reason.

Getting started (local testing)

1. Start CloudBeaver:

   docker run -d -p 8978:8978 dbeaver/cloudbeaver:latest
   

   Or follow the full installation guide.

2. Configure authentication - follow the Local Access Authentication guide. Create a user (login/password) or use the admin credentials.

3. Create a database connection - follow the Create Connection guide.

4. In Obsidian:

   • Open Settings -> CloudBeaver, enter the server URL and credentials
   • Click Test connection, then Fetch from server and give the connection an alias
   • Add a cloudbeaver code block to a note and run it from the results panel

Resources

• CloudBeaver documentation
• CloudBeaver local access authentication

Author

Developed by Vladimir Ivanov at DBeaver.

License

0BSD