list_tables

About

An oracle-sql tool executes a pre-defined SQL statement against an Oracle database.

The specified SQL statement is executed using prepared statements for security and performance. It expects parameter placeholders in the SQL query to be in the native Oracle format (e.g., :1, :2).

By default, tools are configured as read-only (SAFE mode). To execute data modification statements (INSERT, UPDATE, DELETE), you must explicitly set the readOnly field to false.

Compatible Sources

Example

Note: This tool uses parameterized queries to prevent SQL injections. Query parameters can be used as substitutes for arbitrary expressions. Parameters cannot be used as substitutes for identifiers, column names, table names, or other parts of the query.

tools:
  list_tables:
    kind: oracle-sql
    source: my-oracle-instance
    statement: |
      SELECT table_name from user_tables;
    description: |
      Lists all table names in the current user's schema.