How to connect Snowflake Basic MCP with Cursor

Connect Cursor to Snowflake Basic MCP. Run a sql query for daily sales, list all tables in your warehouse, and more using natural language, with authentication handled for you.

Snowflake Basic logoSnowflake Basic
Basic

Snowflake is a cloud-based data warehouse for scalable analytics and secure data sharing. It lets you run fast SQL queries and manage massive datasets in the cloud.

6 Tools

How to integrate Snowflake Basic MCP with Cursor

Cursor is one of the leading AI-powered code editors. It is built to help developers write, understand, and refactor code faster with AI assistance built directly into the editor.

And in this guide, I will explain the easiest and most secure way to connect your Snowflake Basic account to Cursor via Composio Connect, so it can run a SQL query for daily sales, list all tables in your warehouse, add a new record to customers table, and more without ever putting your account credentials at risk.

For exact tool slugs and parameter tables, see the tool catalog in the Composio docs.

Also integrate Snowflake Basic with

Why Composio?

  • 1,700+ SaaS toolkits out of the box. Skip the work of building and maintaining integrations, Composio gives you instant access to a vast catalog of pre-built connectors.
  • One MCP server for every app. Connect any of your applications on demand through a single endpoint, rather than juggling a separate server for each app.
  • Smart, context-aware tool loading. Unlike traditional MCP servers that dump every available tool into the LLM context window, Composio searches for and loads only the tools relevant to the task at hand. A remote CLI workbench lets LLMs compose these tools into workflows for complex automation.

Connect Snowflake Basic to Cursor

Two ways to install — pick whichever you prefer.

1. Install with one click

Click the button below to add Composio to Cursor.

↗Install in Cursor

2. Or add manually

Add to your Cursor mcp.json

Open .cursor/mcp.json in your project root (or ~/.cursor/mcp.json for global config) and add the following configuration:

bash
{
  "servers": {
    "composio": {
      "type": "http",
      "url": "https://connect.composio.dev/mcp"
    }
  }
}

3. Authorize

Restart Cursor, then click "Connect" next to Composio in MCP Tools settings.

Cursor MCP Tools settings with Connect button next to Composio

A browser window will open to authorize.

Composio authorization browser window

Connect your Snowflake Basic account

Back in Cursor, ask the agent to connect to Snowflake Basic or give it any Snowflake Basic-related task.

For example, ask it to:

  • "Run a SQL query for daily sales"
  • "List all tables in your warehouse"
  • "Add a new record to customers table"

It will prompt you to authenticate and authorize access to Snowflake Basic.

That is it. Composio tools are now available in Cursor, and your Snowflake Basic account is ready to use.

Conclusion

You have successfully connected Snowflake Basic to Cursor using Composio Connect. Your agent can now use Snowflake Basic securely without exposing credentials in prompts or local scripts.

TOOLS

Supported Tools

Every Snowflake Basic action and event your agent gets out of the box.

Describe table

Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table.

Explore Columns

Retrieves a sample of distinct values for specified columns in a Snowflake table.

Run Query

Executes the given SQL query in Snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.

Show databases

Retrieves a list of all databases available in the Snowflake account.

Show schemas

Retrieves a list of all schemas within a specified Snowflake database.

Show Tables

Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.

FAQ

Frequently asked questions

Start with Snowflake Basic.It takes 30 seconds.

Managed auth, hosted MCP servers, and every Snowflake Basic tool your agent needs.Free to start.

Start building