Oracle Database

Connect to Oracle Database to query and manage data.

Key Features

• Execute PL/SQL queries
• Query database schema
• Manage tables and data
• Execute stored procedures and functions
• Real-time data analysis
• Read-only mode support

Basic Information

Authentication Method

Authenticate using username/password.

Input Parameters

• Connection Type (required): Connection type (Service Name or SID)
• Host (required): Oracle Database server host
• Port (required): Oracle Database server port (default: 1521)
• SID or Service Name (optional): Database identifier (default: XE)
• Username (required): Oracle Database username
• Password (required): Oracle Database password
• Use SSL (optional): Whether to use SSL connection
• Read Only (optional): Whether to enable read-only mode

Supported MCP Tools

execute_sql

Execute SQL/PL-SQL queries on Oracle Database and return results.

In read-only mode, only the following SQL commands are allowed:

• SELECT - Query data
• WITH - Use Common Table Expression (CTE)
• EXPLAIN - Query execution plan
• ANALYZE - Query analysis
• SHOW - Metadata queries

Result Limit: Returns a maximum of 500 rows for performance reasons.

For example,

• When you input “Query the user table data” as a prompt,
• The LLM executes the SELECT * FROM users query through MCP.
• Then, it responds in the chat based on the tool call results.

Oracle Database Connection Setup

1. Prepare a user account that can access Oracle Database.
2. Grant necessary database permissions.
3. Configure network access permissions.
4. Select Oracle Database integration in QueryPie AI.
5. Choose the connection type (Service Name or SID) and enter connection information to complete the setup.

Precautions

• Keep your Oracle Database user account password secure.
• It’s recommended to grant only the minimum necessary database permissions.
• It’s recommended to use SSL connections in production environments.
• Large query results are limited to 500 rows, so use appropriate ROWNUM clauses.
• You can prevent data changes by enabling read-only mode.
• Choose the appropriate connection type between Service Name and SID.