The Snowflake Basic MCP server is an implementation of the Model Context Protocol that connects your AI agent and assistants like Claude, Cursor, etc directly to your Snowflake Basic account. It provides structured and secure access to your databases, schemas, tables, columns, and SQL analytics, so your agent can explore data structures, inspect columns, sample distinct values, list tables, and run SQL queries on your behalf.
- Database and schema discovery: Have your agent list the databases available to you and explore the schemas within a selected database.
- Table inventory and sizing: Let the agent list tables in a chosen schema, including their row counts and sizes in bytes.
- Column structure inspection: Direct your agent to describe a table's columns, data types, nullability, default values, and key status.
- Distinct value exploration: Instruct your agent to sample distinct values from selected columns before planning deeper analysis.
- SQL query execution: Have your agent run SQL queries within an accessible database and schema to analyze your Snowflake data.