Database Query (Pre-authorization)

Name: Database Query (Pre-authorization)
Author: junjiem

by junjiem · v0.0.11

Database Query Utils (Pre-authorization).

19k installsUpdated Dec 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.

Dify 1.0 Plugin Database Query Tools (Pre-authorization)

Author: Junjie.M
Type: tool
Github Repo: https://github.com/junjiem/dify-plugin-tools-dbquery
Github Issues: issues

Demonstration

Database Query Tools (Pre-authorization)

数据库查询工具（预授权）

Currently supported database types: mysql, oracle, oracle11g, postgresql, or mssql.

目前支持的数据库类型：mysql、oracle、oracle11g、postgresql、mssql。

Examples 示例

FAQ

1. How to Handle Errors When Installing Plugins? 安装插件时遇到异常应如何处理？

Issue: If you encounter the error message: plugin verification has been enabled, and the plugin you want to install has a bad signature, how to handle the issue?

Solution: Add the following line to the end of your .env configuration file: FORCE_VERIFYING_SIGNATURE=false Once this field is added, the Dify platform will allow the installation of all plugins that are not listed (and thus not verified) in the Dify Marketplace.

问题描述：安装插件时遇到异常信息：plugin verification has been enabled, and the plugin you want to install has a bad signature，应该如何处理？

解决办法：在 .env 配置文件的末尾添加 FORCE_VERIFYING_SIGNATURE=false 字段即可解决该问题。添加该字段后，Dify 平台将允许安装所有未在 Dify Marketplace 上架（审核）的插件，可能存在安全隐患。

2. How to connect to oracle 11g 如何连接Oracle 11g

2.1、下载 oracle11g 的 client，这里下的是 11.2.0.4.0 版本

https://www.oracle.com/database/technologies/instant-client/downloads.html

比如：instantclient-basic-linux.x64-11.2.0.4.0.zip

2.2、上传 oracle 的 client 到宿主机的 dify 的挂载目录

将 instantclient-basic-linux.x64-11.2.0.4.0.zip 解压后的 instantclient_11_2 目录放到 docker/volumes 下面

注：需要将 instantclient_11_2 中libclntsh.so.11.1 改成 libclntsh.so、 libocci.so.11.1 改成 libocci.so

2.3、在 docker/docker-compose.yml 中进行配置

# 在 plugin_daemon 下，添加一个变量
environment:
  ......
  LD_LIBRARY_PATH: "/root/instantclient_11_2:$LD_LIBRARY_PATH"

Red Hat 系（如 CentOS、RHEL）64 位：

# 在 plugin_daemon 下，添加三个挂载
volumes:
  ......
  - ./volumes/instantclient_11_2:/root/instantclient_11_2
  - /usr/lib64/libaio.so.1.0.1:/usr/lib/x86_64-linux-gnu/libaio.so.1.0.1
  - /usr/lib64/libaio.so.1:/usr/lib/x86_64-linux-gnu/libaio.so.1

Debian 系（如 Ubuntu）64 位：

# 在 plugin_daemon 下，添加三个挂载
volumes:
  ......
  - ./volumes/instantclient_11_2:/root/instantclient_11_2
  - /usr/lib/x86_64-linux-gnu/libaio.so.1.0.1:/usr/lib/x86_64-linux-gnu/libaio.so.1.0.1
  - /usr/lib/x86_64-linux-gnu/libaio.so.1:/usr/lib/x86_64-linux-gnu/libaio.so.1

2.4、重启 plugin_daemon

docker stop docker-plugin_daemon-1
docker compose up -d plugin_daemon

3. How to install the offline version 如何安装离线版本

Scripting tool for downloading Dify plugin package from Dify Marketplace and Github and repackaging [true] offline package (contains dependencies, no need to be connected to the Internet).

从Dify市场和Github下载Dify插件包并重新打【真】离线包（包含依赖，不需要再联网）的脚本工具。

Github Repo: https://github.com/junjiem/dify-plugin-repackaging

Capabilities

Tools

Available inside your emploidai workspace after installation.

Data sources

Available inside your emploidai workspace after installation.