Integration with Visual Studio

Use Server Explorer with Visual Studio 2026 or Visual Studio 2022 to browse your Oracle schema and launch one of the many integrated Oracle designers and wizards to create and alter schema objects.

Oracle Autonomous AI Database Integration

View and Manage your Oracle Autonomous AI Databases from Server Explorer. You can quickly create Always Free Autonomous AI Database instances from Visual Studio, automatically obtain a connection string or download credentials files and be connected to the database to work on code within minutes. To learn more, view this step-by-step walkthrough.

SQL and PL/SQL Editor

Edit SQL and PL/SQL and leverage many advanced and modern editor features including IntelliSense, hover, brace matching, collapsible regions, keyword coloring, and more. The editor supports a subset of SQL*Plus commands and features a results window that allows you to save results in CSV or JSON format. Use the SQL and PL/SQL formatter to consistently format your code as you choose.

PL/SQL Debugger

The PL/SQL Debugger allows you to use all of your favorite Visual Studio debugging features from within PL/SQL code. Seamlessly step from your .NET code into your PL/SQL stored procedure code and back out again.

Select AI for Natural Language Queries

Use Select AI to execute natural language queries rather than SQL. Manage your Select AI credentials and profiles via dialogs in Visual Studio.

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 Version 2 containing a set of SQL scripts representing a schema.

Multitenant Container Database Administration Features

Developers can easily and quickly create, clone, plug or unplug pluggable databases for use during development and testing.

Entity Framework Designers and Wizards

Use Visual Studio's Entity Designer for Database First and Model First object-relational mapping. ("Code First" is also supported).

Automatic Code Generation

Generate example data access code for tables or views using C#, Python, Java(JDBC), and Javascript (Node.js) The code includes the actual connection string.

Performance Tuning

Use Real-Time SQL Monitoring for automatic monitoring of SQL statements, PL/SQL blocks, or composite database operations that are considered expensive. You can view a list of monitored SQL, view and save SQL Monitor Active Reports, and generate an Active Report for ad hoc SQL. Use Oracle Performance Analyzer to tune your .NET application's use of Oracle AI Database. The database is then monitored under load and recommendations are made, such as modifications to SQL or adding an index on a table.

SQL Script Lifecycle with Source Control Integration

Generate SQL scripts for Oracle schema objects that your .NET application uses, manage them in an Oracle Database Project, check them into source control, edit the scripts in the Oracle SQL Editor, and execute them with a built in SQL*Plus execution engine.

Oracle Advanced Queuing (AQ) Designers

Create, modify and administer your Queues and Queue Tables.

User-Defined Types (UDTs)

View UDTs in Server Explorer. Create UDTs in Oracle with multiple designers. A UDT Custom Class code generation wizard makes using UDTs from .NET code easy and fast.

Manage Users, Roles and Privileges

Create Users and Roles using graphical designers. Assign privileges to the roles and assign roles to users. View the Users and Roles in Server Explorer.

Import Table Wizard

This wizard makes it easy to import tables and their data from Oracle databases, or from external datasources such as Microsoft SQL Server, Microsoft Access and Excel spreadsheets.

Data Editing, Stored Procedure Testing

When testing your .NET application you can use the Oracle Data Window to insert and update Oracle data. There's also a testbed for testing stored procedures.

Documentation

Press F1 or click a help icon while using the extension in Visual Studio to open the documentation.