As in other posts already mentioned it would be great to have all database-objects of an cchema stored locally on the filesystem.
This is the smoothest way to integrate with other Features/Extensions of VSCode.
Advantages
- Quick-Naviagtion between Object (Ctrl+P just do it)
- Easy integration in version control
- Integration for all sorts of AI-Extensions, for the most tasks there is no need for using in mcp-server.
You can already open e.g. a file containing a package edit it and exceutes it on a target connection (you have to select first). The two drawbacks are:
- you can not be sure you have the current version of the object (e.g. package, trigger, view etc)
- you always have to select a connection before executing it
Feature-Request:
- In an VSCode Workspace you can configure a link? to default target connection, which will be used for all opened SQL files on execution
- If the VSCode Workspace contains a configured default connection, every time an File of an SQL-File representing an Object from the database, SQL-Dev-Extension checks wether a new version of the object exists in the database. In my point of view this would suffice for all replacable objects like packages, triggers, views.
If there is a new version in the database the extension asks wether to update/merge the local file.
That would be really great!!!