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 _ section of the user guide.

🔌️ Prerequisites

• Python __ >= 3.11
• MCP Client application, e.g. Claude Desktop __

💾 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 __ in the uv official documentation.

🧠 Using the server with the Claude Desktop

To enable the Claude Desktop using the Exasol MCP server, the latter must be listed in the configuration file claude_desktop_config.json. A similar configuration file would exist for most other MCP Client applications.

To find the Claude Desktop configuration file, click on the Settings and navigate to the “Developer” tab. This section contains options for configuring MCP servers and other developer features. Click the “Edit Config” button to open the configuration file in the editor of your choice.

Add the Exasol MCP server to the list of MCP servers as shown in this configuration example.

… code-block:: json

{
    "mcpServers": {
        "exasol_db": {
            "command": "uvx",
            "args": ["exasol-mcp-server@latest"],
            "env": {
                "EXA_DSN": "my-dsn",
                "EXA_USER": "my-user-name",
                "EXA_PASSWORD": "my-password"
            }
        }
    }
}