14 MCP Server Builder

This chapter provides an introduction to the MCP Server Builder integrated with Oracle® Database Navigator.

The MCP Server Builder supported by Database Navigator turns selected SQL queries into SQL-backed MCP tools and packages them as a standalone Model Context Protocol server. Through a database connection, the MCP server builder generates a runnable JAR, mcp-config.yaml, Oracle wallet, source project files, README, and MCP client snippets. The built MCP server can be integrated with internal platforms, agent frameworks, third-party AI clients, or any other MCP-capable runtime, or used by external consumer products. Generated MCP servers can also consumed by the Database Assistant module.

Use this MCP Server Builder to:
  • Expose a small set of database queries as callable MCP tools.
  • Turn existing reporting, lookup, diagnostic, or metadata queries into reusable AI-accessible tools.
  • Give a consumer product or AI client controlled access to query-based database capabilities.
  • Build a repeatable MCP server package from a DBN connection and SQL definitions.
  • Share a generated source project with developers who need to customize or rebuild the server.
  • Use SQL-backed tools from third-party AI clients, internal platforms, product integrations, or another MCP-capable runtime.
The generated server is a standalone Java process. It does not require DBN to be open at runtime, but it uses the connection URL, wallet, and tool definitions produced by DBN.

Note:

Oracle Select AI does not use MCP Server Builder. Select AI runs through Oracle database-native DBMS_CLOUD_AI profiles.

Topics: