# Exasol MCP Server
<p align="center">
<a href="https://opensource.org/licenses/MIT">
<img src="https://img.shields.io/pypi/l/exasol_mcp_server" alt="License">
</a>
<a href="https://pypi.org/project/exasol_mcp_server/">
<img src="https://img.shields.io/pypi/dm/exasol_mcp_server" alt="Downloads">
</a>
<a href="https://pypi.org/project/exasol_mcp_server/">
<img src="https://img.shields.io/pypi/pyversions/exasol_mcp_server" alt="Supported Python Versions">
</a>
<a href="https://pypi.org/project/exasol_mcp_server/">
<img src="https://img.shields.io/pypi/v/exasol_mcp_server" alt="PyPi Package">
</a>
</p>
Provides an LLM access to the Exasol database via MCP tools. Includes the
tools for reading the database metadata and executing data reading queries.
## 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.
- Executes provided data reading SQL query. Disallows any other type of query.
## Prerequisites
- [Python](https://www.python.org/) >= 3.10.
- MCP Client application, e.g. [Claude Desktop](https://claude.ai/download).
## Installation
Ensure the `uv` package is installed. If uncertain call
```bash
uv --version
```
To install `uv`, please follow [the instructions](https://docs.astral.sh/uv/getting-started/installation/)
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`.
To find the 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.
```json
{
"mcpServers": {
"exasol_db": {
"command": "uvx",
"args": ["exasol-mcp-server"],
"env": {
"EXA_DSN": "demodb.exasol.com:8563",
"EXA_USER": "my-user-name",
"EXA_PASSWORD": "my-password"
}
},
"other_server": {}
}
}
```
With these settings, uv will install and run the "exasol-mcp-package" in an
ephemeral environment, using the default `uv` parameters and default server settings.
## Configuration settings:
Most importantly, the server configuration specifies if reading the data using SQL
queries is enabled. Note that reading is disabled by default. To enable the data
reading, the `enable_read_query` property must be set to true (see the
configuration settings json below).
The server configuration settings can also be used to enable/disable or filter the
listing of a particular type of database objects. Similar settings are defined for
the following object types:
```
schemas,
tables,
views,
functions,
scripts
```
The settings include the following properties:
- `enable`: a boolean flag that enables or disables the listing.
- `like_pattern`: filters the output by applying the specified SQL LIKE condition to
the object name.
- `regexp_pattern`: filters the output by matching the object name with the specified
regular expression.
The settings can be specified using another environment variable - `EXA_MCP_SETTINGS`.
They should be written in the json format. The json text can be set directly as a
value of the environment variable, for example
```json
{"EXA_MCP_SETTINGS": "{\"schemas\": {\"like_pattern\": \"my_schemas\"}"}
```
Note that double quotes in the json text must be escaped, otherwise the environment
variable value will be interpreted, not as a text, but as a part of the outer json.
Alternatively, the settings can be written in a json file. In this case, the
`EXA_MCP_SETTINGS` should contain the path to this file, e.g.
```json
{"EXA_MCP_SETTINGS": "path_to_settings.json"}
```
The following json shows the default configuration settings.
```json
{
"schemas": {
"enable": true,
"like_pattern": "",
"regexp_pattern": ""
},
"tables": {
"enable": true,
"like_pattern": "",
"regexp_pattern": ""
},
"views": {
"enable": false,
"like_pattern": "",
"regexp_pattern": ""
},
"functions": {
"enable": true,
"like_pattern": "",
"regexp_pattern": ""
},
"scripts": {
"enable": true,
"like_pattern": "",
"regexp_pattern": ""
},
"enable_read_query": false
}
```
## License
This project is licensed under the MIT License - see the LICENSE file for details.
### Safe Harbor Statement: Exasol MCP Server & AI Solutions
Exasol’s AI solutions (including MCP Server) are designed to enable intelligent,
autonomous, and highly performant access to data through AI and LLM-powered agents.
While these technologies unlock powerful new capabilities, they also introduce
potentially significant risks.
By granting AI agents access to your database, you acknowledge that the behavior of
large language models (LLMs) and autonomous agents cannot be fully predicted or
controlled. These systems may exhibit unintended or unsafe behavior—including but not
limited to hallucinations, susceptibility to adversarial prompts, and the execution of
unforeseen actions. Such behavior may result in data leakage, unauthorized data
generation, or even data modification or deletion.
Exasol provides the tools to build AI-native workflows; however, you, as the implementer
and system owner, assume full responsibility for managing these solutions within your
environment. This includes establishing appropriate governance, authorization controls,
sandboxing mechanisms, and operational guardrails to mitigate risks to your organization,
your customers, and their data.
Raw data
{
"_id": null,
"home_page": null,
"name": "exasol-mcp-server",
"maintainer": null,
"docs_url": null,
"requires_python": "<4.0,>=3.10",
"maintainer_email": null,
"keywords": "exasol, MCP server",
"author": "Mikhail Beck",
"author_email": "mikhail.beck@exasol.com",
"download_url": "https://files.pythonhosted.org/packages/74/4b/d0f82b67acd7a79a7d98b1d58934d5466354fe8ba1a0fe739692783e8e24/exasol_mcp_server-0.1.0.tar.gz",
"platform": null,
"description": "# Exasol MCP Server\n\n<p align=\"center\">\n\n<a href=\"https://opensource.org/licenses/MIT\">\n <img src=\"https://img.shields.io/pypi/l/exasol_mcp_server\" alt=\"License\">\n</a>\n<a href=\"https://pypi.org/project/exasol_mcp_server/\">\n <img src=\"https://img.shields.io/pypi/dm/exasol_mcp_server\" alt=\"Downloads\">\n</a>\n<a href=\"https://pypi.org/project/exasol_mcp_server/\">\n <img src=\"https://img.shields.io/pypi/pyversions/exasol_mcp_server\" alt=\"Supported Python Versions\">\n</a>\n<a href=\"https://pypi.org/project/exasol_mcp_server/\">\n <img src=\"https://img.shields.io/pypi/v/exasol_mcp_server\" alt=\"PyPi Package\">\n</a>\n</p>\n\nProvides an LLM access to the Exasol database via MCP tools. Includes the\ntools for reading the database metadata and executing data reading queries.\n\n## Features\n\n- Collects the metadata.\n * Enumerates the existing database objects, including schemas, tables, views, functions and UDF scripts.\n * Provides a filtering mechanisms to use with object enumeration.\n * Describes the database objects: for tables returns the list of columns and constraints; for functions and scripts - the list of input and output parameters.\n- Executes provided data reading SQL query. Disallows any other type of query.\n\n## Prerequisites\n\n- [Python](https://www.python.org/) >= 3.10.\n- MCP Client application, e.g. [Claude Desktop](https://claude.ai/download).\n\n## Installation\n\nEnsure the `uv` package is installed. If uncertain call\n```bash\nuv --version\n```\nTo install `uv`, please follow [the instructions](https://docs.astral.sh/uv/getting-started/installation/)\nin the `uv` official documentation.\n\n## Using the server with the Claude Desktop.\n\nTo enable the Claude Desktop using the Exasol MCP server, the latter must be listed\nin the configuration file `claude_desktop_config.json`.\n\nTo find the configuration file, click on the Settings and navigate to the\n\u201cDeveloper\u201d tab. This section contains options for configuring MCP servers and other\ndeveloper features. Click the \u201cEdit Config\u201d button to open the configuration file in\nthe editor of your choice.\n\nAdd the Exasol MCP server to the list of MCP servers as shown in this configuration\nexample.\n```json\n{\n \"mcpServers\": {\n \"exasol_db\": {\n \"command\": \"uvx\",\n \"args\": [\"exasol-mcp-server\"],\n \"env\": {\n \"EXA_DSN\": \"demodb.exasol.com:8563\",\n \"EXA_USER\": \"my-user-name\",\n \"EXA_PASSWORD\": \"my-password\"\n }\n },\n \"other_server\": {}\n }\n}\n```\n\nWith these settings, uv will install and run the \"exasol-mcp-package\" in an\nephemeral environment, using the default `uv` parameters and default server settings.\n\n## Configuration settings:\n\nMost importantly, the server configuration specifies if reading the data using SQL\nqueries is enabled. Note that reading is disabled by default. To enable the data\nreading, the `enable_read_query` property must be set to true (see the\nconfiguration settings json below).\n\nThe server configuration settings can also be used to enable/disable or filter the\nlisting of a particular type of database objects. Similar settings are defined for\nthe following object types:\n```\nschemas,\ntables,\nviews,\nfunctions,\nscripts\n```\nThe settings include the following properties:\n- `enable`: a boolean flag that enables or disables the listing.\n- `like_pattern`: filters the output by applying the specified SQL LIKE condition to\nthe object name.\n- `regexp_pattern`: filters the output by matching the object name with the specified\nregular expression.\n\nThe settings can be specified using another environment variable - `EXA_MCP_SETTINGS`.\nThey should be written in the json format. The json text can be set directly as a\nvalue of the environment variable, for example\n```json\n{\"EXA_MCP_SETTINGS\": \"{\\\"schemas\\\": {\\\"like_pattern\\\": \\\"my_schemas\\\"}\"}\n```\nNote that double quotes in the json text must be escaped, otherwise the environment\nvariable value will be interpreted, not as a text, but as a part of the outer json.\n\nAlternatively, the settings can be written in a json file. In this case, the\n`EXA_MCP_SETTINGS` should contain the path to this file, e.g.\n```json\n{\"EXA_MCP_SETTINGS\": \"path_to_settings.json\"}\n```\n\nThe following json shows the default configuration settings.\n```json\n{\n \"schemas\": {\n \"enable\": true,\n \"like_pattern\": \"\",\n \"regexp_pattern\": \"\"\n },\n \"tables\": {\n \"enable\": true,\n \"like_pattern\": \"\",\n \"regexp_pattern\": \"\"\n },\n \"views\": {\n \"enable\": false,\n \"like_pattern\": \"\",\n \"regexp_pattern\": \"\"\n },\n \"functions\": {\n \"enable\": true,\n \"like_pattern\": \"\",\n \"regexp_pattern\": \"\"\n },\n \"scripts\": {\n \"enable\": true,\n \"like_pattern\": \"\",\n \"regexp_pattern\": \"\"\n },\n \"enable_read_query\": false\n}\n```\n\n## License\n\nThis project is licensed under the MIT License - see the LICENSE file for details.\n\n### Safe Harbor Statement: Exasol MCP Server & AI Solutions\n\nExasol\u2019s AI solutions (including MCP Server) are designed to enable intelligent,\nautonomous, and highly performant access to data through AI and LLM-powered agents.\nWhile these technologies unlock powerful new capabilities, they also introduce\npotentially significant risks.\n\nBy granting AI agents access to your database, you acknowledge that the behavior of\nlarge language models (LLMs) and autonomous agents cannot be fully predicted or\ncontrolled. These systems may exhibit unintended or unsafe behavior\u2014including but not\nlimited to hallucinations, susceptibility to adversarial prompts, and the execution of\nunforeseen actions. Such behavior may result in data leakage, unauthorized data\ngeneration, or even data modification or deletion.\n\nExasol provides the tools to build AI-native workflows; however, you, as the implementer\nand system owner, assume full responsibility for managing these solutions within your\nenvironment. This includes establishing appropriate governance, authorization controls,\nsandboxing mechanisms, and operational guardrails to mitigate risks to your organization,\nyour customers, and their data.\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Exasol MCP Server",
"version": "0.1.0",
"project_urls": null,
"split_keywords": [
"exasol",
" mcp server"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "26e569ab9a60b18cb4eefccaf1f06a10b5c5eb69ee05545a43ea5f3d07f8547d",
"md5": "9e21be603e352c202694f3735ec5d199",
"sha256": "6bd10fcf7f7a1da9b83e1fdb0802b89f0dc1955642114381f431107eba5c5802"
},
"downloads": -1,
"filename": "exasol_mcp_server-0.1.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "9e21be603e352c202694f3735ec5d199",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": "<4.0,>=3.10",
"size": 14908,
"upload_time": "2025-08-05T14:20:06",
"upload_time_iso_8601": "2025-08-05T14:20:06.423463Z",
"url": "https://files.pythonhosted.org/packages/26/e5/69ab9a60b18cb4eefccaf1f06a10b5c5eb69ee05545a43ea5f3d07f8547d/exasol_mcp_server-0.1.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "744bd0f82b67acd7a79a7d98b1d58934d5466354fe8ba1a0fe739692783e8e24",
"md5": "8f4233492841aa41e23b8de1876b8f1f",
"sha256": "a4fb61f04200a12b72aab92db09138b90eb651126fe9788140f2cea4cb7b0a54"
},
"downloads": -1,
"filename": "exasol_mcp_server-0.1.0.tar.gz",
"has_sig": false,
"md5_digest": "8f4233492841aa41e23b8de1876b8f1f",
"packagetype": "sdist",
"python_version": "source",
"requires_python": "<4.0,>=3.10",
"size": 14481,
"upload_time": "2025-08-05T14:20:07",
"upload_time_iso_8601": "2025-08-05T14:20:07.441783Z",
"url": "https://files.pythonhosted.org/packages/74/4b/d0f82b67acd7a79a7d98b1d58934d5466354fe8ba1a0fe739692783e8e24/exasol_mcp_server-0.1.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2025-08-05 14:20:07",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "exasol-mcp-server"
}
JSON