Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| ORACLE_SID | No | Oracle SID | |
| ORACLE_HOST | No | Oracle database host | |
| ORACLE_PORT | No | Oracle database port | |
| ORACLE_USER | No | Oracle database username | |
| ORACLE_PASSWORD | No | Oracle database password | |
| ORACLE_TNS_NAME | No | Oracle TNS name | |
| ORACLE_SERVICE_NAME | No | Oracle service name | |
| ORACLE_DEFAULT_SCHEMA | No | Default schema if different from user | |
| ORACLE_CONNECTION_STRING | No | Oracle easy connect string in format hostname:1521/service_name |
Schema
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_query | Execute a SQL query on the Oracle database |
| list_tables | List tables from specified schema or all accessible schemas |
| describe_table | Get table structure including columns, data types, and constraints |
| get_table_indexes | Get indexes for a specific table |
| get_table_constraints | Get constraints (primary keys, foreign keys, unique, check) for a table |
| list_schemas | List all schemas in the database |