Mcporacle FAQs

Question 1

What Oracle database permissions are required for Mcporacle?

Accepted Answer

To function correctly, the Oracle user account configured for Mcporacle must have read access to the `DBA_TABLES`, `DBA_TAB_COMMENTS`, `DBA_TAB_COLUMNS`, and `DBA_COL_COMMENTS` views within the Oracle database.

Question 2

What is Mcporacle?

Accepted Answer

Mcporacle is an MCP server designed for Roo Code environments. It securely connects to Oracle databases to retrieve restricted metadata, specifically table and column information, through a safe and validated tool, enabling controlled data access within your development workflow.

Question 3

How do I integrate Mcporacle with Roo Code?

Accepted Answer

Mcporacle integrates seamlessly with Roo Code as a local MCP server using `stdio` transport. You configure it within your project's `.roo/mcp.json` file, specifying the server command, arguments, and working directory. Oracle credentials are managed via environment variables.

Question 4

How does Mcporacle ensure data security?

Accepted Answer

Mcporacle prioritizes security by disallowing arbitrary SQL queries and enforcing strict input validation. It retrieves metadata only from specified `DBA_*` views using fixed, server-side logic, ensuring a controlled and secure interaction with your Oracle database.

Question 5

What kind of Oracle metadata can Mcporacle retrieve?

Accepted Answer

Mcporacle's `get_table_info` tool can retrieve comprehensive details about Oracle tables and their columns, including names, comments, data types, nullability, lengths, precisions, and scales, from a specified schema and table.

Mcporacle

Mcporacle

主要功能

使用案例

主要功能

使用案例