get_user_defined_types
Get information about user-defined types in the database.
How to use it
get_user_defined_types is exposed by the Oracle MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the get_user_defined_types tool becomes available to the model automatically. See the full listing for setup details and every tool this server provides.
Install Oracle MCP Server
uv pip install -e .Other tools in Oracle MCP Server (13)
Get information about the connected Oracle database version and schema.
Find all objects that depend on a specified database object.
Retrieve the source code for a PL/SQL object. Useful for debugging and understanding database logic.
Get information about PL/SQL objects like procedures, functions, packages, triggers, etc.
Get all tables that are related to a specified table through foreign keys, showing both incoming and outgoing relationships.
Get all constraints (primary keys, foreign keys, unique constraints, check constraints) for a table.
Get all indexes defined on a table, helpful for query optimization.
Get detailed schema information for a specific table including columns, data types, nullability, and relationships.
Get schema information for multiple tables at once. More efficient than calling gettableschema multiple times.
Force a rebuild of the schema cache. Use sparingly as this is resource-intensive.
Execute a SQL query and return the results in a formatted table.
Search for tables containing columns that match a specific term. Useful when you know what data you need but aren't sure which tables contain it.
Search for tables by name pattern and retrieve their schemas.