Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| LOG_LEVEL | No | Logging level | info |
| ORACLE_USER | Yes | Oracle database username (should be read-only user) | |
| ORACLE_PASSWORD | Yes | Oracle database password | |
| ORACLE_POOL_MAX | No | Maximum number of connections in the pool | 10 |
| ORACLE_POOL_MIN | No | Minimum number of connections in the pool | 2 |
| MAX_QUERY_LENGTH | No | Maximum length of SQL query | 50000 |
| QUERY_TIMEOUT_MS | No | Query timeout in milliseconds | 30000 |
| MAX_ROWS_PER_QUERY | No | Maximum number of rows to return per query | 1000 |
| ENABLE_AUDIT_LOGGING | No | Enable audit logging of queries | true |
| ORACLE_CONNECTION_STRING | Yes | Oracle database connection string in format hostname:port/servicename |
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 |
|---|---|
| query_database | Execute a read-only SQL SELECT query against the Oracle database. Returns rows, column names, and execution metrics. |
| get_database_schema | Get database schema information. If tableName is provided, returns column details for that table. Otherwise, returns a list of all accessible tables. |