How do I install the lakexpress mcp server?

Use a recorded configuration for your client, replace example credential values and paths, and verify the documented runtime. Restart or reconnect the client, then inspect the available tools.

What credentials does it need?

It reads `LAKEXPRESS_PATH`, `LAKEXPRESS_TIMEOUT`, `LAKEXPRESS_LOG_DIR`, `FASTBCP_DIR_PATH` from the environment. Store these in your client's env block or a secrets manager — never commit them to a repository — and grant the narrowest scope that still covers your use case.

SSyncDev

Start a project

Lakexpress MCP Server

MCP server for LakeXpress — automated database-to-cloud data pipeline as Parquet

Local serverstdioPython

What is the Lakexpress MCP Server?

MCP server for LakeXpress — automated database-to-cloud data pipeline as Parquet

14 subcommands — supported: logdb management, config management, sync execution, status, and cleanup
5 source databases — SQL Server, PostgreSQL, Oracle, MySQL, MariaDB
6 log databases — SQL Server, PostgreSQL, MySQL, MariaDB, SQLite, DuckDB
6 storage backends — Local, S3, S3-compatible, GCS, Azure ADLS Gen2, OneLake
7 publish targets — Snowflake, Databricks, Fabric, BigQuery, MotherDuck, Glue, DuckLake
Command preview before execution with safety confirmation

More MCP options

Compare MCP servers by category, or browse hosted MCP servers if you prefer an endpoint over a local process.

Maintainer setup documentation.

Recorded tools

Check the linked publisher documentation and your connected client's tool list. Names and availability can vary with the server version and account permissions.

Tool	What it does
preview_command	Build and preview any LakeXpress CLI command without executing it. Supports all 14 subcommands with full parameter validation.
execute_command	Execute a previously previewed command. Requires confirmation: true as a safety mechanism.
validate_auth_file	Validate that an authentication file exists, is valid JSON, and optionally check for specific auth_id entries.
list_capabilities	List all supported source databases, log databases, storage backends, publishing targets, compression types, and available commands.
suggest_workflow	Given a use case (source DB type, storage destination, optional publish target), suggest the full sequence of LakeXpress commands with example parameters.
get_version	Report the detected LakeXpress binary version and capabilities.

Configuration

Variable	Description	Required
LAKEXPRESS_PATH	Filesystem location the server is allowed to use.	Optional
LAKEXPRESS_TIMEOUT	Configuration value read at startup.	Optional
LAKEXPRESS_LOG_DIR	Filesystem location the server is allowed to use.	Optional
FASTBCP_DIR_PATH	Filesystem location the server is allowed to use.	Optional

Example prompts to try

“Use Lakexpress to preview command.”
“Use Lakexpress to execute command.”
“Use Lakexpress to validate auth file.”

Frequently asked questions

MCP server for LakeXpress — automated database-to-cloud data pipeline as Parquet Confirm the tools offered by your installed version in the connected client. Tool availability and permissions depend on the server and account configuration.