Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| DEBUG | No | Enable debug logging | False |
| MAX_ROWS_EXPORT | No | Maximum rows for export operations | 10000 |
| QUERY_LIMIT_SIZE | No | Maximum rows returned per query | 100 |
| TABLE_WHITE_LIST | No | Comma-separated list of allowed tables | |
| COLUMN_WHITE_LIST | No | Comma-separated list of allowed columns | |
| DB_CONNECTION_STRING | Yes | Oracle connection string |
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 against the Oracle database. Only SELECT, DESCRIBE, and EXPLAIN PLAN statements are allowed for safety. |
| describe_table | Get detailed information about a table including columns, data types, and constraints |
| list_tables | List all tables in the database with metadata |
| list_views | List all views in the database |
| list_procedures | List all stored procedures, functions, and packages |
| explain_query | Get the execution plan for a SQL query to analyze performance |
| generate_sample_queries | Generate sample SQL queries for a given table to help with exploration |
| export_query_results | Export query results in various formats (JSON, CSV) |