{"id":"pggm-mcp-snowflake-server","name":"pggm-mcp-snowflake-server","homepage":"https://pypi.org/project/pggm-mcp-snowflake-server/","repo_url":null,"category":"infrastructure","subcategories":[],"tags":["mcp","snowflake","database","data-warehouse","agents","sql"],"what_it_does":"An MCP server (pggm-mcp-snowflake-server) that connects an agent to Snowflake, exposing Snowflake-related capabilities as MCP tools so an AI agent can query and/or manage data in Snowflake via the MCP protocol.","use_cases":["Agent-assisted Snowflake querying and data retrieval (SQL generation + execution)","Snowflake schema exploration for agent workflows","Automating analytics/ETL preparation steps via agent-invoked Snowflake actions"],"not_for":["Direct production database administration tasks without guardrails","Use cases requiring strong, explicit tenant isolation guarantees unless the package enforces it","Environments where outbound network access to Snowflake is not permitted"],"best_when":null,"avoid_when":null,"alternatives":["Snowflake native connectors/APIs used directly by your application","Generic MCP database adapters (if available)","LangChain/LlamaIndex Snowflake integrations (depending on needs)"],"af_score":41.0,"security_score":41.0,"reliability_score":27.5,"package_type":"mcp_server","discovery_source":["pypi"],"priority":"low","status":"evaluated","version_evaluated":null,"last_evaluated":"2026-04-04T21:48:42.341339+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 (typically via username/password, key-pair, or OAuth/SSO depending on deployment)"],"oauth":false,"scopes":false,"notes":"Auth and authorization mechanisms are not provided in the supplied prompt content. For MCP-to-Snowflake servers, auth is typically implemented by accepting Snowflake connection parameters (or a secrets reference) and may require careful handling to avoid over-broad access."},"pricing":{"model":null,"free_tier_exists":false,"free_tier_limits":null,"paid_tiers":[],"requires_credit_card":false,"estimated_workload_costs":null,"notes":"No pricing information provided."},"requirements":{"requires_signup":false,"requires_credit_card":false,"domain_verification":false,"data_residency":[],"compliance":[],"min_contract":null},"agent_readiness":{"af_score":41.0,"security_score":41.0,"reliability_score":27.5,"mcp_server_quality":55.0,"documentation_accuracy":35.0,"error_message_quality":0.0,"error_message_notes":null,"auth_complexity":50.0,"rate_limit_clarity":20.0,"tls_enforcement":60.0,"auth_strength":45.0,"scope_granularity":20.0,"dependency_hygiene":45.0,"secret_handling":35.0,"security_notes":"Security posture depends on how the server accepts/stores Snowflake credentials and how it constrains operations (e.g., read-only vs write, query allowlists, row-level security). TLS is likely but not confirmed from the provided content. Scope granularity is unknown and should be considered weak until verified (e.g., a single broad Snowflake account/role).","uptime_documented":0.0,"version_stability":40.0,"breaking_changes_history":30.0,"error_recovery":40.0,"idempotency_support":"false","idempotency_notes":null,"pagination_style":"none","retry_guidance_documented":false,"known_agent_gotchas":["SQL generation mistakes can lead to runtime errors or expensive queries; ensure the server/agent adds safeguards (limits, allowlists)","Agents may not automatically respect Snowflake resource/warehouse settings; consider guardrails in the tool layer","If connection handling is stateless, repeated calls can increase connection overhead; cache/keep-alive may be needed (depends on implementation)"]}}