{"id":"orange-mcp-server-snowflake","name":"orange-mcp-server-snowflake","homepage":"https://pypi.org/project/orange-mcp-server-snowflake/","repo_url":null,"category":"ai-ml","subcategories":[],"tags":["mcp","snowflake","database","data-warehouse","ai-agents","sql"],"what_it_does":"orange-mcp-server-snowflake is an MCP server intended to let an agent connect to Snowflake and perform common Snowflake operations through MCP tools (e.g., issuing SQL/queries and returning results).","use_cases":["Agent-assisted data analysis and exploration on Snowflake","Generating and executing read-only analytical queries against Snowflake","Operational tasks like validating data quality or inspecting schemas via controlled SQL"],"not_for":["Highly sensitive environments without strong guardrails (least-privilege and query restrictions)","Workloads requiring strict billing/chargeback controls unless costs are monitored and limited","Fully offline use without network connectivity to Snowflake"],"best_when":"You want an agent to query Snowflake using a standardized MCP interface and you can configure authentication and permissions safely.","avoid_when":"You cannot restrict what SQL can be executed (e.g., read-only constraints) or you do not have a safe way to handle credentials and query parameters.","alternatives":["Use Snowflake directly with your own server-side tooling/wrapper (REST/SDK) and expose only safe operations to the agent","Build an MCP server tailored to your Snowflake use-cases with strict query allowlists/guards","Use existing database agent integrations that support Snowflake with enforced read-only roles"],"af_score":39.8,"security_score":50.5,"reliability_score":30.0,"package_type":"mcp_server","discovery_source":["pypi"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T21:50:01.196477+00:00","interface":{"has_rest_api":false,"has_graphql":false,"has_grpc":false,"has_mcp_server":true,"mcp_server_url":null,"has_sdk":false,"sdk_languages":[],"openapi_spec_url":null,"webhooks":false},"auth":{"methods":["Snowflake credentials (commonly via username/password, key-pair auth, or SSO depending on configuration)"],"oauth":false,"scopes":false,"notes":"Auth and scope granularity depend on how the MCP server maps agent requests to Snowflake roles/users. No evidence of OAuth/scope-based auth is provided here."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"As a package/MCP server, costs are primarily Snowflake compute/warehouse costs and any deployment/runtime costs; no pricing information is provided."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":39.8,"security_score":50.5,"reliability_score":30.0,"mcp_server_quality":55.0,"documentation_accuracy":45.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":45.0,"rate_limit_clarity":0.0,"tls_enforcement":70.0,"auth_strength":55.0,"scope_granularity":30.0,"dependency_hygiene":45.0,"secret_handling":50.0,"security_notes":"Security depends heavily on the deployed configuration (Snowflake role privileges, whether only read-only queries are allowed, how credentials are stored, and whether the MCP layer logs/prints secrets). Without evidence of fine-grained scopes, query allowlists, or robust secret handling details, scores are conservative.","uptime_documented":0.0,"version_stability":45.0,"breaking_changes_history":40.0,"error_recovery":35.0,"idempotency_support":"false","idempotency_notes":"SQL execution may not be idempotent depending on the statements allowed (reads are idempotent; writes are not). No explicit idempotency guidance was provided.","pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["SQL generation risks (agent may produce slow, expensive, or unsafe queries unless guarded).","Large result sets can overwhelm the agent/context unless the tool enforces limits.","Non-idempotent statements if the server allows DML/DDL."]}}