OraViz MCP
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
| LOG_LEVEL | No | structlog level number | 20 |
| LOG_FORMAT | No | json (default) or console | json |
| ORACLE_DSN | No | Full EZConnect descriptor; overrides host/port/service | |
| ORACLE_HOST | No | Database hostname | localhost |
| ORACLE_PORT | No | Listener port | 1521 |
| ORACLE_USER | Yes | Database user (required) | |
| ORACLE_SERVICE | No | Service name | FREEPDB1 |
| ORACLE_PASSWORD | Yes | Password for the user (required) | |
| ORACLE_CONFIG_DIR | No | Wallet config directory (Autonomous Database / mTLS) | |
| ORACLE_CALL_TIMEOUT | No | Per-statement timeout, seconds (0 disables) | 60 |
| ORACLE_MCP_MAX_ROWS | No | Hard row cap per query | 500 |
| ORACLE_MCP_BIND_HOST | No | Bind host for network transports | 127.0.0.1 |
| ORACLE_MCP_BIND_PORT | No | Bind port for network transports | 8080 |
| ORACLE_CONNECT_TIMEOUT | No | TCP connect timeout, seconds | 10 |
| ORACLE_WALLET_LOCATION | No | Wallet location | |
| ORACLE_WALLET_PASSWORD | No | Wallet password | |
| ORACLE_MCP_PREVIEW_ROWS | No | Default preview size for execute_query | 25 |
| ORACLE_MCP_MAX_CELL_CHARS | No | Per-cell truncation limit | 500 |
| ORACLE_MCP_SERVER_TRANSPORT | No | stdio (default), http, sse, streamable-http | stdio |
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": true
} |
| logging | {} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| execute_queryA | Executes a read-only SELECT/WITH query and returns a compact markdown table plus a metadata line (row count, and whether more rows exist). Results are preview-capped by default to protect the caller's context: aggregate in SQL and only pass max_rows when the raw rows are really needed. Large cell values are summarised. |
| list_tablesA | Retrieves a list of all tables and views available in the configured Oracle schema as a compact markdown table. Optionally takes a schema name. |
| get_table_schemaA | Retrieves the schema of a table or view as a compact markdown table: column name, data type, length, nullability, and whether the column is part of the primary key. |
| sample_table_dataA | Retrieves a small sample of rows from the specified table as a compact markdown table. sample_size controls how many rows to return (default: 10, capped by the server). |
| get_table_detailsA | Retrieves table details: owner, tablespace, optimizer statistics (NUM_ROWS, BLOCKS, AVG_ROW_LEN, LAST_ANALYZED) and, optionally, an exact row count. |
| profile_tableB | Profiles a table for visualization: row count plus per-column statistics (non-null count, distinct count, min, max, average) to decide which chart fits the data. |
| create_chartA | Runs a read-only SQL query and renders the result as a chart image (PNG). chart_type is one of: bar, line, area, scatter, pie, histogram. The first column is the x-axis or labels; numeric columns after it become series. Returns the image plus a data preview. |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 7 tools
Most tools target clearly distinct operations, but a few boundaries require careful reading: create_chart and execute_query both run SQL, and get_table_details and get_table_schema both describe table metadata. The descriptions clarify the outputs enough that an agent should usually pick correctly.
All tool names follow a consistent snake_case verb_noun pattern: execute_query, list_tables, get_table_schema, sample_table_data, get_table_details, profile_table, create_chart. The naming is predictable and uniform across the set.
Seven tools is well-scoped for an Oracle exploration and visualization server. Each tool serves a distinct discovery or charting purpose without unnecessary bloat or missing core functionality.
The server covers the full exploration-to-visualization workflow: listing objects, inspecting schema, sampling data, profiling columns, running queries, and creating charts. Minor gaps exist, such as no table DDL viewer or chart configuration options, but an agent can accomplish the intended tasks without dead ends.