Oracle Developer Tools for Visual Studio is a free VS addin that makes it easy to browse and modify Oracle schema objects and data, edit and debug PL/SQL, generate SQL deployment scripts, perform schema comparisons, tune SQL and .NET app performance, and much more.
Questions or feedback about this extension? Please post your questions, comments, or report issues on the Oracle Developer Tools forum.
Oracle Developer Tools for Visual Studio is a free Visual Studio extension that makes it easy to connect to your Oracle AI Database and Oracle Autonomous AI Database, browse and modify schema objects and data, edit and debug SQL and PL/SQL with IntelliSense, perform schema comparisons, tune SQL and .NET app performance, and more. Use Oracle Cloud Explorer to easily create an Always Free Oracle Autonomous AI Database instance in the cloud.
These tools are a required component to enable development with Entity Designer and Table Adapter Configuration Wizard. Use these tools with Oracle Autonomous AI Database and Oracle AI Database servers on any platform (Linux, Unix, Windows).
What's new in 23.26.0:
New SQL and PL/SQL editor and results window: Query Window has been replaced with a new SQL and PL/SQL File Editor. The editor features IntelliSense, hover, brace matching, collapsible regions, keyword coloring, and more. It supports a subset of SQL*Plus commands and features a new results window that allows you to save results in CSV or JSON format and refresh results.
SQL and PL/SQL formatter: Consistently format SQL and PL/SQL as you choose. You can customize this formatter using the SQL and PL/SQL Formatter Settings.
Select AI: Execute natural language queries rather than SQL. Manage your Select AI credentials and profiles via dialogs in Visual Studio.
Support for Vector database column type in designers and data window
Autonomous AI Database Server Explorer and dialog updates to reflect new options and naming.
Context sensitive help: When using a dialog, press F1 or click a help icon to view the online help.
Browsing and managing Oracle Autonomous AI Database (left) and editing and debugging PL/SQL (right)
Key Features
Oracle Autonomous AI Database Integration
View and Manage your Oracle Autonomous AI Databases from Server Explorer. You can quickly create no cost Always Free Autonomous AI Database instances from Visual Studio, automatically download credentials files and be connected to the database to work on code within minutes. To learn more, view this step-by-step walkthrough.
Oracle Cloud Explorer
SQL and PL/SQL Editor
The SQL and PL/SQL Editor features IntelliSense, hover, brace matching, collapsible regions, keyword coloring, and more. It supports a subset of SQL*Plus commands and features a results window that allows you to save results in CSV or JSON format and refresh results. Use the formatter to consistently format SQL and PL/SQL as you choose. You can customize this formatter using the SQL and PL/SQL Formatter Settings.
Type SQL into the editor and IntelliSense suggestions will appear. Enter a schema name, schema object name, or alias followed by a period (".") to show the child objects. Enter a stored procedure or function name and autocomplete the parameter list. Modify the settings to choose whether the suggestions use uppercase, lowercase, or titlecase.
SQL and PL/SQL Editor with IntelliSense SuggestionsParameter info for a procedureAutocompletion of a procedure with placeholder values
PL/SQL Debugger
Use all of your favorite Visual Studio debugging features from within PL/SQL code. You can seamlessly step from your .NET code into your PL/SQL stored procedure code and back out again.
Select AI for Natural Language Queries
Execute natural language queries rather than SQL. Manage your Select AI credentials and profiles via dialogs in Visual Studio.
Browse and modify an Oracle Schema
Use Server Explorer to connect to and browse your Oracle schema and view and modify data. Then launch one of many Oracle designers and wizards to create and alter schema objects.
Table Designer
Real-Time SQL Monitor, SQL Tuning and Application Tuning tools
Use Real-Time SQL Monitor to investigate poorly performing SQL and PL/SQL and generate an Active Report that you can share with your DBA. Use Oracle Performance Analyzer to tune your .NET application's use of Oracle AI Database via a single click of a button. The database is then monitored under load and recommendations are made.
Real-Time SQL Monitor Window. Click a SQL ID to view an Active ReportView an Active Report inside Visual Studio
Oracle Database Project (Version 2)
Import a set of SQL scripts representing your schema in Oracle Database Project and check them into source control.
Schema Compare Tools
View differences between two schemas and generate a diff script that can modify a target schema to match the source schema. Compare live database instances and/or an Oracle Database Project (V2) containing a set of SQL scripts representing a schema.
Schema Compare Results
Multitenant Container Database Features
Developers using Oracle AI Database can easily and quickly create, clone, plug or unplug pluggable databases for use during development and testing.
Entity Designer and Table Adapter Configuration Wizard
These tools provide integration with built in Visual Studio data features and are required if you wish to use these designers and wizards.
Older Versions
Click the links below to download .VSIX files for older versions:
