SQL Developer for VS Code
Oracle SQL Developer for VS Code empowers Oracle professionals with industry-leading tools directly in the world's most popular IDE. Execute SQL queries and scripts, perform robust PL/SQL development, and manage database schema objects and seamless integration with our command line based SQL prompt and MCP Server.
Learn and share SQL, for free. Get instant access to the Oracle AI Database
Lean how to create, document and manage your 26ai Duality Views using SQL Developer for VS Code
Key Features
AI Enrichment
Natural Language to SQL democratizes data access: users simply ask AI agents in plain English—no deep SQL or data model knowledge required.
Agents generate SQL and can execute it directly via MCP Servers. For Oracle databases with an MCP Server, agents query the data dictionary to discover accurate object names for better queries.
For poorly documented or complex schemas, skip heavy prompt engineering or context overload. Instead, annotate your database schemas directly in the database—making it far easier for agents to find and understand what they need.
SQLcl MCP Server Integration
The extension offers seamless integration with our MCP Server, Oracle SQLcl. Provide access to your Oracle AI Database for your AI agents via your SQL Developer database connections and MCP Server.
Our MCP Server is automatically registered with Github Copilot; alternatively, you can register for any other MCP compatible VS Code Extension.
Optimize Development
Whether you're working directly with PL/SQL programs in your database, or working from your local workspace, SQL Developer makes it easy to develop your stored procedures, functions, packages, triggers, and more.
As you're coding, problems will be immediately detected via our PL/SQL and SQL Parser. Compiler errors are also automatically displayed as you save your work to the database.
Powerful Reporting
Integrated SQL and PL/SQL: Combine executable code blocks with rich Markdown for seamless documentation and interative development.