exasol/mcp-server

Exasol MCP Server

Provides an LLM access to the Exasol database via MCP tools. Includes the tools for reading the database metadata and executing data reading queries.

.. image:: https://img.shields.io/pypi/l/exasol-mcp-server :target: https://opensource.org/licenses/MIT :alt: License

.. image:: https://img.shields.io/pypi/dm/exasol-mcp-server :target: https://pypi.org/project/exasol-mcp-server/ :alt: Downloads

.. image:: https://img.shields.io/pypi/pyversions/exasol-mcp-server :target: https://pypi.org/project/exasol-mcp-server/ :alt: Supported Python Versions

.. image:: https://img.shields.io/pypi/v/exasol-mcp-server :target: https://pypi.org/project/exasol-mcp-server/ :alt: PyPi Package

🚀 Features

• Collects the metadata.

  • Enumerates the existing database objects, including schemas, tables, views, functions and UDF scripts.
  • Provides a filtering mechanisms to use with object enumeration.
  • Describes the database objects: for tables returns the list of columns and constraints; for functions and scripts - the list of input and output parameters.
  • Enables keyword search of database objects.

• Executes provided SQL query.

The complete list of tools is formally described in the Tool List <https://exasol.github.io/mcp-server/main/user_guide/tool_list.html>_ section of the user guide.

🔌️ Prerequisites

• Python <https://www.python.org/>__ >= 3.11
• MCP Client application, e.g. Claude Desktop <https://claude.ai/download>__

💾 Installation

Ensure the uv package is installed. If uncertain call

.. code-block:: shell

uv --version

To install uv on macOS please use brew, i.e.

.. code-block:: shell

brew install uv

For other operating systems, please follow the instructions <https://docs.astral.sh/uv/getting-started/installation/>__ in the uv official documentation.

🧠 Using the server with the Claude Desktop