zhengwanbo/oracle-mcp-server

3.3

If you are the rightful owner of oracle-mcp-server 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.

A powerful Model Context Protocol (MCP) server that provides contextual database schema information for large Oracle databases, enabling AI assistants to understand and work with databases containing thousands of tables.

Tools

Functions exposed to the LLM to take actions

get_table_schema

Get detailed schema information for a specific table including columns, data types, nullability, and relationships.

get_tables_schema

Get schema information for multiple tables at once.

search_tables_schema

Search for tables by name pattern and retrieve their schemas.

rebuild_schema_cache

Force a rebuild of the schema cache.

get_database_vendor_info

Get information about the connected Oracle database version and schema.

search_columns

Search for tables containing columns that match a specific term.

get_pl_sql_objects

Get information about PL/SQL objects like procedures, functions, packages, triggers, etc.

get_object_source

Retrieve the source code for a PL/SQL object.

get_table_constraints

Get all constraints for a table.

get_table_indexes

Get all indexes defined on a table.

get_dependent_objects

Find all objects that depend on a specified database object.

get_user_defined_types

Get information about user-defined types in the database.

get_related_tables

Get all tables that are related to a specified table through foreign keys.

read_query

Execute SELECT queries.

exec_ddl_sql

Execute CREATE/ALTER/DROP operations.

exec_dml_sql

Execute INSERT/UPDATE/DELETE operations.

exec_pro_sql

Execute PL/SQL code blocks.

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

zhengwanbo

Claim Ownership

Verify you have write access to the repository

Repository

https://github.com/zhengwanbo/oracle-mcp-server

GitHub Stars

License

MIT License

Last publish date

2025-06-20

Last update date

2025-08-10

Server configs

in vscode

"mcp": {
    "inputs": [
     {
       "id": "db-password",
       "type": "promptString",
       "description": "Oracle DB Password",
       "password": true,
     }
   ],
    "servers": {
        "oracle": {
            "command": "docker",
            "args": [
                "run",
                "-i",
                "--rm",
                "-e",
                "ORACLE_CONNECTION_STRING",
                "-e",
                "TARGET_SCHEMA",
                "-e",
                "CACHE_DIR",
                "-e",
                "THICK_MODE",
                "dmeppiel/oracle-mcp-server"
            ],
            "env": {
               "ORACLE_CONNECTION_STRING":"<db-username>/${input:db-password}@<host>:1521/<service-name>",
               "TARGET_SCHEMA":"",
               "CACHE_DIR":".cache",
               "THICK_MODE":"",  // Optional: set to "1" to enable thick mode
               "ORACLE_CLIENT_LIB_DIR":"" // Optional: in case you use thick mode and you want to set a non-default directory for client libraries
            }
        }
    }
}