Snowflake Cortex AI

Snowflake Cortex MCP server by BHANUJ that provides AI assistants with natural language access to Snowflake's AI capabilities through three integrated tools: Text2SQL for converting natural language queries into SQL using Cortex Analyst with semantic models, Cortex Search for document retrieval from PDF content stored in Snowflake stages, and direct SQL execution for running generated queries against data warehouses. Built with TypeScript and the MCP SDK, the implementation uses configurable tool definitions with environment variable substitution, supports streaming responses from Cortex agents, and includes sample data setup for TPC-DS retail analytics and vehicle contract documents. Designed for business users who need conversational access to enterprise data warehouses, analysts requiring semantic search across document repositories, and organizations leveraging Snowflake's native AI services for data exploration without writing SQL directly.