mcp-snowflake-server-GHL by mamura66 - MCP Server

MCP Snowflake Server for HighLevel

A Cloudflare Worker that provides Model Context Protocol (MCP) interface to Snowflake with intelligent date and time formatting.

Features

Data Formatting

DATE Columns: Automatically converts epoch days to YYYY-MM-DD format
TIME Columns: Converts seconds since midnight to HH:MM:SS format
TIMESTAMP Columns: Preserves epoch seconds for precision (all variants: LTZ, NTZ, TZ)
Mixed Data Types: Selective conversion - only date/time columns are formatted

Date Range Support

Supports dates from 1970-01-01 to ~2080 (110+ years)
Handles both string and numeric epoch day values
Proper NULL value handling

Example Transformations

Before (Raw Snowflake Output):

{
  "rows": [["20343", "52245.000000000", "1757670567.643000000"]],
  "resultSetMetaData": {
    "rowType": [
      {"name": "DATE_COL", "type": "date"},
      {"name": "TIME_COL", "type": "time"},
      {"name": "TIMESTAMP_COL", "type": "timestamp_ltz"}
    ]
  }
}

After (Formatted Output):

{
  "rows": [["2025-09-12", "14:30:45", "1757670567.643000000"]],
  "resultSetMetaData": {
    "rowType": [
      {"name": "DATE_COL", "type": "date"},
      {"name": "TIME_COL", "type": "time"},
      {"name": "TIMESTAMP_COL", "type": "timestamp_ltz"}
    ]
  }
}

API Endpoints

Query Endpoint

GET /query?sql=SELECT CURRENT_DATE() as today

Chat Completion Endpoint (TypingMind Integration)

POST /v1/chat/completions

Configuration

The worker requires the following environment variables:

SNOWFLAKE_ACCOUNT
SNOWFLAKE_USER
SNOWFLAKE_DATABASE
SNOWFLAKE_SCHEMA
SNOWFLAKE_WAREHOUSE
SNOWFLAKE_ROLE
ACCESS_TOKEN
REFRESH_TOKEN
CLIENT_ID
CLIENT_SECRET
TOKEN_ENDPOINT

Deployment

Deploy using Wrangler CLI:

wrangler deploy

Schema Support

The server includes schema subsetting for HighLevel analysis views and supports read-only queries with automatic date/time formatting based on Snowflake column metadata.

Production URL

https://mcp-snowflake-server.highlevel-inc-enterprise-account.workers.dev