Data Blooms

Data Blooms is a database workspace for Visual Studio Code. It keeps common SQL work close to your editor: manage connections, inspect schemas, write queries, and browse results without switching tools.

Features

• Manage saved MySQL and PostgreSQL connections from the VS Code Activity Bar.
• Store database passwords with VS Code SecretStorage instead of plain text config files.
• Register and sign in with email, change your account password, and sync connections across devices.
• Add and edit connections through a webview form.
• Browse databases, tables, columns, indexes, and table data.
• Run SQL from a Vue 3 + Vite workspace with multiple query tabs.
• Execute recognized SQL statements from the active editor with Cmd+Enter on macOS or Ctrl+Enter on Windows and Linux.
• Execute the current SQL workspace statement with Cmd+Enter on macOS or Ctrl+Enter on Windows and Linux.
• Format SQL with Option+Shift+F on macOS or Alt+Shift+F on Windows and Linux.
• View SQL syntax highlighting, line numbers, foldable subqueries, and autocomplete suggestions for keywords, databases, tables, aliases, and fields.
• Browse result sets in a resizable grid with lazy loading for queries that do not include an explicit LIMIT.
• Open full cell values in a dialog and copy them when table content is truncated.
• Export a database/schema or table as SQL with Structure only, Data only, or Structure and data, saved to a folder or copied to the clipboard.
• Right-click a result row to export it as an INSERT statement, saved as SQL or copied to the clipboard.
• Export all query results as INSERT SQL or Excel (.xlsx) from the result toolbar, automatically fetching unloaded pages while preserving the query's explicit LIMIT.

INSERT export is available for identifiable single-table queries with direct column projections (including aliases). JOINs, aggregates, CTEs and other ambiguous sources can be exported to Excel. Exports use the connection, schema and SQL of the displayed result, even after the editor is changed. Re-run cached results from older versions to enable export.

SQL export handles ordinary scalar values, JSON/JSONB and PostgreSQL arrays. Unsupported complex PostgreSQL values report an error and can still be exported to Excel. Excel cells longer than 32,767 characters report an error instead of being truncated.

Requirements

Data Blooms connects directly from VS Code to your database. Make sure your database host is reachable from the machine running VS Code and that your database user has the permissions needed for schema inspection and query execution.

Currently supported database engines:

• MySQL
• PostgreSQL

Getting Started

1. Open the Data Blooms view from the Activity Bar.
2. Select the add connection action.
3. Enter the connection name, database type, host, port, database, username, password, and SSL setting.
4. Open the SQL workspace from a saved connection.
5. Write SQL and run it from the active query tab.

Security

Connection profiles are cached locally. Database passwords and account session tokens are saved with VS Code SecretStorage. Password values are not shown when editing an existing connection.

When signed in, existing local connections are imported into your account and synchronized automatically. The account server encrypts database passwords with AES-256-GCM. A different machine signing into the same account restores connection profiles and passwords. Each account and server URL has a separate local cache and upload queue.

Data Blooms does not proxy queries through an external service. SQL is executed from the local VS Code extension host against the configured database connection.

Account and Sync

1. Start the Data Blooms account server with MySQL and its encryption key.
2. The packaged extension defaults to https://geek-assistant.com. To use another server, set dataBlooms.serverUrl in VS Code settings; remote servers require HTTPS. Keep the server URL without adding /data-blooms or /api; the extension automatically appends /data-blooms/api, after any custom base path. For local development, F5 uses DATA_BLOOMS_SERVER_URL from .vscode/launch.json, already set to http://127.0.0.1:3001. This environment variable takes precedence over the VS Code setting.
3. Select Account in the Query header or Account & Sync from the command palette or connection view toolbar.
4. To register, enter your email, select Send Code, and submit the emailed six-digit code with your password. Codes expire after 10 minutes; resending is available after 60 seconds. Existing accounts sign in with email and password. Existing local connections are imported once, preserving their IDs, passwords and order.

Connection creation, edits, deletion and sorting synchronize automatically. The extension also checks for changes on startup and every minute while signed in. Sync Now performs a manual check. Offline changes remain available locally and retry when the server becomes reachable, including after an extension restart.

Conflicting edits are retained as a connection named with (local conflict), while the original restores the current server value. A conflicting deletion restores the server connection for you to review before deleting again. Changing your account password signs other devices out; they retain their local cache and need to sign in again to resume synchronization.

Signing out returns to your separate local workspace. Previously imported account connections remain in their account cache and restore on the next sign-in.

Known Limitations

• Redis support is not included in this release.
• Query execution is intended for interactive database work. Review SQL carefully before running statements that modify data.
• Large result sets are paginated in the UI; queries without an explicit LIMIT are automatically capped and loaded in batches.

Release Notes

See CHANGELOG.md for release history.

Other

plugin: https://marketplace.visualstudio.com/manage/publishers/data-blooms