
Lakexpress Mcp
This server wraps LakeXpress, a database export tool that syncs relational data to Parquet files in cloud storage. It exposes 14 subcommands through two main tools: preview_command for building CLI invocations with parameter validation, and execute_command with confirmation guards. You can initialize log databases, create sync configs, trigger exports, and check status across five source databases (SQL Server, PostgreSQL, Oracle, MySQL, MariaDB) and six storage backends including S3, GCS, and Azure. It also suggests workflows based on your source and destination, validates auth files, and reports capabilities. Reach for this when you need Claude to orchestrate database-to-lake pipelines with LakeXpress without manually constructing shell commands.
- GitHub stars
- 1
- tools
- 6
- transport
- STDIO
- env vars
- 5
- last updated
- Mar 16, 2026
Tools
6 toolsPublic tool metadata for what this MCP can expose to an agent.
preview_commandBuild and preview any LakeXpress CLI command without executing it. Supports all 14 subcommands with full parameter validation.
Build and preview any LakeXpress CLI command without executing it. Supports all 14 subcommands with full parameter validation.
No parameter schema in public metadata yet.
execute_commandExecute a previously previewed command. Requires `confirmation: true` as a safety mechanism.
Execute a previously previewed command. Requires `confirmation: true` as a safety mechanism.
No parameter schema in public metadata yet.
validate_auth_fileValidate that an authentication file exists, is valid JSON, and optionally check for specific `auth_id` entries.
Validate that an authentication file exists, is valid JSON, and optionally check for specific `auth_id` entries.
No parameter schema in public metadata yet.
list_capabilitiesList all supported source databases, log databases, storage backends, publishing targets, compression types, and available commands.
List all supported source databases, log databases, storage backends, publishing targets, compression types, and available commands.
No parameter schema in public metadata yet.
suggest_workflowGiven a use case (source DB type, storage destination, optional publish target), suggest the full sequence of LakeXpress commands with example parameters.
Given a use case (source DB type, storage destination, optional publish target), suggest the full sequence of LakeXpress commands with example parameters.
No parameter schema in public metadata yet.
get_versionReport the detected LakeXpress binary version and capabilities.
Report the detected LakeXpress binary version and capabilities.
No parameter schema in public metadata yet.
Sponsors
Configuration
LAKEXPRESS_PATHPath to the LakeXpress binary (optional — server runs in preview-only mode without it)
LAKEXPRESS_TIMEOUTExecution timeout in seconds (default: 3600)
LAKEXPRESS_LOG_DIRDirectory for execution logs (default: ./logs)
FASTBCP_DIR_PATHPath to FastBCP binary directory (auto-fills fastbcp_dir_path parameter)
LOG_LEVELLogging level: DEBUG, INFO, WARNING, ERROR (default: INFO)
Readme
LakeXpress MCP Server
A Model Context Protocol (MCP) server for LakeXpress — a database to Parquet export tool with sync management and data lake publishing.
Features
Details
- Repository
- github.com/arpe-io/lakexpress-mcp
- Categories
- Sales & Marketing, Databases, Automation & Workflows, Data & Analytics
- Package
lakexpress-mcp- Transport
- STDIO
- Registry
- MCP registry, active