danielmeppiel/oracle-mcp-server

3.5

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

get_tables_schema

Get schema information of multiple tables at once

search_tables_schema

Search the table by name pattern and retrieve its pattern

rebuild_schema_cache

Forced rebuild mode cache

get_database_vendor_info

Get connected Oracle database version and schema information

search_columns

Search for a table containing a column of specific terms

get_pl_sql_objects

Get PL/SQL object information

get_object_source

Search the source code of PL/SQL objects

get_table_constraints

Get all constraints of the table

get_table_indexes

Get all indexes of the table

get_dependent_objects

Find all objects that depend on the specified database object

get_user_defined_types

Get information about user-defined types in the database

get_related_tables

Get all tables related to the specified table by foreign keys

Prompts

Interactive templates invoked by user choice

No prompts

Resources

Contextual data attached and managed by the client

No resources

Author

danielmeppiel

Claim Ownership

Verify you have write access to the repository

Version

v0.1.4

Repository

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

GitHub Stars

License

MIT License

Last publish date

2025-05-10

Last update date

2025-08-15

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
            }
        }
    }
}

Top Comments

Related MCP Servers

View all databases servers →

mindsdb

4.6

by mindsdb

MindsDB is an open-source server that enables seamless interaction with large-scale federated data using the Model Context Protocol (MCP).

danielmeppiel/oracle-mcp-server

Tools

get_table_schema

get_tables_schema

search_tables_schema

rebuild_schema_cache

get_database_vendor_info

search_columns

get_pl_sql_objects

get_object_source

get_table_constraints

get_table_indexes

get_dependent_objects

get_user_defined_types

get_related_tables

Prompts

No prompts

Resources

No resources

Related MCP Servers

mindsdb

dbhub

pg-mcp-server

supabase-mcp

prisma

supabase-mcp-server

mysql_mcp_server_pro

db-mcp-server

mcp-server

postgresql-mcp-server

azure-mcp

anyquery

mcp-server-mysql

mcp-proxy

mcp-server-motherduck

mariadb-mcp-server

postg-mem

atlas-mcp-server

airtable-mcp-server

mcp-server-milvus

xiyan_mcp_server

prometheus-mcp-server

mcp-server-splunk

mcp-redis

mongodb-lens

mcp-snowflake-server

redshift-utils-mcp