oleander Codex plugin

Query and analyze data in the oleander warehouse from Codex.

What it provides

• Catalog discovery with table schemas and statistics
• Interactive DuckDB queries for tables smaller than 50 GB
• Spark job submission for larger tables
• Local CSV, JSON, and Parquet uploads into Iceberg tables

Authentication

Set your Oleander API key before starting Codex:

export OLEANDER_API_KEY="your-api-key"

The plugin passes this value to the Oleander MCP server as a bearer token. The connection is declared in .mcp.json.

Install

Install oleander from the Codex marketplace that publishes this plugin. When developing locally, add the plugin to a local marketplace, reinstall it after changes, and start a new Codex thread so updated skills and MCP tools are loaded.

Usage

Try prompts such as:

• "What tables are in my Oleander catalog?"
• "Describe oleander.default.flowers."
• "Show me 10 rows from oleander.default.flowers."
• "How many rows are in oleander.default.flowers, and what are the distinct values in each column?"
• "Upload flowers.csv as a new Iceberg table."

The plugin selects DuckDB or Spark based on the size of every table read by a query and reports which engine it used.