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
- Open a .sql file
- Find the "Visual SQL" panel in the sidebar
- 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
License
MIT
| |
