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.
- 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 the current SQL 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.
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:
Getting Started
- Open the Data Blooms view from the Activity Bar.
- Select the add connection action.
- Enter the connection name, database type, host, port, database, username, password, and SSL setting.
- Open the SQL workspace from a saved connection.
- Write SQL and run it from the active query tab.
Security
Connection profiles are stored locally. Password values are saved with VS Code SecretStorage and are not shown when editing an existing connection.
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.
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.
Development
pnpm install
pnpm run build
pnpm test
Use the Run Data Blooms Extension launch configuration in VS Code to start an Extension Development Host.
