New Project: Cursor DB MCP
Supports connecting to any database via JDBC.
👉https://github.com/kjstart/cursor_db_mcp
Power your agent
การติดตั้งจากผู้เผยแพร่ ไม่ใช่เอนด์พอยต์ของ PlugMCP
URL แบบรีโมตหรือคำสั่งบนเครื่องของคุณ? การติดตั้งสองแบบต่างกันอย่างไร
รันบน PlugMCP
A new server you create. It is not this listing's official endpoint. Use the publisher install when you want their URL and their credentials.
เปิดจากผู้เผยแพร่
Supports connecting to any database via JDBC.
👉https://github.com/kjstart/cursor_db_mcp
stdin mcp service for Cursor connect Oracle database
A Model Context Protocol (MCP) server for Oracle Database, enabling AI assistants like Cursor to execute SQL statements directly against Oracle databases. Oracle trademark, database, and Instant Client are properties of the Oracle company, they are not part of this solution.
Alvin Liu — https://alvinliu.com · Project: https://github.com/kjstart/cursor_oracle_mcp_server
execute_sql_file; trailing SQL*Plus / is stripped automaticallyquery_to_csv_file (result as CSV, RFC 4180, UTF-8) and query_to_text_file (plain text, tab-separated, CLOB in full; e.g. for procedure source)Keywords area shows the actual expanded identifiers that triggered review (for example created_at, not just create)Allow Header saves the SQL first line to whitelist.json and skips future review for the same connection + header lineAllow Keyword saves a keyword to whitelist.json without approving the current review; future matches remove only that specific expanded keyword trigger, while other unmatched dangerous triggers still open reviewdanger_keywords (case-insensitive)whole_text (substring in full SQL) or tokens (exact token match; e.g. created_at does not match create)list_connections to see names and status (failed connections are retried on each list; only list_connections re-validates—other tools fast-fail on an unavailable connection until you call it again)AUDIT_TIME, AUDIT_CONNECTION, AUDIT_KEYWORDS, AUDIT_APPROVED, AUDIT_ACTION, AUDIT_SQL) plus whitelist context such as HEADER_LINE and EXPANDED_KEYWORDS; full SQL, record separator ######AUDIT_END######; 10MB rotation, reuse last non-full file on startup, filenames include creation date (e.g. audit_2006-01-02_150405.log)config.yaml are automatically encrypted on first startup — no manual steps requiredAllow Keyword, Allow Header, Execute, and CancelOracle Instant Client
oci.dll, oraociei19.dll (Windows) or equivalent .dylib (macOS)Environment Setup
# Windows: Add Instant Client to PATH
set PATH=C:\path\to\instantclient;%PATH%
# macOS: Set library path
export DYLD_LIBRARY_PATH=/path/to/instantclient:$DYLD_LIBRARY_PATH
Pre-built binaries are published on GitHub Releases. No build required.
Download the archive for your platform:
oracle-mcp-server-windows-amd64-<version>.ziporacle-mcp-server-darwin-arm64-<version>.tar.gzoracle-mcp-server-darwin-amd64-<version>.tar.gzExtract the archive. You will get:
oracle-mcp-server-windows-amd64.exe or oracle-mcp-server-darwin-arm64)user_guide.md — step-by-step setupconfig.yaml.example — copy to config.yaml and editInstall Oracle Instant Client (see Requirements above) and add it to PATH (Windows) or set ORACLE_HOME and DYLD_LIBRARY_PATH (macOS).
Configure config.yaml with your database connection(s), then add the server to Cursor MCP (see Configuration and Usage with Cursor below).
For a full walkthrough, see user_guide.md.
Copy config.yaml.example to config.yaml and configure at least one connection under oracle.connections:
oracle:
connections:
database1: "user/pass@//host:1521/ORCL"
# database2: "user/pass@//host2:1521/ORCL"
security:
# "whole_text" = substring in full SQL; "tokens" = exact token match (e.g. created_at ≠ create)
danger_keyword_match: "whole_text"
danger_keywords:
- truncate
- drop
- delete
- create
- update
- execute immediate
# ... (see config.yaml.example)
require_confirm_for_ddl: true # DDL always requires confirmation
logging:
audit_log: true
verbose_logging: true # One short stderr line per execute_sql / execute_sql_file
log_file: "audit.log" # Base name; actual files: audit_YYYY-MM-DD_HHMMSS.log, 10MB rotation
With one connection, all SQL runs against that database (no need to pass connection). With multiple connections, use the connection argument in execute_sql / execute_sql_file and list_connections to see names and availability.
Multiple security profiles: define named profiles under security_profiles (same fields as security; omitted fields use built-in defaults) and bind connections to them with oracle.connection_security. Connections not listed use the top-level security section (profile name default, which can also be referenced explicitly). Unknown profile or connection names are rejected at startup.
oracle:
connections:
prod: "user/pass@//host:1521/PROD"
dev: "user/pass@//host:1521/DEV"
connection_security:
prod: strict
security_profiles:
strict:
danger_keyword_match: "tokens"
danger_keywords: [drop, delete, update, insert]
require_confirm_for_ddl: true
Connection security: On first startup, any plain-text connection strings in
config.yamlare automatically replaced with encrypted values. The file is updated in place — comments and formatting are preserved.
ADB uses TCPS (SSL) and requires the Wallet. Use the TNS name from the wallet’s tnsnames.ora (e.g. mcpdemo_high):
D:\oracle\wallet_mcpdemo). The folder must contain tnsnames.ora, sqlnet.ora, cwallet.sso, ewallet.pem, etc.oracle:
connections:
mcpdemo: "mcpdemo/YourPassword@mcpdemo_high"
TNS_ADMIN to the Wallet directory so the process can find tnsnames.ora and SSL certs. On Windows, also include Instant Client in PATH:
{
"mcpServers": {
"oracle": {
"command": "D:\\work\\code\\cursor_oracle_mcp_server\\oracle-mcp.exe",
"args": [],
"env": {
"TNS_ADMIN": "D:\\oracle\\wallet_mcpdemo",
"PATH": "C:\\path\\to\\instantclient;%PATH%"
}
}
}
}
Replace D:\oracle\wallet_mcpdemo with your unzipped wallet path, and ensure Instant Client is on PATH. Without TNS_ADMIN, you may see ORA-12541 (no listener) or SSL errors because the client cannot resolve the TNS name or use the wallet.Add to your Cursor MCP settings (~/.cursor/mcp.json or workspace .cursor/mcp.json):
Windows:
{
"mcpServers": {
"oracle": {
"command": "C:\\path\\to\\oracle-mcp.exe",
"args": []
}
}
}
Use the env block so the MCP process sees ORACLE_HOME and DYLD_LIBRARY_PATH:
{
"mcpServers": {
"oracle": {
"command": "/path/to/oracle-mcp",
"args": [],
"env": {
"ORACLE_HOME": "/opt/oracle/instantclient_19_20",
"DYLD_LIBRARY_PATH": "/opt/oracle/instantclient_19_20"
}
}
}
}
Replace /path/to/oracle-mcp and /opt/oracle/instantclient_19_20 with your actual paths. You can also reference existing shell env with "ORACLE_HOME": "${env:ORACLE_HOME}" if Cursor was started from a terminal that already has it set.
// One connection: no need to pass connection
execute_sql({ "sql": "SELECT table_name FROM user_tables" })
// Multiple connections
execute_sql({ "sql": "SELECT * FROM my_table", "connection": "database1" })
execute_sql({ "sql": "CREATE TABLE test (id NUMBER)", "connection": "database2" })
// Run a SQL file (e.g. procedure script; trailing / stripped)
execute_sql_file({ "file_path": "d:\\scripts\\myscript.sql", "connection": "ps" })
// See connection names and status
list_connections()
// Write query result to CSV or text file (file_path must be absolute; same review rules as execute_sql when needed)
query_to_csv_file({ "sql": "SELECT * FROM my_table", "file_path": "d:\\out\\data.csv", "connection": "database1" })
query_to_text_file({ "sql": "SELECT text FROM user_source WHERE name='MY_PROC'", "file_path": "d:\\out\\my_proc.sql" })
When SQL matches danger_keywords or is DDL (if require_confirm_for_ddl is true), a confirmation window appears:
whitelist.json; future SQL on the same connection with the same first line skips reviewwhitelist.json but does not approve the current review; users can add multiple keywords before choosing Execute or Cancelwhitelist.json is stored in the executable directory / program directoryExecution proceeds only after the user confirms. Rejection is logged and returned as USER_REJECTED.
-- or /* */) and anonymous blocks (BEGIN...END; / DECLARE...END;) are treated as one block and not split./ (on its own line) is removed before execution.AUDIT_TIME=..., AUDIT_CONNECTION=..., AUDIT_KEYWORDS=..., AUDIT_APPROVED=..., AUDIT_ACTION=..., optional HEADER_LINE=..., optional EXPANDED_KEYWORDS=..., then AUDIT_SQL= followed by the full SQL, then a line ######AUDIT_END###### as record separator.audit_2006-01-02_150405.log.execute_sqlInput: sql (required), connection (optional). Do not specify schema-qualified object names such as hr.employees; the server rejects them.
Output (query): columns, rows, statement_type, execution_time_ms, success.
Output (DML/DDL): rows_affected, statement_type, execution_time_ms, success, optional warning.
Error (user rejected): code -32000, message "Execution cancelled by user", data.code "USER_REJECTED", data.matched_keywords.
execute_sql_fileInput: file_path (required), connection (optional). Same analysis and review rules as execute_sql; executes the file contents (trailing / stripped).
list_connectionsInput: none. Output: connections (name + availability), message. Only this tool re-validates failed connections; other tools return an error if the chosen connection is currently unavailable until you call list_connections again.
query_to_csv_fileInput: sql (required), file_path (required, absolute path), connection (optional). Output: success and path. Same confirmation rules as execute_sql when SQL matches danger_keywords or is DDL (if require_confirm_for_ddl). Writes CSV with header, UTF-8, RFC 4180; CLOB columns read in full.
query_to_text_fileInput: sql (required), file_path (required, absolute path), connection (optional). Output: success and path. Same confirmation rules as execute_sql when SQL matches danger_keywords or is DDL (if require_confirm_for_ddl). Writes plain text, tab-separated columns, no header; CLOB in full (e.g. for procedure source).
Error: ORA-12541: TNS:no listener
→ Check that Oracle Instant Client is in PATH and listener is running
Error: DPI-1047: Cannot locate a 64-bit Oracle Client library
→ Install Oracle Instant Client and add to PATH
Error: ORA-01031: insufficient privileges
→ The configured database user lacks required permissions
If you prefer to build the binary yourself (e.g. for a different Go version or platform):
bin to PATH.
bin comes before Cygwin in PATH, or you may see cannot parse gcc output ... as ELF, Mach-O, PE, XCOFF.choco install mingw, or MSYS2 then pacman -S mingw-w64-ucrt-x86_64-gcc and use mingw64\bin.where gcc and gcc -v; you should see "mingw" or "MinGW" and 64-bit (x86_64).xcode-select --install for command line tools.Important: Build with CGO enabled and GCC available, or you will see errors like undefined: VersionInfo.
# Clone the repository
git clone https://github.com/kjstart/cursor_oracle_mcp_server
cd cursor_oracle_mcp_server
# Download dependencies
go mod tidy
# Windows (PowerShell): enable CGO and ensure gcc is in PATH
$env:CGO_ENABLED="1"
go build -o oracle-mcp.exe .
# Windows (CMD)
set CGO_ENABLED=1
go build -o oracle-mcp.exe .
# Windows (MSYS UCRT64)
export PATH=/c/oracle/instantclient_21_12:$PATH
export ORACLE_HOME=/c/oracle/instantclient_21_12
pacman -S mingw-w64-ucrt-x86_64-go
export GOROOT=/ucrt64/lib/go
export PATH=$GOROOT/bin:$PATH
export CGO_ENABLED=1
export CC=x86_64-w64-mingw32-gcc
go install github.com/godror/godror@latest
CGO_ENABLED=1 GOOS=windows GOARCH=amd64 go build -o oracle-mcp.exe .
# macOS (Intel): native build only
CGO_ENABLED=1 GOOS=darwin GOARCH=amd64 go build -o oracle-mcp .
# macOS (Apple Silicon)
CGO_ENABLED=1 GOOS=darwin GOARCH=arm64 go build -o oracle-mcp .
After changing gcc or PATH, clear the build cache and rebuild:
go clean -cache
go build -o oracle-mcp.exe .
MIT License - see LICENSE file
基于 Model Context Protocol (MCP) 的 Oracle 数据库服务端,让 Cursor 等 AI 助手直接对 Oracle 数据库执行 SQL。Oracle 商标, 数据库和Instant Client属于Oracle公司, 不是本方案的一部分.
作者:Alvin Liu — https://alvinliu.com · 项目: https://github.com/kjstart/cursor_oracle_mcp_server
B站视频介绍: Cursor连接Oracle自动编写存储过程
execute_sql_file 执行整个 SQL 文件;自动去除末尾 SQL*Plus 的 /query_to_csv_file(结果写为 CSV,RFC 4180,UTF-8)与 query_to_text_file(纯文本、制表符分隔、CLOB 完整输出,如存过程源码)Keywords 区域显示的是真正命中的 expanded keyword(例如显示 created_at,而不是只显示 create)Allow Header 会把 SQL 第一行写入 whitelist.json,下次同一连接且第一行相同的 SQL 直接跳过 reviewAllow Keyword 只把关键字写入 whitelist.json,不会自动批准当前 review;后续只会消掉该 expanded keyword 对应的触发项,其他未放行触发项仍会继续弹出 reviewdanger_keywords 中某项完全相同(忽略大小写)则禁止添加whole_text(整段 SQL 子串)或 tokens(精确词匹配,如 created_at 不匹配 create)list_connections 查看名称与状态(失败连接每次列出时会重试;仅 list_connections 会重新校验—其他工具在连接不可用时直接报错,需再次调用 list_connections 后重试)AUDIT_TIME、AUDIT_CONNECTION、AUDIT_KEYWORDS、AUDIT_APPROVED、AUDIT_ACTION、AUDIT_SQL),并可附带 HEADER_LINE、EXPANDED_KEYWORDS;完整 SQL、记录分隔符 ######AUDIT_END######;单文件 10MB 轮转,启动时复用最近未满的日志,文件名含创建日期(如 audit_2006-01-02_150405.log)config.yaml 中的数据库连接串(含密码)在首次启动时自动加密,无需任何手动操作Allow Keyword、Allow Header、Execute、CancelOracle Instant Client
oci.dll、oraociei19.dll(Windows)或对应 .dylib(macOS)环境配置
# Windows:将 Instant Client 加入 PATH
set PATH=C:\path\to\instantclient;%PATH%
# macOS:设置库路径
export DYLD_LIBRARY_PATH=/path/to/instantclient:$DYLD_LIBRARY_PATH
预编译包发布在 GitHub Releases,无需自行编译。
下载对应平台的压缩包:
oracle-mcp-server-windows-amd64-<版本>.ziporacle-mcp-server-darwin-arm64-<版本>.tar.gzoracle-mcp-server-darwin-amd64-<版本>.tar.gz解压后得到:
oracle-mcp-server-windows-amd64.exe 或 oracle-mcp-server-darwin-arm64)user_guide.md — 分步设置说明config.yaml.example — 复制为 config.yaml 后编辑安装 Oracle Instant Client(见上方 环境要求),并加入 PATH(Windows)或设置 ORACLE_HOME、DYLD_LIBRARY_PATH(macOS)。
配置 config.yaml 中的数据库连接,再将本服务加入 Cursor MCP(见下方 配置 与 在 Cursor 中使用)。
完整步骤可参考 user_guide.md。
将 config.yaml.example 复制为 config.yaml,在 oracle.connections 下至少配置一个连接:
oracle:
connections:
database1: "user/pass@//host:1521/ORCL"
# database2: "user/pass@//host2:1521/ORCL"
security:
# danger_keywords 匹配方式:"whole_text" 或 "tokens"
danger_keyword_match: "whole_text"
danger_keywords:
- truncate
- drop
- delete
- create
- update
- execute immediate
# ... (见 config.yaml.example)
require_confirm_for_ddl: true # DDL 始终需确认
logging:
audit_log: true
verbose_logging: true
log_file: "audit.log"
单连接时所有 SQL 都发往该库(无需传 connection)。多连接时在 execute_sql / execute_sql_file 中通过 connection 指定,并用 list_connections 查看名称与可用性。
连接安全: 首次启动时,
config.yaml中的明文连接串会被自动替换为加密值,文件原地更新,注释与格式完整保留。
ADB 使用 TCPS (SSL),需要 Wallet。连接串使用钱包中 tnsnames.ora 的 TNS 别名(如 mcpdemo_high):
D:\oracle\wallet_mcpdemo),该目录需包含 tnsnames.ora、sqlnet.ora、cwallet.sso、ewallet.pem 等。oracle:
connections:
mcpdemo: "mcpdemo/YourPassword@mcpdemo_high"
TNS_ADMIN 为 Wallet 目录,以便进程找到 tnsnames.ora 和 SSL 证书。Windows 下还需在 PATH 中包含 Instant Client:
{
"mcpServers": {
"oracle": {
"command": "D:\\path\\to\\oracle-mcp-server-windows-amd64.exe",
"args": [],
"env": {
"TNS_ADMIN": "D:\\oracle\\wallet_mcpdemo",
"PATH": "C:\\path\\to\\instantclient;%PATH%"
}
}
}
}
将 D:\oracle\wallet_mcpdemo 换成你的 Wallet 解压路径,并确保 Instant Client 在 PATH 中。未设置 TNS_ADMIN 可能出现 ORA-12541(无监听)或 SSL 相关错误。在 Cursor 的 MCP 设置(~/.cursor/mcp.json 或工作区 .cursor/mcp.json)中添加:
Windows(Oracle 客户端已在系统 PATH 中):
{
"mcpServers": {
"oracle": {
"command": "C:\\path\\to\\oracle-mcp-server-windows-amd64.exe",
"args": []
}
}
}
macOS
通过 env 让 MCP 进程能读到 ORACLE_HOME 和 DYLD_LIBRARY_PATH:
{
"mcpServers": {
"oracle": {
"command": "/path/to/oracle-mcp-server-darwin-arm64",
"args": [],
"env": {
"ORACLE_HOME": "/opt/oracle/instantclient_19_20",
"DYLD_LIBRARY_PATH": "/opt/oracle/instantclient_19_20"
}
}
}
}
将 /path/to/oracle-mcp-server-darwin-arm64 和 /opt/oracle/instantclient_19_20 换成你的实际路径。若从已设置环境的终端启动 Cursor,也可用 "ORACLE_HOME": "${env:ORACLE_HOME}" 引用现有环境变量。
// 单连接:无需传 connection
execute_sql({ "sql": "SELECT table_name FROM user_tables" })
// 多连接
execute_sql({ "sql": "SELECT * FROM my_table", "connection": "database1" })
execute_sql({ "sql": "CREATE TABLE test (id NUMBER)", "connection": "database2" })
// 执行 SQL 文件(末尾 / 会被去除)
execute_sql_file({ "file_path": "d:\\scripts\\myscript.sql", "connection": "ps" })
// 查看连接名称与状态
list_connections()
// 将查询结果写入 CSV 或文本文件(file_path 须为绝对路径;需要时与 execute_sql 相同审查规则)
query_to_csv_file({ "sql": "SELECT * FROM my_table", "file_path": "d:\\out\\data.csv", "connection": "database1" })
query_to_text_file({ "sql": "SELECT text FROM user_source WHERE name='MY_PROC'", "file_path": "d:\\out\\my_proc.sql" })
当 SQL 命中 danger_keywords 或为 DDL(且 require_confirm_for_ddl 为 true)时,会弹出确认窗口:
Keywords 显示真正命中的 expanded keyword,而不是原始 danger keywordwhitelist.json;同一连接下第一行再次匹配时直接跳过 reviewwhitelist.json,不会批准当前 review;可以在同一个窗口里连续添加多个 keywordwhitelist.json 位于程序目录 / 可执行文件目录用户确认后才会执行。拒绝会记录并返回 USER_REJECTED。
-- 或 /* */)及匿名块(BEGIN...END; / DECLARE...END;)视为一整块,不拆分。/ 会在执行前移除。AUDIT_TIME=...、AUDIT_CONNECTION=...、AUDIT_KEYWORDS=...、AUDIT_APPROVED=...、AUDIT_ACTION=...,以及可选的 HEADER_LINE=...、EXPANDED_KEYWORDS=...,然后是 AUDIT_SQL= 后跟完整 SQL,再以 ######AUDIT_END###### 作为记录分隔。audit_2006-01-02_150405.log。execute_sql输入:sql(必填),connection(可选)。
输出(查询):columns、rows、statement_type、execution_time_ms、success。
输出(DML/DDL):rows_affected、statement_type、execution_time_ms、success,可选 warning。
错误(用户拒绝):code -32000,message "Execution cancelled by user",data.code "USER_REJECTED",data.matched_keywords。
execute_sql_file输入:file_path(必填),connection(可选)。与 execute_sql 相同的分析与确认规则;执行文件内容(末尾 / 去除)。
list_connections输入:无。输出:connections(名称 + 可用性),message。仅此工具会重新校验失败连接;其他工具在所选连接不可用时直接报错,需再次调用 list_connections 后重试。
query_to_csv_file输入:sql(必填)、file_path(必填,绝对路径)、connection(可选)。输出:成功及路径。与 execute_sql 相同:命中 danger_keywords 或为 DDL(若 require_confirm_for_ddl)时弹出确认。写入带表头的 CSV,UTF-8,RFC 4180;CLOB 列完整读取。
query_to_text_file输入:sql(必填)、file_path(必填,绝对路径)、connection(可选)。输出:成功及路径。与 execute_sql 相同:命中 danger_keywords 或为 DDL(若 require_confirm_for_ddl)时弹出确认。写入纯文本,列以制表符分隔、无表头;CLOB 完整输出(如存过程源码)。
Error: ORA-12541: TNS:no listener
→ 确认 Oracle Instant Client 在 PATH 中且监听正常
Error: DPI-1047: Cannot locate a 64-bit Oracle Client library
→ 安装 Oracle Instant Client 并加入 PATH
Error: ORA-01031: insufficient privileges
→ 当前配置的数据库用户权限不足
若希望自行编译(例如使用不同 Go 版本或平台):
bin 加入 PATH。
bin 在 Cygwin 之前,否则可能出现 cannot parse gcc output ... as ELF, Mach-O, PE, XCOFF。choco install mingw,或 MSYS2 后 pacman -S mingw-w64-ucrt-x86_64-gcc,使用 mingw64\bin。where gcc 和 gcc -v 检查,应看到 "mingw" 或 "MinGW" 及 64 位 (x86_64)。xcode-select --install 安装命令行工具。注意:需在启用 CGO 且已安装 GCC 的环境下构建,否则会出现 undefined: VersionInfo 等错误。
# 克隆仓库
git clone https://github.com/kjstart/cursor_oracle_mcp_server
cd cursor_oracle_mcp_server
# 下载依赖
go mod tidy
# Windows (PowerShell):启用 CGO,确保 gcc 在 PATH 中
$env:CGO_ENABLED="1"
go build -o oracle-mcp.exe .
# Windows (CMD)
set CGO_ENABLED=1
go build -o oracle-mcp.exe .
# macOS (Intel)
CGO_ENABLED=1 GOOS=darwin GOARCH=amd64 go build -o oracle-mcp .
# macOS (Apple Silicon)
CGO_ENABLED=1 GOOS=darwin GOARCH=arm64 go build -o oracle-mcp .
修改 gcc 或 PATH 后,清理缓存再构建:
go clean -cache
go build -o oracle-mcp.exe .
MIT License - 见 LICENSE 文件
stdin mcp service for Cursor connect Oracle database
เครื่องมือ
ยังไม่มีรายการเครื่องมือ เซิร์ฟเวอร์แบบรีโมตจะได้รายการหลังการตรวจสอบสถานะครั้งแรก
FAQ
คัดลอกคอนฟิก stdio สำหรับ Cursor, Claude Desktop, Claude Code หรือ VS Code ได้ในหน้านี้ คอนฟิกนี้ใช้การติดตั้งของผู้เผยแพร่ ไม่ใช่พร็อกซีของ PlugMCP
ระเบียนนี้ไม่ได้ระบุตัวแปรสภาพแวดล้อมที่จำเป็น
Oracle ทำงานแบบโลคัลผ่าน stdio
ตรวจสอบล่าสุดเมื่อ 2026-10-28 stdin mcp service for Cursor connect Oracle database