One command to try Exasol with AI add-ons (MCP Server + JSON Tables) — auto-selects the right setup for your OS (Windows / macOS / Linux).
Project description
exasol-quickstart
Run Exasol with AI in one command — a full Exasol analytics database, an LLM-ready MCP server, and JSON-native SQL, set up the right way for your operating system.
Get started in one line
pipx run exasol-quickstart
Pick the form that fits — try it (runs once, nothing installed) or keep it (installs the command for repeated use), with either pipx or uv:
with pipx |
with uv |
|
|---|---|---|
| Try it once | pipx run exasol-quickstart |
uvx exasol-quickstart |
| Keep it | pipx install exasol-quickstart && exasol-quickstart |
uv tool install exasol-quickstart && exasol-quickstart |
Every form detects your OS, provisions Exasol the right way, and prints the endpoints. No flags, no multi-step setup.
What you get
exasol-quickstart -> three services on one shared network:
+----------------------+ +----------------------+ +----------------------+
| Exasol (database) | | MCP server | | JSON Tables |
| 127.0.0.1:8563 | | :4896/mcp | | JSON -> SQL |
+----------------------+ +----------------------+ +----------------------+
| Component | Endpoint | Purpose |
|---|---|---|
| Exasol (database) | 127.0.0.1:8563 — user sys / password exasol |
the Exasol SQL engine |
| MCP Server | http://127.0.0.1:4896/mcp |
connect Claude / any MCP client to the database |
| JSON Tables | exasol-quickstart json-tables ... |
ingest JSON and query it as SQL |
Web UI: https://127.0.0.1:8443.
Requirements
The only universal prerequisite is Python 3.9+ with pipx:
python -m pip install --user pipx
python -m pipx ensurepath
From there, exasol-quickstart chooses how Exasol runs, per platform:
| Operating system | How Exasol runs | Docker |
|---|---|---|
| Windows | Exasol Nano, in a container | required (no native Windows engine exists) |
| macOS (Apple Silicon) | Exasol Personal, in a native VM | not required (experimental) |
| Linux | Exasol Nano, in a container (native install planned) | required for now |
The container path is fully tested today; the macOS native path is experimental and not yet validated end to end.
Usage
exasol-quickstart # full stack: database + MCP + JSON Tables
exasol-quickstart --no-json-tables # database + MCP only
exasol-quickstart --dry-run # print the plan, change nothing
exasol-quickstart --base <name> # force a base: nano-docker | personal | nano-native
exasol-quickstart json-tables --help # run the JSON Tables CLI
Ingest some JSON:
docker cp data.json exasol-quickstart-json-tables:/workspace/data.json
exasol-quickstart json-tables ingest-and-wrap --input /workspace/data.json --name demo
Stop and remove everything:
docker rm -f exasol-quickstart-db exasol-quickstart-mcp exasol-quickstart-json-tables
How it works
exasol-quickstart is a single front-door command that detects the platform and assembles the stack. With Docker, Exasol Nano, the official exasol/mcp-server image, and a JSON Tables sidecar run as containers on a shared network (tested end to end, including ingest). Without Docker, macOS uses Exasol Personal in a native VM and Linux uses a native Nano install (planned), with the add-ons as isolated host environments.
MCP Server and JSON Tables have incompatible pyexasol requirements, so each runs in isolation — a separate container or host environment — never a shared Python environment.
Links
- PyPI: https://pypi.org/project/exasol-quickstart/
- GitHub: https://github.com/krishna-exasol/exasol-quickstart
License
MIT
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file exasol_quickstart-0.3.7.tar.gz.
File metadata
- Download URL: exasol_quickstart-0.3.7.tar.gz
- Upload date:
- Size: 10.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
3215484d6d5fc513f67f318af45075f7b1343ee9862ed8c14c72511cd689be01
|
|
| MD5 |
92d3eac00cd94c82cc21fdac329274e1
|
|
| BLAKE2b-256 |
8555f3fc8ffebb8ad7b92b31c593daaa97ab13457e9b879f97ce6cb173b0b31c
|
Provenance
The following attestation bundles were made for exasol_quickstart-0.3.7.tar.gz:
Publisher:
release.yml on krishna-exasol/exasol-quickstart
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
exasol_quickstart-0.3.7.tar.gz -
Subject digest:
3215484d6d5fc513f67f318af45075f7b1343ee9862ed8c14c72511cd689be01 - Sigstore transparency entry: 1965675860
- Sigstore integration time:
-
Permalink:
krishna-exasol/exasol-quickstart@998364528903a16cd52316f97d2e92ca7204abb5 -
Branch / Tag:
refs/tags/v0.3.7 - Owner: https://github.com/krishna-exasol
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@998364528903a16cd52316f97d2e92ca7204abb5 -
Trigger Event:
release
-
Statement type:
File details
Details for the file exasol_quickstart-0.3.7-py3-none-any.whl.
File metadata
- Download URL: exasol_quickstart-0.3.7-py3-none-any.whl
- Upload date:
- Size: 10.2 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? Yes
- Uploaded via: twine/6.1.0 CPython/3.13.12
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
9a8e0772ca6076f454c0a7bbc8f41d436585b7d7b38f4a7b88a23425f890e793
|
|
| MD5 |
eb5a4ef2cb65b55a73e3051bf594952c
|
|
| BLAKE2b-256 |
bcb46e34d6f4e841b6f5800513ce97bc68b92cb7f6661a04dba9eb91d410618c
|
Provenance
The following attestation bundles were made for exasol_quickstart-0.3.7-py3-none-any.whl:
Publisher:
release.yml on krishna-exasol/exasol-quickstart
-
Statement:
-
Statement type:
https://in-toto.io/Statement/v1 -
Predicate type:
https://docs.pypi.org/attestations/publish/v1 -
Subject name:
exasol_quickstart-0.3.7-py3-none-any.whl -
Subject digest:
9a8e0772ca6076f454c0a7bbc8f41d436585b7d7b38f4a7b88a23425f890e793 - Sigstore transparency entry: 1965675993
- Sigstore integration time:
-
Permalink:
krishna-exasol/exasol-quickstart@998364528903a16cd52316f97d2e92ca7204abb5 -
Branch / Tag:
refs/tags/v0.3.7 - Owner: https://github.com/krishna-exasol
-
Access:
public
-
Token Issuer:
https://token.actions.githubusercontent.com -
Runner Environment:
github-hosted -
Publication workflow:
release.yml@998364528903a16cd52316f97d2e92ca7204abb5 -
Trigger Event:
release
-
Statement type: