MCP Integration
Use Nexo SQL Studio's MCP tools to drive Oracle workflows from AI assistants.
MCP Integration
Nexo SQL Studio exposes an embedded Model Context Protocol (MCP) server. This lets MCP-compatible AI assistants drive approved Oracle database workflows from chat.
What Is MCP?
MCP (Model Context Protocol) is a standard interface that lets AI tools call structured commands exposed by applications. Nexo SQL Studio implements an MCP server that runs inside VS Code and responds to tool invocations from MCP-compatible clients.
Available MCP Tools
| Tool category | Description |
|---|---|
| Query execution | Run approved SQL through the active Oracle connection |
| Object metadata | List objects and inspect object details or DDL |
| Compilation | Compile selected objects and return Oracle errors |
| Deployment helpers | Use configured deployment flows when write access is enabled |
Connecting an AI Client
In VS Code, enable MCP access for the connection you want the assistant to use. Select Nexo SQL Studio as the MCP source in your AI client and ask Oracle questions:
“Show me all tables in the HR schema"
"What does the GET_EMPLOYEE_DETAILS procedure do?"
"Rewrite this query to use a bind variable”
Authorization
The MCP server only responds when a valid Oracle connection is active and that connection has MCP access enabled. Credentials are not sent to the AI client; only the requested query results, metadata, and operation status are returned.
Configuration
Use the connection context menu to configure MCP access:
- Enable MCP read access permits metadata and query operations.
- Enable MCP write access permits write operations when the configured safeguards allow them.
- Disable MCP access removes the connection from MCP use.
Policies are stored in nexo-sql-studio.oracleConnections.mcpPolicies.