Exasol MCP 服务器

通过MCP工具为Exasol数据库提供LLM访问. 包括 用于读取数据库元数据和执行数据读取查询的工具。

. 图像: https://img.shields.io/pypi/l/exasol-mcp-server :目标:https://opensource.org/licenses/MIT : alt: 许可证

. 图像: https://img.shields.io/pypi/dm/exasol-mcp-server :目标: https://pypi.org/project/exasol-mcp-server/ : 备选案文:下载

. 图像: https://img.shields.io/pypi/pyversions/exasol-mcp-server :目标:https://pypi.org/project/exasol-mcp-server/ : alt: 支持的 Python 版本

… 图像: https://img.shields.io/pypi/v/exasol-mcp-server :目标:https://pypi.org/project/exasol-mcp-server/ : 备选案文: PyPi 软件包

• 特性

---

• 收集元数据。

• 假设现有的数据库对象,包括计划、表格、视图、函数和UDF脚本。

• 提供用于点出对象的过滤机制。

• 描述数据库对象:表格返回列和限制的列表;函数和脚本——输入和输出参数的列表。

• 启用数据库对象的关键字搜索。

• 执行者提供了SQL查询.

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"
            }
        }
    }
}