search_tables_schema

MCP tool from Oracle MCP Server by danielmeppiel

Search for tables by name pattern and retrieve their schemas.

How to use it

search_tables_schema is exposed by the Oracle MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), and the search_tables_schema 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 .

FULL ORACLE MCP SERVER LISTING

Other tools in Oracle MCP Server (13)

get_database_vendor_info

Get information about the connected Oracle database version and schema.

get_dependent_objects

Find all objects that depend on a specified database object.

get_object_source

Retrieve the source code for a PL/SQL object. Useful for debugging and understanding database logic.

get_pl_sql_objects

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

get_related_tables

Get all tables that are related to a specified table through foreign keys, showing both incoming and outgoing relationships.

get_table_constraints

Get all constraints (primary keys, foreign keys, unique constraints, check constraints) for a table.

get_table_indexes

Get all indexes defined on a table, helpful for query optimization.

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. More efficient than calling gettableschema multiple times.

get_user_defined_types

Get information about user-defined types in the database.

rebuild_schema_cache

Force a rebuild of the schema cache. Use sparingly as this is resource-intensive.

run_sql_query

Execute a SQL query and return the results in a formatted table.

search_columns

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.