Visual SQL

View and edit SQL files in a table format directly in VS Code.

Features

• View INSERT, UPDATE, and SELECT statements as tables
• Edit cells directly by clicking them
• Add or remove rows and columns
• Edit WHERE clauses (add, edit, delete, and validate)
• Select data types for each column (String, Number, Boolean, Null)
• Reload button to refresh the SQL file view
• Auto-saves changes back to your SQL file
• Automatic SQL formatting with improved readability

Usage

1. Open a .sql file
2. Find the "Visual SQL" panel in the sidebar
3. Edit your data in the table

Supported SQL

• INSERT INTO - read/write
• UPDATE - read/write (including WHERE clause)
• DELETE - read/write (including WHERE clause)
• SELECT - read-only

Screenshot

Requirements

• VS Code 1.105.0 or higher

Known Issues

Report bugs on GitHub

Release Notes

0.0.5

• Added automatic SQL formatting for better readability

0.0.4

• Added data type selection for each column (String, Number, Boolean, Null)
• Added reload button to refresh the SQL file view

0.0.3

• Added support for WHERE clause validation
• Added support for WHERE clause addition
• Added support for WHERE clause editing
• Added support for WHERE clause deletion

0.0.2

• Added support for Boolean, Null, and Number data types
• Fixed table editing issue where content gets rewritten to a single line
• Better performance (debounced updates)
• Added input validation

0.0.1

• Initial release

License

MIT