# How to integrate Snowflake Basic MCP with Atomic Agent ```json { "title": "How to integrate Snowflake Basic MCP with Atomic Agent", "toolkit": "Snowflake Basic", "toolkit_slug": "snowflake_basic", "framework": "Atomic Agent", "framework_slug": "atomic-agent", "url": "https://composio.dev/toolkits/snowflake_basic/framework/atomic-agent", "markdown_url": "https://composio.dev/toolkits/snowflake_basic/framework/atomic-agent.md", "updated_at": "2026-08-11T13:14:57.759Z" } ``` ## Introduction Atomic Agent is an open-source AI agent that runs on your machine and supports local models through llama.cpp. Connect it to 1,500+ apps through Composio, including Snowflake Basic. This guide uses Atomic Agent's built-in Composio integration. You need Atomic Agent v0.5.6 or later, your own Composio API key, and a Snowflake Basic account. See the [Atomic Agent documentation](https://atomicagent.io/docs/?cta_placement=atomic-agent-docs) for installation instructions. ## Also integrate Snowflake Basic with - [ChatGPT](https://composio.dev/toolkits/snowflake_basic/framework/chatgpt) - [Antigravity](https://composio.dev/toolkits/snowflake_basic/framework/antigravity) - [OpenAI Agents SDK](https://composio.dev/toolkits/snowflake_basic/framework/open-ai-agents-sdk) - [Claude Agent SDK](https://composio.dev/toolkits/snowflake_basic/framework/claude-agents-sdk) - [Claude Code](https://composio.dev/toolkits/snowflake_basic/framework/claude-code) - [Claude Cowork](https://composio.dev/toolkits/snowflake_basic/framework/claude-cowork) - [Codex](https://composio.dev/toolkits/snowflake_basic/framework/codex) - [Grok Build](https://composio.dev/toolkits/snowflake_basic/framework/grok-build) - [Cursor](https://composio.dev/toolkits/snowflake_basic/framework/cursor) - [VS Code](https://composio.dev/toolkits/snowflake_basic/framework/vscode) - [OpenCode](https://composio.dev/toolkits/snowflake_basic/framework/opencode) - [OpenClaw](https://composio.dev/toolkits/snowflake_basic/framework/openclaw) - [Hermes](https://composio.dev/toolkits/snowflake_basic/framework/hermes-agent) - [Google ADK](https://composio.dev/toolkits/snowflake_basic/framework/google-adk) - [LangChain](https://composio.dev/toolkits/snowflake_basic/framework/langchain) - [Vercel AI SDK](https://composio.dev/toolkits/snowflake_basic/framework/ai-sdk) - [Mastra AI](https://composio.dev/toolkits/snowflake_basic/framework/mastra-ai) - [LlamaIndex](https://composio.dev/toolkits/snowflake_basic/framework/llama-index) - [CrewAI](https://composio.dev/toolkits/snowflake_basic/framework/crew-ai) - [Pydantic AI](https://composio.dev/toolkits/snowflake_basic/framework/pydantic-ai) - [AutoGen](https://composio.dev/toolkits/snowflake_basic/framework/autogen) ## TL;DR ### How Atomic Agent connects to Snowflake Basic Atomic Agent connects to Composio's Tool Router over Streamable HTTP MCP. It discovers the tools needed for your request, and Composio handles account authentication. Execution and account-connection tools follow Atomic Agent's configured approval policy. Review any approval prompt before allowing an action on your connected account. ## Connect Snowflake Basic to Atomic Agent ### Connect Snowflake Basic to Atomic Agent - Sign up or sign in to the [Composio dashboard](https://dashboard.composio.dev/?cta_placement=atomic-agent-api-key). Copy your API key. - In Atomic Agent, open the Integrations tab and select Composio. Select API key, press e, paste the key, and press Enter. The tools become available immediately, without a restart. - Ask Atomic Agent to do something in Snowflake Basic. It searches Composio for the right tool. - On first use, open the sign-in link returned in the chat. Connect your Snowflake Basic account, then return to Atomic Agent to continue. ### Headless setup Add the following line to ~/.atomic-agent/.env, replacing YOUR_COMPOSIO_API_KEY with your key. Start Atomic Agent after saving the file. ```bash COMPOSIO_API_KEY=YOUR_COMPOSIO_API_KEY ``` ## What is the Snowflake Basic MCP server, and what's possible with it? 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 so your agent can perform Snowflake Basic operations on your behalf. ## Supported Tools | Tool slug | Name | Description | |---|---|---| | `SNOWFLAKE_BASIC_DESCRIBE_TABLE` | Describe table | Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table. | | `SNOWFLAKE_BASIC_EXPLORE_COLUMNS` | Explore Columns | Retrieves a sample of distinct values for specified columns from a Snowflake table. | | `SNOWFLAKE_BASIC_RUN_QUERY` | 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. | | `SNOWFLAKE_BASIC_SHOW_DATABASES` | Show databases | Retrieves a list of all databases available in the Snowflake account. | | `SNOWFLAKE_BASIC_SHOW_SCHEMAS` | Show schemas | Retrieves a list of all schemas within a specified Snowflake database. | | `SNOWFLAKE_BASIC_SHOW_TABLES` | Show Tables | Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database. | ## Supported Triggers None listed. ## Troubleshooting ### Why is my API key rejected? Copy the key directly from the Composio dashboard. Atomic Agent requires ASCII characters because it sends the key in an HTTP header. Remove any extra characters introduced when copying. ### Why are Composio tools unavailable after saving a key? Check that you use Atomic Agent v0.5.6 or later and that Composio is enabled in your configuration. A "composio": { "enabled": false } setting disables the integration while keeping the saved key on disk. ### Does Composio have a free plan? The Hobby plan includes 100,000 tool calls per month. Composio-managed OAuth apps have a lower included allowance. See [Composio pricing](/pricing) for the current limits that apply to your connection. ## Complete Code None listed. ## Conclusion ### Use Snowflake Basic from Atomic Agent With your account connected, ask Atomic Agent to work with Snowflake Basic in natural language. You can connect more apps through the same Composio integration as you need them. Visit the [Atomic Agent website](https://atomicagent.io/?cta_placement=atomic-agent-site) or inspect the [Atomic Agent source code](https://github.com/AtomicBot-ai/atomic-agent?cta_placement=atomic-agent-repo). ## How to build Snowflake Basic MCP Agent with another framework - [ChatGPT](https://composio.dev/toolkits/snowflake_basic/framework/chatgpt) - [Antigravity](https://composio.dev/toolkits/snowflake_basic/framework/antigravity) - [OpenAI Agents SDK](https://composio.dev/toolkits/snowflake_basic/framework/open-ai-agents-sdk) - [Claude Agent SDK](https://composio.dev/toolkits/snowflake_basic/framework/claude-agents-sdk) - [Claude Code](https://composio.dev/toolkits/snowflake_basic/framework/claude-code) - [Claude Cowork](https://composio.dev/toolkits/snowflake_basic/framework/claude-cowork) - [Codex](https://composio.dev/toolkits/snowflake_basic/framework/codex) - [Grok Build](https://composio.dev/toolkits/snowflake_basic/framework/grok-build) - [Cursor](https://composio.dev/toolkits/snowflake_basic/framework/cursor) - [VS Code](https://composio.dev/toolkits/snowflake_basic/framework/vscode) - [OpenCode](https://composio.dev/toolkits/snowflake_basic/framework/opencode) - [OpenClaw](https://composio.dev/toolkits/snowflake_basic/framework/openclaw) - [Hermes](https://composio.dev/toolkits/snowflake_basic/framework/hermes-agent) - [Google ADK](https://composio.dev/toolkits/snowflake_basic/framework/google-adk) - [LangChain](https://composio.dev/toolkits/snowflake_basic/framework/langchain) - [Vercel AI SDK](https://composio.dev/toolkits/snowflake_basic/framework/ai-sdk) - [Mastra AI](https://composio.dev/toolkits/snowflake_basic/framework/mastra-ai) - [LlamaIndex](https://composio.dev/toolkits/snowflake_basic/framework/llama-index) - [CrewAI](https://composio.dev/toolkits/snowflake_basic/framework/crew-ai) - [Pydantic AI](https://composio.dev/toolkits/snowflake_basic/framework/pydantic-ai) - [AutoGen](https://composio.dev/toolkits/snowflake_basic/framework/autogen) ## Related Toolkits - [Firecrawl](https://composio.dev/toolkits/firecrawl) - Firecrawl automates large-scale web crawling and data extraction. It helps organizations efficiently gather, index, and analyze content from online sources. - [Tavily](https://composio.dev/toolkits/tavily) - Tavily offers powerful search and data retrieval from documents, databases, and the web. It helps teams locate and filter information instantly, saving hours on research. - [Exa](https://composio.dev/toolkits/exa) - Exa is a data extraction and search platform for gathering and analyzing information from websites, APIs, or databases. It helps teams quickly surface insights and automate data-driven workflows. - [Serpapi](https://composio.dev/toolkits/serpapi) - SerpApi is a real-time API for structured search engine results. It lets you automate SERP data collection, parsing, and analysis for SEO and research. - [Peopledatalabs](https://composio.dev/toolkits/peopledatalabs) - Peopledatalabs delivers B2B data enrichment and identity resolution APIs. Supercharge your apps with accurate, up-to-date business and contact data. - [Snowflake](https://composio.dev/toolkits/snowflake) - Snowflake is a cloud data warehouse built for elastic scaling, secure data sharing, and fast SQL analytics across major clouds. - [Posthog](https://composio.dev/toolkits/posthog) - PostHog is an open-source analytics platform for tracking user interactions and product metrics. It helps teams refine features, analyze funnels, and reduce churn with actionable insights. - [Ahrefs MCP](https://composio.dev/toolkits/ahrefs_mcp) - Ahrefs MCP is Ahrefs' hosted MCP server for SEO data and insights. Use it to access backlinks, organic metrics, keyword research, and competitor analysis. - [Akta](https://composio.dev/toolkits/akta) - Akta is a company intelligence platform providing enrichment, news, and alternative business signals. It helps teams build targeted company lists and enrich data-driven workflows. - [Amplitude](https://composio.dev/toolkits/amplitude) - Amplitude is a digital analytics platform for product and behavioral data insights. It helps teams analyze user journeys and make data-driven decisions quickly. - [Amplitude MCP](https://composio.dev/toolkits/amplitude_mcp) - Amplitude MCP is Amplitude's product analytics service for tracking user behavior and product metrics. Use it to centralize product data and manage charts, dashboards, cohorts, experiments, and taxonomy. - [Audioscrape MCP](https://composio.dev/toolkits/audioscrape_mcp) - Audioscrape MCP lets agents search and retrieve speaker-attributed audio, transcripts, entities, and citations from public and workspace content. Use it to surface searchable, speaker-labeled audio and rich metadata for research, meetings, and content discovery. - [Baremetrics](https://composio.dev/toolkits/baremetrics) - Baremetrics is a subscription analytics platform for recurring-revenue businesses. It helps teams track MRR, churn, customers, and revenue trends in one place. - [Bing Webmaster Tools](https://composio.dev/toolkits/bing_webmaster_tools) - Bing Webmaster Tools is Microsoft's search console for site performance, crawling, indexing, URL submission, and verified site management. It helps site owners understand Bing Search visibility and fix issues that affect organic traffic. - [Bread & Butter](https://composio.dev/toolkits/bread_butter) - Bread & Butter is a lead-intelligence and identity platform for website visitor tracking, user profiles, attribution, authentication, and conversion workflows. It helps teams understand who is visiting, where leads come from, and how users convert. - [Bright Data MCP](https://composio.dev/toolkits/brightdata_mcp) - Bright Data MCP is an AI-powered web scraping and data collection platform. Instantly access public web data in real time with advanced scraping tools. - [Browseai](https://composio.dev/toolkits/browseai) - Browseai is a web automation and data extraction platform that turns any website into an API. It's perfect for monitoring websites and retrieving structured data without manual scraping. - [BSC Designer](https://composio.dev/toolkits/bsc_designer) - BSC Designer is a strategy execution platform for balanced scorecards, KPIs, dashboards, and strategy maps. It helps teams turn goals into measurable performance plans they can track over time. - [Chameleon](https://composio.dev/toolkits/chameleon) - Chameleon is a product adoption platform for building in-app experiences, managing customer data, and analyzing user engagement. It helps teams improve onboarding, feature discovery, and product adoption with targeted user experiences. - [Chartly](https://composio.dev/toolkits/chartly) - Chartly renders Chart.js configurations as PNG or SVG images and creates permanent chart URLs for sharing and embedding. Share and embed charts easily with stable image URLs and downloadable vector graphics. ## Frequently Asked Questions ### What are the differences in Tool Router MCP and Snowflake Basic MCP? With a standalone Snowflake Basic MCP server, the agents and LLMs can only access a fixed set of Snowflake Basic tools tied to that server. However, with the Composio Tool Router, agents can dynamically load tools from Snowflake Basic and many other apps based on the task at hand, all through a single MCP endpoint. ### Can I use Tool Router MCP with Atomic Agent? Yes, you can. Atomic Agent fully supports MCP integration. You get structured tool calling, message history handling, and model orchestration while Tool Router takes care of discovering and serving the right Snowflake Basic tools. ### Can I manage the permissions and scopes for Snowflake Basic while using Tool Router? Yes, absolutely. You can configure which Snowflake Basic scopes and actions are allowed when connecting your account to Composio. You can also bring your own OAuth credentials or API configuration so you keep full control over what the agent can do. ### How safe is my data with Composio Tool Router? All sensitive data such as tokens, keys, and configuration is fully encrypted at rest and in transit. Composio is SOC 2 Type 2 compliant and follows strict security practices so your Snowflake Basic data and credentials are handled as safely as possible. --- [See all toolkits](https://composio.dev/toolkits) ยท [Composio docs](https://docs.composio.dev/llms.txt)