Skip to content

1.9.0

Choose a tag to compare

View all tags
@github-actions github-actions released this 03 Jun 12:05
· 26 commits to main since this release
1.9.0
a839b28
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.

1.9.0 - 2026-06-03

Summary

Added diagnostics and profiling tools, and the skills provider.

Bug Fixes

  • #223: Fixed profile_exasol_query to be side-effect free: the tool now checks whether
    session profiling is already enabled via SYS.EXA_PARAMETERS and skips the
    ALTER SESSION SET PROFILE statements if it was already ON.

Features

  • #217: Added summarize_exasol_table tool that returns per-column statistics
    (distinct value count, min/max for numeric columns) and a sample of rows.
    Enabled via enable_summarize_table configuration flag.
  • #219: Added profile_exasol_query tool that runs a query with profiling enabled
    and returns the execution plan breakdown from EXA_STATISTICS.EXA_USER_PROFILE_LAST_DAY.
    Enabled via enable_query_profiling configuration flag.
  • #219: Added optional row_limit parameter to execute_exasol_query for previewing
    query results without fetching all rows.
  • #221: Added list_exasol_preprocessors tool that lists available SQL preprocessor
    scripts and reports the currently active one. Added set_exasol_preprocessor tool
    that activates a preprocessor at the session level. Both tools are enabled by default
    and can be disabled via the enable_preprocessor_tools configuration flag.
  • #225: Added dynamodb, redis, and mongodb storage backends for OAuth state persistence.
    Configure via EXA_MCP_OAUTH_STORAGE_BACKEND and backend-specific environment variables.
    Install the matching optional extra (exasol-mcp-server[dynamodb], [redis], or [mongodb]) for the required client library.
  • #227: Added seven MCP skills served as resources via the FastMCP skills protocol:
    exasol-sql-dialect (SQL dialect specifics), exasol-udfs (UDF and scripting guide),
    exasol-mcp-server (tool workflows and usage patterns), exasol-system-tables
    (system and statistics table reference), exasol-table-design (DISTRIBUTE BY,
    PARTITION BY, data types, and CREATE TABLE best practices for performance),
    exasol-import-export (IMPORT/EXPORT SQL for CSV, Parquet, and cloud storage),
    and exasol-virtual-schemas (federated access to external data sources via adapter
    scripts). Skills are always available and require no additional configuration.
Assets 4
Loading