dBizzy

An intuitive VS Code Extension designed to facilitate early-stage database development.
Explore the docs »

Report Bug · Request Feature

Features

Once the extension is installed, navigate to the command palette. Two commands are available: Preview Database and Open Database Browser.

Preview Database

Running the command [dBizzy: Preview Database] prompts .sql file selection. The selected .sql file is then displayed in a new VSCode panel beside current panel. Changes to the .sql file can be reflected in the visualization upon clicking 'Update Diagrams.'

ER diagrams can be exported as SVG files by clicking the "Export Diagram" button. They will be saved in the current project directory folder.

Open Database Browser

Running the command [dBizzy: Open Database Browser] prompts .sql file selection. The selected .sql file's text content is populated in the browser's query field. Upon first executing a valid query, a database is created in memory and the query is executed. Any returned results from the query are displayed under the query field. The database is persistent and is cleared from memory upon closing the browser panel.

Features to improve / implement

• Database preview and database browser's compatilibility with various SQL services.
• Testing suites
• Implementing TypeScript across all files

Release Notes

0.0.7

Implements base product:

• Parses .sql files to display entity relationships.
• Creates database browsers to query databases in memory. Databases persist while browsers are open.

Creators

• Kai Rilliet
• Omar Rana
• Johnny Chen
• Matthew Lee

Credits

• Link to sql.js.
• Link to diagrams.net.
• Link to d3-graphviz.
• Link to Best README Template