LakeXpress MCP
An MCP server for LakeXpress that enables automated database-to-cloud data pipelines by exporting data to Parquet format. It supports 14 subcommands for logdb and config management, sync execution, and status checks. It integrates with 5 source databases (SQL Server, PostgreSQL, Oracle, MySQL, MariaDB), 6 log databases, 6 storage backends (Local, S3, GCS, Azure ADLS, OneLake), and 7 publish targets (Snowflake, Databricks, Fabric, BigQuery, etc.). It includes safety features like command preview and auth file validation.
Package and access
Local package with source-attributed installation metadata. Koskamo does not execute packages during review.
What you can do with it
- Preview LakeXpress CLI commands before execution
- Execute database sync jobs with safety confirmation
- Validate authentication files for database access
- Suggest workflows based on source and destination types
Source and maintenance
- Maintenance checked
Packages and installation
Source-provided package data. Koskamo has not executed or live-probed this package.
lakexpress-mcp 0.1.6
{
"version": "0.1.6",
"transport": "stdio",
"identifier": "lakexpress-mcp",
"registryType": "pypi",
"environmentVariables": [
{
"name": "LAKEXPRESS_PATH",
"format": "string",
"description": "Path to the LakeXpress binary (optional — server runs in preview-only mode without it)"
},
{
"name": "LAKEXPRESS_TIMEOUT",
"format": "string",
"description": "Execution timeout in seconds (default: 3600)"
},
{
"name": "LAKEXPRESS_LOG_DIR",
"format": "string",
"description": "Directory for execution logs (default: ./logs)"
},
{
"name": "FASTBCP_DIR_PATH",
"format": "string",
"description": "Path to FastBCP binary directory (auto-fills fastbcp_dir_path parameter)"
},
{
"name": "LOG_LEVEL",
"format": "string",
"description": "Logging level: DEBUG, INFO, WARNING, ERROR (default: INFO)"
}
]
}Tools
Reported by the attributed source; not independently observed by Koskamo.
Connect from your client
Each snippet configures the same source-provided package; replace placeholders before use.
Cursor
{
"mcpServers": {
"lakexpress-mcp": {
"command": "uvx",
"args": [
"lakexpress-mcp==0.1.6"
],
"env": {
"LAKEXPRESS_PATH": "<YOUR_LAKEXPRESS_PATH>",
"LAKEXPRESS_TIMEOUT": "<YOUR_LAKEXPRESS_TIMEOUT>",
"LAKEXPRESS_LOG_DIR": "<YOUR_LAKEXPRESS_LOG_DIR>",
"FASTBCP_DIR_PATH": "<YOUR_FASTBCP_DIR_PATH>",
"LOG_LEVEL": "<YOUR_LOG_LEVEL>"
}
}
}
}Cline
{
"mcpServers": {
"lakexpress-mcp": {
"command": "uvx",
"args": [
"lakexpress-mcp==0.1.6"
],
"env": {
"LAKEXPRESS_PATH": "<YOUR_LAKEXPRESS_PATH>",
"LAKEXPRESS_TIMEOUT": "<YOUR_LAKEXPRESS_TIMEOUT>",
"LAKEXPRESS_LOG_DIR": "<YOUR_LAKEXPRESS_LOG_DIR>",
"FASTBCP_DIR_PATH": "<YOUR_FASTBCP_DIR_PATH>",
"LOG_LEVEL": "<YOUR_LOG_LEVEL>"
}
}
}
}VS Code
{
"servers": {
"lakexpress-mcp": {
"type": "stdio",
"command": "uvx",
"args": [
"lakexpress-mcp==0.1.6"
],
"env": {
"LAKEXPRESS_PATH": "<YOUR_LAKEXPRESS_PATH>",
"LAKEXPRESS_TIMEOUT": "<YOUR_LAKEXPRESS_TIMEOUT>",
"LAKEXPRESS_LOG_DIR": "<YOUR_LAKEXPRESS_LOG_DIR>",
"FASTBCP_DIR_PATH": "<YOUR_FASTBCP_DIR_PATH>",
"LOG_LEVEL": "<YOUR_LOG_LEVEL>"
}
}
}
}Claude Desktop
{
"mcpServers": {
"lakexpress-mcp": {
"command": "uvx",
"args": [
"lakexpress-mcp==0.1.6"
],
"env": {
"LAKEXPRESS_PATH": "<YOUR_LAKEXPRESS_PATH>",
"LAKEXPRESS_TIMEOUT": "<YOUR_LAKEXPRESS_TIMEOUT>",
"LAKEXPRESS_LOG_DIR": "<YOUR_LAKEXPRESS_LOG_DIR>",
"FASTBCP_DIR_PATH": "<YOUR_FASTBCP_DIR_PATH>",
"LOG_LEVEL": "<YOUR_LOG_LEVEL>"
}
}
}
}Let your agent find its tools
Find servers like LakeXpress MCP from your agent. Add Koskamo once to search the index for endpoints, access requirements, and client setup. Public discovery needs no key.