kutsushitaneko/mcp-server-for-oracle-database
If you are the rightful owner of mcp-server-for-oracle-database and would like to certify it and/or have it hosted online, please leave a comment on the right or send an email to henry@mcphub.com.
MCP Server for Oracle Database is an experimental implementation designed to facilitate AI applications in executing SQL queries on Oracle Database and retrieving results.
The MCP Server for Oracle Database is an experimental server implementation that allows AI applications to execute SQL queries on Oracle Database and retrieve results. This server is designed to run locally and aims to provide a seamless database experience when invoked from MCP clients like Cursor and Cline. It supports executing SQL queries, retrieving table structures, and includes basic security measures such as query length restrictions and dangerous keyword checks. The server is intended for use in a local environment where external access is restricted. It requires Python 3.11 or higher, access to Oracle Database, and specific environment variable settings. The server has been tested only on Windows 11, and users on Linux or Mac may need to adjust directory paths accordingly.
Features
- Execute SQL queries on Oracle Database
- Retrieve table structures
- Basic security measures including query length restrictions and dangerous keyword checks
- Result formatting for LLM
- Local environment usage only
Usages
usage with Claude Desktop
{
"mcpServers": {
"ORACLE": {
"command": "仮想環境の Python 実行ファイルへの絶対パス（...\mcp-server-for-autonomous-database\.venv\Scripts\python.exe）",
"args": [
"MCPサーバーの絶対パス（....\mcp-server-for-oracle-database\oracledb_mcp_server.py）"
]
}
}
}Tools
execute_oracle
Executes SQL queries (SELECT only) and returns formatted results.
list_tables
Displays a list of tables in the database.
describe_table
Displays the structure of a table, mimicking sqlplus describe.
oracle_query_assistant
Provides a prompt to guide execute_oracle for query execution.