Oracle Database Query · emploidai Marketplace
emploidai Marketplace
Add-onsAppletsPlugins
Search tools, teams, and capabilitiesPublish
MarketplacePluginsOracle Database Query
Plugin
Limited listing

Oracle Database Query

by langgenius · v0.0.2

Connect to Oracle database and execute SQL queries using Thin Mode.

3.9k installsUpdated Oct 16, 2025
Publisher information is incomplete

This community listing does not yet include every recommended support, privacy, pricing, and permission disclosure. Review the available package permissions before installing.

Capabilities

Tools

Available inside your emploidai workspace after installation.

Data sources

Available inside your emploidai workspace after installation.

Category

tool

Version

0.0.2langgenius

Requirements

Maximum memory 256MB

Pricing

Not disclosed by publisher

Security & access

Review before installing

CompatibleRequires emploidai 1.3.0+

Permissions

No permissions were declared by the publisher.

Dependencies

No additional dependencies

Resources

Privacy policy
emploidai Marketplace

Discover capabilities. Review access. Install inside your workspace.

DocumentationSecuritySupportPrivacyTerms

Oracle Database Query Plugin

Author: langgenius Version: 0.0.2 Type: tool Repo: https://github.com/WilburOracle/dify-oracle-db-plugin

Description

This plugin allows you to connect to Oracle databases (Oracle Database 23ai) and execute SQL queries. It provides a simple interface to query Oracle databases directly from Dify.

Features

  • Connect to Oracle databases using Thin Mode (no need for Oracle client installation)
  • Execute SQL queries and retrieve results in a structured format
  • Support for common Oracle data types
  • Error handling and detailed error messages
  • Oracle is a converged database, this plugin can execute multi-modal SQL, including relational data queries, property graph data queries, JSON document data queries, vector data queries, etc.

Parameters

When using this plugin, you need to provide the following parameters:

ParameterTypeRequiredDescription
hostStringYesThe hostname or IP address of the Oracle database server
portIntegerYesThe port number of the Oracle database server (default is 1521)
userStringYesThe username for connecting to the Oracle database
passwordStringYesThe password for connecting to the Oracle database
service_nameStringYesThe service name of the Oracle database
queryStringYesThe SQL query to execute against the Oracle database

Example Usage

-- Example query to get data from a table
SELECT * FROM employees WHERE department = 'IT' LIMIT 10;

Return Format

The plugin returns results in JSON format with the following structure:

{
  "status": "success",
  "data": [
    {"column1": "value1", "column2": "value2"}, 
    {"column1": "value3", "column2": "value4"}
  ],
  "columns": ["column1", "column2"],
  "message": "Query executed successfully, returned 2 rows."
}

In case of an error, the response will be:

{
  "status": "error",
  "message": "Error description"
}

Privacy Note

This plugin only executes SQL and returns results to Dify workflows. It does not actively or passively collect user information.